Text file Excel Conversion

Aspose.Cells Product Family
1

Hi Team,





I have a requiremtn like below.

We have text file (.log) its a space delimited file.

I need to export this into excel as we do manually from excel.

Is there a way we can do this using Aspose.Cells.



We are using Aspose.Cells for .Net.



Please help me on this.

2

Hi,


Thanks for your query.

Well, you may simply load/open your log file as text file format (e.g CSV, Txt, etc.) using Aspose.Cells’ document object model (DOM) via its APIs, see the documents for your reference:

and then use Workbook.Save() overloaded method to save it to your desired Excel file format, e.g XLS. XLSX, etc., see the document for your reference:

Hope, this helps a bit.

Thank you.

3

Thanks A lot Amjad…

it worked like a Gem… :slight_smile:

4

Hi,



I Need your help again… I was able to save the file which are around 3MB. but when I tried for the bigger files I got the below error (>50MB)



While creating workbook object with log files as parameter.

“This file’s format is not supported or you don’t specify a correct format.”

Please help me

5

Hi,


Please make sure you are using a valid .txt file. If you still think it is a valid .txt file, kindly do zip it and post us here, you may upload it to some free file storage drive and share the URL to download it here. We will check it soon.

Thank you.
6

No Its worked fine.

7

Hi,


It looks like your issue is sorted out now. Feel free to contact us any time if you need further help or have some other issue or queries, we will happy to assist you soon.

Thank you.