Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot tables from ASP
I'm interested in generating pivot tables from an ASP page and to that end I created a pivot table in Excel and saved it as HTML. I've looked at the generated code and carefully stripped out everything that doesn't seem to be necessary for the functioning of the pivot table, but I have two questions:
1) where do I find documentation on all the tags that I can use in Excel and what they do? 2) the generated output contains an HTML table and a cache file that contains all the data... the cache file seems to be used for regenerating the table when the user modifies it (e.g. moving a column from side to top) and if I comment out the HTML table the pivot table still works... my question is: how can I ask Excel to display the pivot table the first time (because it doesn't automatically do so)? thanks in advance for any replies. - e |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot tables from ASP
Create in modul
Sub test() Workbooks(1).WebPagePreview end sub Run this. You can see the Excel Workbook in web browser. You set WebOption object: Workbooks(1).WebOptions "ekkis" wrote: I'm interested in generating pivot tables from an ASP page and to that end I created a pivot table in Excel and saved it as HTML. I've looked at the generated code and carefully stripped out everything that doesn't seem to be necessary for the functioning of the pivot table, but I have two questions: 1) where do I find documentation on all the tags that I can use in Excel and what they do? 2) the generated output contains an HTML table and a cache file that contains all the data... the cache file seems to be used for regenerating the table when the user modifies it (e.g. moving a column from side to top) and if I comment out the HTML table the pivot table still works... my question is: how can I ask Excel to display the pivot table the first time (because it doesn't automatically do so)? thanks in advance for any replies. - e |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |