Export Excel to text

[Nic Adams]

Hi I need to export an Excel spreadsheet to a text representation. Is there an easy way to do this? If not can you tell me how I can access the value or calculated value of each used cell in a worksheet so I can build up my own export.

TIA

Nic

[Prakash Kumar D]

Hi Nic, 

 

Thank you for contacting Syncfusion products. 

 

Please find the details below.  

  

Queries	Details
I need to export an Excel spreadsheet to a text representation. Is there an easy way to do this?	Yes, you achieve your requirement in XlsIO by saving it as space separated text document. We have shared the sample for your reference.  Sample Link : http://www.syncfusion.com/downloads/support/forum/138523/ze/SaveAsText-825867066.zip
If not, can you tell me how I can access the value or calculated value of each used cell in a worksheet, so I can build up my own export.	You can access the value and calculated value of a cell by using the following code example.    Code Snippet:  //Accessing cell’s value or calculate value  worksheet.EnableSheetCalculations();  string value = worksheet["A1"].Value;  string calValue = worksheet["A2"].CalculatedValue;

  

 

Regards, 

Prakash Kumar 

[Pon Geetha A J]

Thanks Prakash, 

 

That was a beautifully simple solution. 

 

Nic