We converting large data set ( more than 50 lakh rows) from csv to excel in multiple sheets, however, header is only coming in first sheet. Please provide a solution to handle this
If your CSV file has header columns in the very first row (for example, at the top only), surely when you convert it to Excel worksheets in the workbook, the headers would be pasted only once (same as CSV file data). I think you can easily cope with this by inserting a blank row at the 0 indexed position in every other worksheet and manually copying the header row from first sheet to the other sheets before finally saving to an Excel file. Please refer to the document on how to copy rows for further guidance.
https://docs.aspose.com/cells/net/copying-rows-and-columns/
In case you still encounter any issues, please share your sample CSV file and a sample of your runnable code for evaluation. We will review your issue and assist you in accomplishing your task.
We will evaluate your requirements on keeping header row to each worksheet when converting CSV to Excel. Once we have an update on it, we will let you know.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in support policies.
Issue ID: CELLSNET-54219
Hi,
Any update on this. Headers are only printed once while converting CSV to excel - any fix released?
@amdhawan
No updates on your issue. Once we have any new information, we will share it with you. We will get back to you soon.
Thanks for update- could you please let me know when is fix planned to release? – which release (Dec 23, March24…?) version
Best wishes,
Amit Dhawan
We have not evaluated your desired feature yet. But we will look into it (we may provide an option to support your needs) and share an ETA (if possible) on your desired feature/issue. We will get back to you soon.
@amdhawan
We will try to support this option in next release 24.1 which may be released in the second week of Jan 2024
This is to inform you that your desired feature (logged a ticket earlier as “CELLSNET-54219”) has been implemented now. The fix/enhancement will be included in our upcoming release (Aspose.Cells v24.1) that we plan to release in the first half of this month. You will be notified when the next version is published.
Please note, from Aspose.Cells v24.1, we will provide new options to support such kind of requirements:
TxtLoadOptions.HeaderRowsCount/HeaderColumnsCount
Users may set them to specify the header rows/columns when importing csv data.
The issues you have found earlier (filed as CELLSNET-54219) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi