dump a multiple sheet excel file to a single text file

  • Thread starter Thread starter Lynn McGuire
  • Start date Start date
L

Lynn McGuire

Is there a way to dump a multiple sheet Excel file to a single
text file ? My understanding of CSV files is one CSV file per
sheet in the Excel file.

Thanks,
Lynn
 
You could combine the 4 csv files using an old DOS command.

Say you have 1.csv, 2.csv, ... 4.csv in a file called C:\myfiles

Open a command prompt window
Flying Windows key-r
type:
cmd
is one way of doing this

Traverse to that folder:
type:
c:
and hit enter

type:
cd \myfiles
and hit enter

Then type:
Copy 1.csv + 2.csv + 3.csv + 4.csv ALLFILES.csv
and hit enter

=========
Another option may be to copy all the data into a single worksheet and then do
your saveAs a CSV file.
 
You could combine the 4 csv files using an old DOS command.

Say you have 1.csv, 2.csv, ... 4.csv in a file called C:\myfiles

Open a command prompt window
Flying Windows key-r
type:
cmd
is one way of doing this

Traverse to that folder:
type:
c:
and hit enter

type:
cd \myfiles
and hit enter

Then type:
Copy 1.csv + 2.csv + 3.csv + 4.csv ALLFILES.csv
and hit enter

=========
Another option may be to copy all the data into a single worksheet and then do your saveAs a CSV file.
Click to expand...

Thanks, yes that is a good idea. I can write a C++ macro to dump
each Excel sheet to a separate CSV file then concatenate them.

Thanks,
Lynn
 
Is there a way to dump a multiple sheet Excel file to a single
text file ? My understanding of CSV files is one CSV file per
sheet in the Excel file.

Thanks,
Lynn
Click to expand...

Let it make one per. Not one workbook each. One worksheet within a
single workbook. Then concatenate them together.

Fill up some sheets willingly then, then add the contents of those
subsequent sheets to the first either by script or by hand.

When done, delete the sub-sheets and be left with sheet one all filled
up..
 
Back
Top