Text to Columns of Excel in XlsIO

[Danferd Lan]

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]

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

 

[Curtis]

Hello,

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.

[Karthikeyan Chandrasekar]

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. 

Sample link : http://www.syncfusion.com/downloads/support/forum/123868/ze/Text_To_Column-267247483.zip  

Regards, 

Karthikeyan