OWC Excel Components
-
Hi, I am trying to use the OWC to edit the cells in an existing excel file. I have done it with Interop.Excel, but that takes up too much memory which is why I am going towards the OWC. My problem is that I cannot seem to figure out how to even open the Excel File for editing. Here is my code of a sample project I am trying to do just to get started:
private void EditSpreadSheet() { spread = new OWC.SpreadsheetClass(); spread.ActiveSheet.ConnectionString = "PR.xls"; spread.Cells[2,"2"] = "Hi"; }Sincerely, The Major Rager -
Hi, I am trying to use the OWC to edit the cells in an existing excel file. I have done it with Interop.Excel, but that takes up too much memory which is why I am going towards the OWC. My problem is that I cannot seem to figure out how to even open the Excel File for editing. Here is my code of a sample project I am trying to do just to get started:
private void EditSpreadSheet() { spread = new OWC.SpreadsheetClass(); spread.ActiveSheet.ConnectionString = "PR.xls"; spread.Cells[2,"2"] = "Hi"; }Sincerely, The Major RagerTheMajorRager wrote:
spread.ActiveSheet.ConnectionString = "PR.xls";
You might want to supply the fully qualified path to this file.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
TheMajorRager wrote:
spread.ActiveSheet.ConnectionString = "PR.xls";
You might want to supply the fully qualified path to this file.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007Hi Dave, Here is the new code I came up with however, this creates a NEW file instead of just changing the cells. Do you know how to make it so that it edits a file instead of creating a new one? 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 -- modified at 17:33 Wednesday 27th June, 2007 -
Hi Dave, Here is the new code I came up with however, this creates a NEW file instead of just changing the cells. Do you know how to make it so that it edits a file instead of creating a new one? 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 -- modified at 17:33 Wednesday 27th June, 2007TheMajorRager wrote:
Server.MapPath(".") + "\\"
Seperate this line out so you can see the exact path it comes up with. Somehow, I don't think it's valid. Either that, or the ASPNET process doesn't have Write permissions to the path it's showing.
string filepath = Path.Combine(Server.MapPath("."), @"PR.xls");
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007