OWC Excel Problem
-
I am trying to use the OWC11 to edit an Excel template. the code below creates a NEW file instead of just changing the cells. Does anyone know how to make it so that it edits a cell in a file instead of creating a new file? Also, how much memory does OWC11 use on the server? private void EditSpreadSheet() { spread = new OWC.SpreadsheetClass(); spread.ActiveSheet.Cells[1,1] = "HELLO"; spread.get_Range("A2:A2",Type.Missing); spread.Export(Server.MapPath(".") + "\\" + "PR.xls",OWC.SheetExportActionEnum.ssExportActionNone, OWC.SheetExportFormat.ssExportHTML); } Sincerely, The Major Rager
-
I am trying to use the OWC11 to edit an Excel template. the code below creates a NEW file instead of just changing the cells. Does anyone know how to make it so that it edits a cell in a file instead of creating a new file? Also, how much memory does OWC11 use on the server? private void EditSpreadSheet() { spread = new OWC.SpreadsheetClass(); spread.ActiveSheet.Cells[1,1] = "HELLO"; spread.get_Range("A2:A2",Type.Missing); spread.Export(Server.MapPath(".") + "\\" + "PR.xls",OWC.SheetExportActionEnum.ssExportActionNone, OWC.SheetExportFormat.ssExportHTML); } Sincerely, The Major Rager
Don't start another thread for the same topic. Keep it in your original thread so there's the opportunity for multiple people to collaborate on an answer.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007