Hello everyone First ,My name is Hashem I'm a beginner in c#, I'm trying to open Excel file(2003) but I get error at Open Function in the below code : (Old Format Or Invalid Library Of kinds (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)):nonod: Is there anybody can help me? where I use the following code that i have collected. public static Excel.Application ExlApp; public static Excel.Workbook ExlWrkBook; public static Excel.Worksheet ExlWrkSheet; Excel.Application ExcApp = new Excel.Application(); ExcApp.Visible = true; Excel.Workbook excelWorkbook = ExcApp.Workbooks.Open("D:\\Salary Calc.xls", 0, false, 5, "", "", true,Excel.XlPlatform.xlWindows, "\t", true, false, 0, false, true, true); Excel.Sheets ExcSheet = excelWorkbook.Worksheets; string currentSheet = "Sheet1"; Excel.Worksheet excelWorksheet = (Excel.Worksheet)ExcSheet.get_Item(currentSheet); Excel.Range excelCell = (Excel.Range)excelWorksheet.get_Range("A1", "A1");
pls see the following links http://support.microsoft.com/kb/306572/ http://blog.brezovsky.net/en-text-38.html
Hello, you can try using GemBox.Spreadsheet .NET library. It is much more easier to use than Excel Automation. Here is a sample C# code how to export DataSet to Excel: Code: // Create new ExcelFile. var ef = new ExcelFile(); // Imports all the tables from DataSet to new file. foreach (DataTable dataTable in dataSet.Tables) { // Add new worksheet to the file. var ws = ef.Worksheets.Add(dataTable.TableName); // Insert the data from DataTable to the worksheet starting at cell "A1". ws.InsertDataTable(dataTable, "A1", true); } // Save the file to XLS format. ef.SaveXls("DataSet.xls");