Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB.NET
|
VB.NET General VB.NET discussions for issues that don't fall into other VB.NET forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 9th, 2005, 05:30 AM
Registered User
 
Join Date: Oct 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to frosties777
Default Exporting Dataset to Excel

Hello,

I want to create an excel file from a dataset that i have generated.The problem I have is that Excel is not installed on my PC so creating the xls file by means of communicating with Excel.exe (OLE, ActiveX, ...) is not an option.

Installing Excel on the PC also isn't an option as i'm too poor to get one as i'm still a student.;)

So, in short, I'm looking for code/examples/dll's/third party toolkits that allow me to create an excel xls file from within my application.
Anyone can direct me in the right direction thanks
Thanks in advance for all the help!

Lawrence

 
Old December 28th, 2005, 03:42 PM
Registered User
 
Join Date: Nov 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Save the DS as a ".csv" file (comma seperated values). Excel will be able to open the file, and then Excel can save to .XLS format.

There are many 3rd party solutions of there (check for "spreadsheet" solutions), but they can be expensive.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting to excel michaeltanfeliz Beginning VB 6 2 May 3rd, 2008 05:26 AM
exporting to excel caveatashish Classic ASP Basics 0 November 3rd, 2006 05:08 AM
Exporting dataset to an Access File sujith_gokul ADO.NET 0 December 8th, 2005 03:57 AM
Exporting to Excel swhite Access VBA 2 September 18th, 2003 09:42 AM
Exporting to Excel JJ Access 1 June 9th, 2003 11:30 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.