This project has moved and is read-only. For the latest updates, please go here.

Can I update excel sheets?

May 28, 2014 at 2:41 PM
Edited May 28, 2014 at 2:42 PM
I will make this quick. I have an excel file with 8 sheets, 3 of which I need to import into my C# form. My program takes the 3 sheets from the excel file and imports the 3 sheets onto 3 new tabs on a tabControl. Each new tab also had a dataGridView created on it where the information / data from the excel sheets will display in a table.

This part I have done and working 100%. I am able to manually change/add text in the fields on the new dataGrids / tables. I want to be able to click a button, and update the changed cells in that original excel file. (I do not want to create an entirely new excel sheet because I will then lose the other 5 sheets that I need to keep). Another forum pointed me here to EPPLUS. Can someone explain to me or show me how to do this? Thanks.