Board index » Visual Studio » Export DataReport to Excel format

Visual Studio343
Hi. I am looking ofr help on how to export a datareport into

an excel .xls format. As far as I can see with Visual Studio 6 you can not export directly to excel. How can I write code to do an export.


-

Sean Kelly wrote:

First off, chill dood!!! Asking once would be enough... :)



Simple answer is "can't"--simply by "exporting". To write an Excel

format file would require writing--well, and Excel format file. I'm

pretty sure the format is not publically published by MS altho there are

probably hacked formats available on the web and there may well be a

control/interface somewhere that can do so.



The normal way would be to either write a csv file and import that to

Excel or use a connection to Excel to populate the sheet with the

data...it would probably be more expedient to ask the question in an

Excel group as well.



Of course, what VS 6 has to do w/VB specifically is also another

question??? Did you mean VS or VB?

-