timmeh_041
New member
- Joined
- Jul 19, 2007
- Messages
- 2
- Programming Experience
- Beginner
Hey guys,
I have a datatable in memory (a flat file, no primary key or relation to other table) and I wish to make a pivot table in Excel out of it. I have been using the Excel COM, so I am hoping that there is a way to do it this way. I have seen code that will put data in a pivot cache via an SQL connection string, but I have yet to find anyway of using a datatable as is.
Creating a PivotTable Programmatically - Andrew Whitechapel - Site Home - MSDN Blogs
The above link has everything I want to do, but I can't find exactly how to use a datatable as the source.
Any ideas? I am really open to anything, but it would be great if it could be done with the use of an Excel COM.
Thanks a bunch
Tim
I have a datatable in memory (a flat file, no primary key or relation to other table) and I wish to make a pivot table in Excel out of it. I have been using the Excel COM, so I am hoping that there is a way to do it this way. I have seen code that will put data in a pivot cache via an SQL connection string, but I have yet to find anyway of using a datatable as is.
Creating a PivotTable Programmatically - Andrew Whitechapel - Site Home - MSDN Blogs
The above link has everything I want to do, but I can't find exactly how to use a datatable as the source.
Any ideas? I am really open to anything, but it would be great if it could be done with the use of an Excel COM.
Thanks a bunch
Tim
