Reading Excel Data with VB.NET 2005
-
Hello Folks, I would like to open an excel and app with visual studio 2005 without using COM. It seems like I should be able do this with the Microsoft.Office.Tools.Excel. It seems like I should be able to open an excel application like I could with Microsoft Excel 11.0 Object Library. I don't want to use the Microsot Excel Oject Libaray because when I try to use it with Microsoft.Office.Tools classes I get a lot if InvalidCastExceptions like when I try to set a Microsoft.Office.Tools.Excel.Workbook = to an Excel.Workbook. Is there a Microsoft.Office.Tools.Excel.Workbook method equivalent to Excel.Worbooks.open("c:/myxl.xls")? It seems strange that we have save and save as in Microsoft.office.Tools.excel.workbook but no open. Also, I cannot seem to add a reference to microsoft.interop.office how can I add a refrence to this if I need to. Please help. This is driving me nuts.