By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,969 Members | 2,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,969 IT Pros & Developers. It's quick & easy.

Export to MS Excel

P: n/a
Hi, Anyone know how to export to excel? Any example that I can refer?
Regards,
PCK

Jan 11 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

--
Francois Beaussier

"Phoon Chee Keong" <da******@streamyx.com> a écrit dans le message de news:
Op**************@TK2MSFTNGP15.phx.gbl...
Hi, Anyone know how to export to excel? Any example that I can refer?
Regards,
PCK

Jan 11 '06 #2

P: n/a
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
"Phoon Chee Keong" <da******@streamyx.com> wrote in message
news:Op**************@TK2MSFTNGP15.phx.gbl...
Hi, Anyone know how to export to excel? Any example that I can refer?
Regards,
PCK

Jan 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.