I'm trying to automate this. Editing files defeats the purpose. The CSV file are generated when a Perl script makes some SQL queries and spools the output to a file.
On 9/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
