Using MS Excel from VB.NET

[crom]

My program generates a set of names and numbers, and exports them to an Excel spreadsheet via a comma separated file. I have managed to do this dynamically using GetObject.

Is it possible to manipulate the resulting instance of Excel from the calling program? For example, to reformat the columns, add sums and counts etc.

 

[mickwen]

There is .net component called Spire.DataExport, Free download.
It's may useful to you.
http://www.e-iceblue.com

 

[vis781]

x

mickwen, this is your third post 'advertising' this component I've checked it out and it's quite expensive. Now, maybe you are just very happy with this product that you bought, or maybe you are spamming advertisements. Either way you have made three posts, and each one has contained a link to that site. This is a forum for providing useful answers to people with genuine questions not one for saying just go and buy a product that will do it, especially if it is not even in the correct forum. You have been warned.

 

[crom]

Thanks mickwen

I have downloaded the Spire.DataExport free trial. I hope it's worth buying at $199!