Generate text file using Aspose.Cells

[Dhivya]

Hi,

I am using Aspose.Cells.dll for .Net version 7.0.3.0 to generate text file from the excelbook. If the excel sheet contains only shape collections, it is generating the empty text file. It is not extracting the text in the shapes.Please find the below code to generate the text file.

Workbook _workBook;

_workBook = new Workbook(fileName, loadOptions);

_workBook.Save(@"C:\test.txt", SaveFormat.TabDelimited);

I have attached the sample excel document for your reference.

Thanks,

Dhivya

[Amjad_Sahi]

Hi,

Do your steps in MS Excel manually:

1) Open your XLSX file into MS Excel 2007/2010.

2) Save as the file to “Text (Tab Delimited)”.

Now open the saved txt file into notepad, you will see a blank file. Aspose.Cells does the same thing. So, in short, this is not possible, i.e. convert Shapes or its text to be saved as txt file.

Thanks for your understanding!

[Dhivya]

Hi,

How to create encoded txt file using Aspose.Cells.dll for .net from unicode Excel documents.

Thanks,

Dhivya

[shakeel.faiz]

Hi,

I think, that’s not possible, because text format does not support encryption.

You should xls/xlsx format.

[Amjad_Sahi]

Hi,

Do you need to set encoding for your generated Excel / text file. I think you may try to use the line e.g:

workbook.Settings.Encoding = __________ --> to set your desired encoded for the saved file.

Thank you.