Ignore a line in a CSV file

  • Thread starter Thread starter Emil
  • Start date Start date
E

Emil

Hi all,

is it possible to write a line in a CSV file in such a manner, that if
somebody open the file in Excel cannot read the line? I want to write
something like comments between lines, but this should not be visible in
Excel. For any idea thanks in advance.

Best Regards,
Emil
 
CSV files are plain old text files. So excel will see each line just like any
other.

There are ways that may work for you...

Rename the .csv file to .txt
Create a macro that opens the file (parsing the data the way you want).
Delete the lines you don't want to include in excel.

But if the lines are top secret, then this is not a good idea. Both .txt and
..csv files can be open in any text editor and viewed by anyone.
 
Back
Top