Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import HTML reports into Excel with page formatting options
I want to import HTML reports into separate worksheets in Excel 2002
and have separate page formatting options for each worksheet. I can put the reports into separate worksheets using XML (WorksheetSource), but I can't get my page formatting to work. I tried to use XML, but couldn't get the formatting to work in Excel. I have the margins working in the HTML report using a style sheet with @page and margin and the report centered horizontally and vertically. I still need to change the orientation to landscape and to fit the report on one page. I use Excel to open a file with the XLS extension, but it is really an HTML file with XML code in it. It opens two HTML reports into separate worksheets using XML. I can send my HTML/XML code if you want to review it. Any help would be appreciated. It would be great if you could send an working example for the HTML or XML methods. Thanks. Joe McCormick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SET UP TO IMPORT REPORTS FROM SAGE TO EXCEL W/BOOK | Setting up and Configuration of Excel | |||
Import from html web page of index list to spreadsheet | Excel Discussion (Misc queries) | |||
How to import html file in excel 2007 | Excel Discussion (Misc queries) | |||
Import Reports in .txt format | Excel Discussion (Misc queries) | |||
How to import data from daily reports (excel) into excel database | Excel Discussion (Misc queries) |