Export to MS Excel

[Phoon Chee Keong]

Hi, Anyone know how to export to excel? Any example that I can refer?


Regards,
PCK

 

[Francois Beaussier]

Hello,

You will need to use either office primary interop assemblie (pia) or a
third party software.

Here is an exemple of using pia :
http://www.daveranck.com/SoftwareDownloads/262.aspx

 

[Amnon]

In VB6 I used the FarPoint Spread 7 which is great for exporting to Excel
AND very very fast.

I will be trying it in VB 2005.

One of the great advantages is it knows how to build a multi-worksheet Excel
file with the formatting that you code onto the spread. You simply build a
'tabbed spread' instance with data, formula and formatting and use an
ExportToExcel method that does all the difficult things for you. Pivot
tables and some other Excel functionality is not supported.

Disadvantage - It costs money.

Disclaimer - I am a programmer and have no connection with FarPoint but use
the ActiveX Spread 7 extensively in a VB6 financial application

Garry