The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
INIshwarya Narayanan Syncfusion Team 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.
Regards,
Ishwarya
N
CUCurtisFebruary 17, 2019 10:12 PM UTC
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.
KCKarthikeyan Chandrasekar Syncfusion Team 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.
