We use vue as client and C# MVC as Web server, we need to edit a large excel file in server side, include add rows, delete rows. edit cells, is there any library we can use, if yes, please give us an example!
We will try this.
Thanks for the update. We will wait to hear from you.
I try to use this Excel component, performance is good. right now there is one thing we can't figure out, please help us.
In the Excel, We insert a lot of number cell which we need to format, for example cell
this value is 20372.511, we want to show as 20,373 , so we apply format rule
worksheet.Range["AF284"].NumberFormat = "_(* #,##0_);_(* (#,##0);_(* \"-\"??_);_(@_)";
when I open the Excel file after I save it, it doesn't apply these rule by default, see my below screen shot
but after we click "AF284", the format rule are apply, this cell show are correctly,
How can we apply all the format rule when we saved the Excel file, so it will show correct format when we open it?
We are unable to reproduce the reported issue at our end. The sample tried at our end can be downloaded from the below link.
We suspect that you are trying to set the value to cell using Text property and this could also be the reason for the issue.
Kindly share an issue reproducing sample along with input Excel document if any and confirm the Syncfusion XlsIO version you are using at your end, to investigate the query further.