When I try to convert a CSV to excel file using datatable approach, is it possible the rows might be shuffled? And even my headers are only appearing at the bottom? Is there any reason to this?
What I did - Steps
- Read csv to read the csv file
- store the output in datatable dt1
- use excel application scope
- write range to write the output to a new excel sheet
However when I see the output excel, data is generated but in random order. Is it possible? Moreover my headers are displayed as a last row. Why do you think this is happening?