Excel Pivot tables in vb.net

  • Thread starter Thread starter nikila
  • Start date Start date
N

nikila

Hi,

I have to create excel pivot tables from vb.net. Already I am creating excel
file using oledb connection. I want to use the same to create the excel
pivot tables. Can anyone please help me on this. It is very urgent. Please
reply immediately

Thanks for the help!!!!

nikila
 
Hi,

Thanks for your reply. But I have to generate excel sheet(file) which
has pivot tables
in it from vb.net using oledb

Thanks for help!

Nikila
 
ALso, Is there a way I just use oledb connection instead of
"EXCEL.APPLICATION" etc for creating excel pivot tables in VB.nET.

uses --
"Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=""Excel
8.0;HDR=Yes;"";Data Source="filename"

Final output file is - It is an excel file which has pivot tables and
does not use excel automation"

Thanks for help !

Nikila
 
Back
Top