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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Text to Columns of Excel in XlsIO

Thread ID:

Created:

Updated:

Platform:

Replies:

123868 Apr 28,2016 04:13 AM UTC Apr 29,2016 06:06 AM UTC ASP.NET Web Forms 1
loading
Tags: XlsIO
Danferd Lan
Asked On April 28, 2016 04:13 AM UTC

Hi,

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.

 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample1262017161

 

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.

Regards,

Ishwarya N

 


CONFIRMATION

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.

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

;