C# and Excel - How to deal with the data

Ismael Oliveira

Hi. I use Visual Studio 2022 and C# with forms. In my project I have to open an Excel spreadsheet and fill data. I'm using Microsoft.Office.Interop.Excel. What I need now is to add (or remove) a row in the spreadsheet programatically. Also need to change a row text font (size or color). Can anyone help me with this?
Thank you.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari4y ago
Accepted answer
Check the following link to add/update existing row. You can also perform text formatting programatically.
https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-excel-from-visual-c
+2
Ismael Oliveira4y ago
Hi, Muhammad.
Your suggestion helped me. But I didn't see how to add ou remove a row or a collumn. Do you know how to do it?
And is there a "manual" for the methods one can use in C# for Excel?
Thank you.
+1
Ismael Oliveira4y ago
Hi, Vishwakarma.
I know Sprire, and really there are good options. The problem for me is that it's not free.
Thank you anyway.
+1
Vishwakarma Vijay4y ago
Spire.XLS for .NET is a good alternative to Microsoft.Office.Interop.Excel. It offers a community edition for developers to create and manipulate Excel files for free.

Check the following link to find a set of comprehensive programming guide, which covers how to write data to an exsiting worksheet, how to add or remove a row and how to format text within a cell.

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Spire.XLS-Program-Guide-Content.html
+1