We help IT Professionals succeed at work.

How to produce an excel file from code?

efim
efim asked
on
Medium Priority
211 Views
Last Modified: 2011-09-20
I need to produce an excel file out of text data. How can I do it? Links to some helpfull information would help. The data is quite simple so the resulting excel sheet will be simple.
Comment
Watch Question

Here is a beautiful tutorial (Visual C++) on automating excel.
http://support.microsoft.com/support/kb/articles/Q179/7/06.ASP

If you cannot use Visual C++, I suggest you put the data in a standard text file separated by tabs (or commas).
When the data is loaded into Excel, it will be treated as a spreadsheet.  Any numbers to be treated as text should be placed in "quotes".

If you want a reverse example, save a spreadsheet from Excel as a CSV (comma separated values) or as a text file.
Open the file in a text editor and see how they do the trick.
Are you using Visual C++?

Commented:
Answer accepted by:

ComTech
Community Support Moderator

Explore More ContentExplore courses, solutions, and other research materials related to this topic.