Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CAN YOU SEND RESULTS TO AN EXCEL STYLE FILE?
- Thread starter ankoump
- Start date
Donger
Programmer
- Oct 3, 2002
- 1
You can output your data like this:
Say for instance I am compiling names of people, their birthdates and their ages. I would save the output to a text file, birthdays.csv that looked like this.
John,6/24,28
James,8/19,26
George,5/9,28
...
.csv stands for comma separated values. Microsoft Excel can read these files and places each entry into its own cell. Entries are separated by commas and null characters.
I could explain better but I've got something to look for.
Say for instance I am compiling names of people, their birthdates and their ages. I would save the output to a text file, birthdays.csv that looked like this.
John,6/24,28
James,8/19,26
George,5/9,28
...
.csv stands for comma separated values. Microsoft Excel can read these files and places each entry into its own cell. Entries are separated by commas and null characters.
I could explain better but I've got something to look for.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question