At 16:36 04/09/2007 -0700, Aaron Kulbe wrote:
I have separate CSV files that are being imported into a
spreadsheet, each on a separate worksheet.
They all import starting on row 1.
What I would like to do is have the column headers frozen on row 1,
and the import starting on row 2.... so I know what columns are what.
However, when I import, even if I have the label names frozen in row
1, the import overwrites them, and the labels in row 1 gets
overwritten by the data in row 1 of the CSV file. is there a way to
make the import filling in the worksheet at row 2?
Does my description make sense? and is it possible?
Yes: it makes sense. As far as I can see, there is no way to do this.
Some workarounds:
o Import the CSV material to a temporary sheet, select the relevant
rows (click on row 1's row label and Shift-click on the row label of
the last useful row), copy them, and paste them in the right place on
the right sheet.
o Import the CSV material first, right-click on row 1's row label,
and choose Insert Rows. Now copy the row of column headers from
another sheet and paste it into the new, blank row 1.
o Create a plain text file with the column headers in appropriate
format. Concatenate this file with your CSV file, using your
operating system's functionality. Now import the modified CSV file.
o (Best of all?) Modify whatever creates the CSV files to include
the column headers you need.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
