On Tuesday 04 September 2007 19:36:27 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? > > Thanks, > > Aaron Kulbe
Yes, open the CSV files in a text editor (it would be easier from a non-windows box) add the information you want in row 1 above what is in the CSV file already (follow the current format that you see) then save it and import it. -- http://24.197.142.167/ See the OpenOffice.org FAQ Microsoft users go to http://www.pclinuxos.com for a great user friendly Linux experience! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
