This content has been marked as final. Show 6 replies
Hello TabbyW -
From Excel, export each worksheet separately as HTML - give each a different name but save in the same location.
Open your RH project.
Import each of the HTML worksheets from their saved location into your project - they will show up in the project root folder (see Project Manager View).
Create a new topic, give it a title, insert several (at least three) carriage returns (put in some blank line), add it to your TOC.
Return to PM view and open the first imported worksheet file. The spreadsheet will be "enclosed" - select the entire "enclosure", copy, open the newly created topic, go to next-to-last blank line and paste the table.
Repeat as need.
Delete the imported HTML worksheet files from your project (using RH to delete, not Windows Explorer!).
I tried your suggestion, GEWB, but when you paste, you lose the text formatting, which is a pain to edit for each of these 11 worksheets EVERYTIME they update the spreadsheet (about once a month). But, at least you've given me an alternate solution, in case too many folks complain about not having Excel.
Thanks so much!!
You might be able to overcome lost text formatting with a style sheet. RoboHelp HTML has built-in support for style sheets. You can create one or many. If the table formatting is relatively simple (e.g., a particular font face or size throughout the table), you can set a style for the entire table. If the formatting is complex, a style sheet is less likely to help.
Hello Tabby -
As my sig implies - can't get there from here.
You are formating in the cells of an Excel spreadsheet and you really expect to export>import into HTML and retain the formating? Not going to happen (not even in Word).
If it is that important to keep the cell formating you should create a PDF and just hyperlink to the PDF. Keep the sheet name the same version-to-version so all you do is upload the PDF file - no need to change links.
Yeah, I'm beginning to think you're right. I was just hoping I could be proven wrong - it just seemed like there should be a easier way, since Excel can get you half of the way there by generating HTML code. And I don't like how the PDF version paginates - it's like 34 pages! Oh well! Thanks for your help...all of you!