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. Image for the cookie policy date

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

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


5 Replies

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team April 11, 2023 07:51 AM UTC

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.




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


Regards,
Keerthi.


CZ CZ April 11, 2023 02:17 PM UTC

We will try this.


Thanks,

CZ



RS Ramya Sivakumar Syncfusion Team April 12, 2023 09:58 AM UTC

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


Regards,

Ramya



CZ CZ April 19, 2023 01:49 PM UTC

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




KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team April 20, 2023 09:30 AM UTC

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.


Loader.
Live Chat Icon For mobile
Up arrow icon