Does anyone know how to specify which sheet you're going to be modifying in an exel worksheet? For example, if I have an Excel file that has 5 sheets, and I want to modify (4,7) on sheet 3, how would I do that? Here's what I have so far:
Excel.Application excelApp = new Excel.Application(); string myPath = "C:\\Users\\ctote.REG\\Documents\\My Dropbox\\test.xlsx"; excelApp.Workbooks.Open(myPath); excelApp.Cells[3,3] = "TESTING INFO FROM MY AWESOME APP LOL"; excelApp.Visible = true;
This works, but it modifies sheet1 only.