Need to extract entire content of excel as string

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.

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.