Use perl to add the column headers, use perl to run the queries and add them to the file you put the column headers into... Import the csv file into calc.....
(Probably adds one more line to your perl script(?) WPH 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
