Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi ,PLEASE help me to create programmaticly pivot table from web query
My code for creating table query : Excel.Worksheet ws = new Excel.WorksheetClass(); string strCellAddress = applicationObject.ActiveCell.get_Address(1, 1, Excel.XlReferenceStyle.xlA1, System.Type.Missing, System.Type.Missing); ws = (Excel.Worksheet)applicationObject.ActiveWorkbook. ActiveSheet; object async = false; Excel.Range rngDestination = applicationObject.get_Range(strCellAddress, System.Type.Missing); object connection = "URL;http://someUrlHere..."; Excel.QueryTable tblQuery = ws.QueryTables.Add(connection, rngDestination, System.Type.Missing); tblQuery.BackgroundQuery = true; tblQuery.TablesOnlyFromHTML = true; tblQuery.Refresh(async); tblQuery.SaveData = true; this code is fill excel with data .And I want to create from it pivot table without filling excel with data.Is it possible? help me please, smugliy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How can I get VBA to create a table or run a query in MS SQL? | Excel Programming | |||
Using Macros to create pivot tables - query re last row | Excel Programming | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |