Excel Pivot tables in vb.net

20 Mar 2006 3:37 AM

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

20 Mar 2006 7:42 AM

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

Show quoteHide quote

"nikila" <niki***@yahoo.com> schreef in bericht
news:eDokO%238SGHA.1868@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
>

20 Mar 2006 12:43 PM

nikilav

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:
Show quoteHide quote

> 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" <niki***@yahoo.com> schreef in bericht
> news:eDokO%238SGHA.1868@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
> >

20 Mar 2006 6:53 PM

nikilav

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

niki***@yahoo.com wrote:
Show quoteHide quote

> 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?ID=28f49f7c-ec40-4472-9b28-2b9e762316ab
> >
> > I hope this helps,
> >
> > Cor
> >
> >
> > "nikila" <niki***@yahoo.com> schreef in bericht
> > news:eDokO%238SGHA.1868@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
> > >