Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments in CSV
Hi
I am creating a CSV (comma seperated) file from a database so users can import in excel etc. Basically the file contains rows of data. I want to add a header/comment to the file (Preferably formatted html) to maybe have information such as selected fields user date etc for the data. Is there any way to comment stuff out in csv so that wen importing excel doesnt treat it as import data (looking for column delimiters etc) thanks :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments in CSV
A .csv file is just a plain text file. If you put stuff in that file, excel
will find it. But you could use some sort of macro to import the file and clean up the stuff that doesn't belong. But then you'll have to distribute that workbook with the macro and train the users how to import the .csv file using that macro. Katie wrote: Hi I am creating a CSV (comma seperated) file from a database so users can import in excel etc. Basically the file contains rows of data. I want to add a header/comment to the file (Preferably formatted html) to maybe have information such as selected fields user date etc for the data. Is there any way to comment stuff out in csv so that wen importing excel doesnt treat it as import data (looking for column delimiters etc) thanks :) -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments in CSV
You could format your data as html instead and give it a xls extension.
Excel should open it OK and it allows you to add some formatting. -- Tim Williams Palo Alto, CA "Katie" wrote in message ps.com... Hi I am creating a CSV (comma seperated) file from a database so users can import in excel etc. Basically the file contains rows of data. I want to add a header/comment to the file (Preferably formatted html) to maybe have information such as selected fields user date etc for the data. Is there any way to comment stuff out in csv so that wen importing excel doesnt treat it as import data (looking for column delimiters etc) thanks :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
Comments box | Excel Worksheet Functions | |||
Comments | Excel Discussion (Misc queries) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Comments | Excel Programming |