Excel Pivot tables in vb.net - Visual Basic .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

Mar 20 '06 #1

Subscribe Post Reply

8411

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?...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

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:

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

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
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

Similar topics

Access -> Excel Automation Slow

by: Mark Day | last post by:

Hi All, I am using Access 2000 to generate over 40 Excel charts and pivot tables using early binding to the Excel 9.0 object library. I am finding that if I show the Excel object while processing...

Microsoft Access / VBA

Suggestions: Best Way to Integrate Excel with Access - Pivot Tables

by: Johnny Meredith | last post by:

Dear All, I have an Access database that tracks the progress of income tax audits. When the taxing authorities make a change (an "Adjustment"), I record the pertinent information in the...

Microsoft Access / VBA

Using Excel components

by: [Yosi] | last post by:

Can I make an Excel file without having Excel in my PC ? I want to create Excel files from my C# application , then open those files later in another PC who have Excel installed . As we can open...

C# / C Sharp

Pivot Tables Access vs Excel

by: Jerome Ranch | last post by:

I consider myself an Excel PT wizard of sorts, but now I have a situation with so much infromationthat I need to categorize and summarize, that I will use access to manage it. Interestingly,...

Microsoft Access / VBA

trying to copy an Access 2003 pivot table to excel or word .... or something

by: Jerome Ranch | last post by:

Okay So I've got pivot tables setup in Access 2003. Only about 30K records in the current 2005 databases...the pivots summarize the info in a number of nice ways. I need to get the pivot tables...

Microsoft Access / VBA

Converting excel to Access

by: Decreenisi | last post by:

Hi, I have to convert an existing spreadsheet for rejects into an access database. My problem is I use a load of lookup tabels in excel. How do I approch this in access. Also, just a general...

Microsoft Access / VBA

Excel Pivot Table timing issue

by: Bill Stock | last post by:

I'm rebuilding a query for some Excel Pivot Tables, loading the Excel Workbook and then running a macro in the Excel WB to rebuild the dynamic column names. This all works, except that sometimes...

Microsoft Access / VBA

Export PivotTable Access to Excel

by: VitorCastro | last post by:

Hello... First, sorry for my bad english... i have generated many pivot tables in Access 2003. and i want the code to export all of them to one single excel sheet and specific cell. i have...

Microsoft Access / VBA

New to Excel

by: DeanL | last post by:

Hi guys, I'm fairly fluent in MS Access but I've been handed a task that is baffling me. I've been asked to produce a report(s) in Excel that has a series of sales by territory. I have a bunch...

Visual Basic .NET

How to Use CodiumAI's pr-agent?

by: erikbower65 | last post by:

Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...

General

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

How to insert a new record in a database

by: Taofi | last post by:

I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...

DB2 Database

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

To verify entry of a dropdown

by: DJRhino | last post by:

Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...

Microsoft Access / VBA

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How does React native implement an English player?

by: lllomh | last post by:

How does React native implement an English player?

Mobile Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA