PC Review


Reply
Thread Tools Rate Thread

How to create pivot table from web query

 
 
Smugliy
Guest
Posts: n/a
 
      13th Feb 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Create Pivot table from another pivot table =?Utf-8?B?VG9tIEJlcmdtYW4=?= Microsoft Excel Discussion 5 17th Nov 2007 12:51 AM
How to create report from Pivot Table View of Union Query? hongluen via AccessMonster.com Microsoft Access Reports 3 28th Mar 2007 05:54 AM
how to create pivot table from existing pivot table in excel 2007 =?Utf-8?B?VWRheXJhaiBEaHVsZWthcg==?= Microsoft Excel Misc 1 15th Dec 2006 04:23 AM
How do I create a pivot table if the pivot table icon or menu ite. =?Utf-8?B?THlubkBXUw==?= Microsoft Excel Charting 1 16th Dec 2004 02:36 AM
Export query to Excel and create pivot table Chris Microsoft Access VBA Modules 1 9th Feb 2004 03:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:31 AM.