Ignoring comment line in a CSV
I am using a program to generate a CSV that I will read in Excel (I am using 2007). I'd like to be able to write comment lines in the file that are ignored by Excel when it opens. Is this possible?
For example maybe the CSV would look something like this if the "#" symbol could denote a comment:
# this was created May 9th
col1,col2,col3
4,5,6
6,4,9
Any help would be greatly appreciated!
I would think it's much less maintenance to simply open the CSV file and delete the lines with # at the beginning.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks