We help IT Professionals succeed at work.

How to produce an excel file from code?

efim asked
Medium Priority
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.
Watch Question

Here is a beautiful tutorial (Visual C++) on automating excel.

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++?

Answer accepted by:

Community Support Moderator

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