By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,261 Members | 2,662 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,261 IT Pros & Developers. It's quick & easy.

Excel Pivot tables in vb.net

P: n/a
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
Mar 20 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?...8-2b9e762316ab

I hope this helps,

Cor
"nikila" <ni*****@yahoo.com> schreef in bericht
news:eD****************@TK2MSFTNGP09.phx.gbl...
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

Mar 20 '06 #2

P: n/a
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

Cor Ligthert [MVP] wrote:
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?...8-2b9e762316ab

I hope this helps,

Cor
"nikila" <ni*****@yahoo.com> schreef in bericht
news:eD****************@TK2MSFTNGP09.phx.gbl...
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


Mar 20 '06 #3

P: n/a
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
ni*****@yahoo.com wrote:
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

Cor Ligthert [MVP] wrote:
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?...8-2b9e762316ab

I hope this helps,

Cor
"nikila" <ni*****@yahoo.com> schreef in bericht
news:eD****************@TK2MSFTNGP09.phx.gbl...
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


Mar 20 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.