Is there any Library in C# to edit existing multiple sheets excel file?

[CZ]

Hi,

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!

Thanks,

CZ

[Konduru Keerthi Konduru Ravichandra Raju]

Hi CZ,

Syncfusion .NET Excel library helps you to work with Excel documents, in creation, editing, and conversion. Please go the below links to know more about the functionalities supported by our library.

Feature Tour: https://www.syncfusion.com/document-processing/excel-framework/net 

User Guide: https://help.syncfusion.com/file-formats/xlsio/overview 

Online Samples: https://ej2.syncfusion.com/aspnetmvc/Excel/Default#/bootstrap5 

Code snippets for inserting or deleting rows and columns are published under the below link in the user guide

https://help.syncfusion.com/file-formats/xlsio/worksheet-rows-and-columns-manipulation 

Regards,

Keerthi.

[CZ]

We will try this.

Thanks,

CZ

[Ramya Sivakumar]

Thanks for the update. We will wait to hear from you.

Regards,

Ramya

[CZ]

Hi Ramya,

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  "AF284",

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?

Thanks,

CZ

[Konduru Keerthi Konduru Ravichandra Raju]

Hi CZ,

We are unable to reproduce the reported issue at our end. The sample tried at our end can be downloaded from the below link.

https://www.syncfusion.com/downloads/support/directtrac/general/ze/F181669_MVC1639437160.zip

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.

Regards,

Keerthi.