Need to extract entire content of excel as string

[nskarthi]

Hi Team,

I have a requirement which I need to extract all the content of excel sheet as a single string ( as we do in aspose.words getText() method). Is it possible to get the content of the entire excel worksheet as string). Thanks in advance.

Thanks and Regards,

Karthikeyan N.S.

[amjad.sahi]

Hi,

Well, I think you may try to save the spreadsheet to TEXT file format, see the following sample code for your reference:

e.g

Sample code:

//Load the template file.

Workbook workbook = new Workbook(strFilePath);

//Instantiate Text File’s Save Options

TxtSaveOptions options = new TxtSaveOptions();

//Specify the separator if you want.

// options.Separator = Convert.ToChar(";");

//Save the file with the options

workbook.Save(“e:\test\abc.txt”, options);

Thank you.