How to store multi worksheet in a txt file?

[Robert]

I want to use a txt file to store several
sheets.According to MS,one txt file can only store a sheet.
who can tell me how to do?
Thanks very much!

 

[Dave Peterson]

If you do File|Save As, you can specify .CSV, .Txt, .Prn.

Each of these only save the activesheet. If you really want just one ASCII
file, you'll have to combine the worksheets into a giant worksheet and save
that.

Or combined the ASCII text files after you've saved the individual sheets.

 

[Dave Peterson]

If I combined the ASCII text files after I've saved the
individual sheets,when I opened the combined file again
using Execl ,I would have got only a sheet.What I really
want to get is multi sheets.How can I do ?

I use a SCM(Singlechip) to capture data,the data can be
devided into several kinds. The programming language used
is C. I want to write a text file which include all kinds
of data,then transmit it to windows platform in which
Execl can handle the file, one sheet carrying one kind of
data .In a word ,I want to write a text file with C and
read it by Execl in which i could get multi sheets.
Can you help me?
thanks very much!

best regards.

 

[Dave Peterson]

You can use your own email and name when you reply to messages.

But when you save to a text file, you lose multiple worksheet capability. Maybe
you could save to individual files and then open them?

Or maybe you can import the whole file and then separate it from there. Add a
key indicator to your text file for "worksheet" separation. Then inside excel,
look for those keys. If you find one, then add the next set of data to the next
worksheet.