I have a program which converts excel file to a CSV format. I use Microsoft.Office.Interop.Excel for this and the program is in .NET.
Following scenario works perfectly fine
1) create an excel file with 10 rows of data, and give it to my program, it will save it properly and the CSV file has 10 rows.
Following scenario DOES NOT work.
To the excel file above, insert an empty row on the top, as the first row. Now save this excel file and give it to the same program. Now the CSV file saved does not have the first empty line.
The excel file has 11 rows (1 empty row in the beggining and 10 datarows)
The CSV file has only 10 data rows.
How to resolve this issue? I want the CSV file to exactly represent what the Excel file is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks