How can I generate Text file of Excel with custom data

Aspose.Cells Product Family
1

I need to generate text file of excel, with Bello’s information

  • Header and Footer
  • Comments
  • worksheet Name
  • Cell data

Please prove the solution to generate a file with the above information

2

@hemalp
Please documents:
1,Setting Headers and Footers|Documentation
2,Manage Comments and Notes|Documentation
3,Manage Worksheets of Microsoft Excel files.|Documentation
4,Manage data of Excel files|Documentation

3

@simon.zhao
I already have Excel file, My Question is if I need bellow information in a text file (.txt) then how can I generate it (.txt file from excel file)?

  • Header and Footer
  • Comments
  • worksheet Name
  • Cell data
4

@hemalp,

Please note, when you save an Excel workbook (e.g., XLS/XLSX) file to text (Tab delimited, CSV, etc.), headers/footers, comments and other certain (binary) objects would be lost. Since TXT/CSV files are simple text/string files, so all binary objects cannot be kept and would be lost. Also, this is MS Excel’s behavior (and nothing to do with Aspose.Cells) as you may simply test your scenario/case in MS Excel manually and you will see the same results. For your task, you may manually insert your header text at the start (you may insert a blank row at the start of the sheet and then add header text in the cell(s) accordingly) Similarly, you can add footer text after the last (data) row of the sheet. You may add comment text at your specified position or at the end of the sheet. For worksheet name, you would manually insert the sheet’s name at your desired location (either at the start or after the end (data) row in the sheet). Now convert or save the Excel workbook to text or CSV file format via Aspose.Cells, so you will get your desired results in the output text or CSV file.

Hope, this helps a bit.