We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Text to Columns of Excel in XlsIO

Thread ID:





123868 Apr 28,2016 04:13 AM UTC Feb 18,2019 09:51 AM UTC ASP.NET Web Forms 3
Tags: XlsIO
Danferd Lan
Asked On April 28, 2016 04:13 AM UTC


Is there any way to format value of a column in such value, "5E+12" to "05000001020770"? Or is there a feature like Text to Columns of Excel in XlsIO?

Ishwarya Narayanan [Syncfusion]
Replied On April 29, 2016 06:06 AM UTC

Hi Danferd, 

Thank you for contacting Syncfusion support. 

Please find the details for the reported queries in the below table. 

Is there any way to format value of a column in such value, "5E+12" to "05000001020770"? 

Yes, you can format a value as per your requirement in XlsIO by applying NumberFormat for the range as 0. The below code example illustrate the behavior.


 Code Example:

worksheet.Range["B4"].NumberFormat = "0"; 


We have prepared a sample as per your scenario in the below link. Kindly try this and let us know if it helps.




Is there a feature like Text to Columns of Excel in XlsIO

We regret to let you know that currently we do not have support for Text to Columns in XlsIO. However, we have added it to our Feature request list and it will be implemented in one of the upcoming releases.     

Please let us know if you need any concerns.


Ishwarya N


Replied On February 17, 2019 10:12 PM UTC


I was wondering if text to columns was ever implemented for Xlsio. I have not been able to find any data on it although this was some time ago.

KarthikeyanC [Syncfusion]
Replied On February 18, 2019 09:51 AM UTC

Hi Curtis, 
We don't have any immediate plans to implement this feature. However, we have prepared a workaround sample to change the cell value from "5E+12" to "05000001020770" which can be download from the following link. 



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon