Excel Pivot tables in vb.net

[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

[Cor Ligthert [MVP]]

Nikila,

I don't remember me what was a Excel Pivot table. Know that you reach a
small audience with using specific names from other technologies in a
newsgroup, which is not about that technoligy.

However, maybe is this sample on our website your answer.

http://www.vb-tips.com/default.aspx?ID=28f49f7c-ec40-4472-9b28-2b9e762316ab

I hope this helps,

Cor

"nikila" <nik...@yahoo.com> schreef in bericht
news:eDokO%238SGH...@TK2MSFTNGP09.phx.gbl...

[nik...@yahoo.com]

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

[nik...@yahoo.com]

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