Hi all,

Is there a way to save a regular Excel worksheet in csv format, but the resulting csv file, when opened in the Notepad, would not contain rows and/or columns that are hidden?


Original file:
RP 2 AAA-911-111 38.70 000010
RR 2 DDD-000-000 52.00 000034 (HIDDEN ROW)
RR 1 BBB-000-000 110.00 000034
RR 1 CCC-456-321 130.00 000029


When saved as csv file (second row is skipped):
RP,2,AAA-911-111,38.70,000010
RR,1,BBB-000-000,110.00,000034
RR,1,CCC-444-321,130.00,000029

Thanks !
DannyV