January 4th, 2012, 06:14 AM
Read values from a excel cell with addin formula using Excel automation
we are trying to retrieve a calculated value from a cell which has add-In (VBA) formulas in it. The sample add-in "myUtilityl.xla" is working properly in excel. It retrieves value for the addin function =ISOWEEKNUM(F9). But we are unable to retrieve the value in our application using C# & Microsoft Object Library. The add-In "myUtilityl.xla" is attached to Excel. Environment is VS2010
I am providing the sample code here.
string path = @"C:\Test.xls";
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
theWorkbook = app.Workbooks.Open(path);
Sheets theSheets = (Sheets)theWorkbook.Worksheets;
theWorksheet = (Worksheet)theWorkbook.Worksheets.get_Item("Sheet1");
readRange = theWorksheet.get_Range("B1");
I am new to Microsoft Object library. Any help or clue will be very helpful.
January 5th, 2012, 12:39 PM
Re: Read values from a excel cell with addin formula using Excel automation
You're trying to convert a range to a double.
readRange = theWorksheet.get_Range("C1", "C1");
readValue = Convert.ToDouble(readRange.Value2);
Tags for this Thread
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!