Opening Excel 2003 file by c#

hesham_51's Avatar, Join Date: Nov 2008
Light Poster
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))


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");

0
neo_vi's Avatar, Join Date: Feb 2008
Invasive contributor
is there any use in opening an EXCEL file in c#. if s wats it!
0
hesham_51's Avatar, Join Date: Nov 2008
Light Poster
I need to make a form that can store the specific data to specific cells ,thats it
0
hesham_51's Avatar, Join Date: Nov 2008
Light Poster
Hi
Any Help ?
0
neo_vi's Avatar, Join Date: Feb 2008
Invasive contributor
pls see the following links
http://support.microsoft.com/kb/306572/
http://blog.brezovsky.net/en-text-38.html
0
hesham_51's Avatar, Join Date: Nov 2008
Light Poster
Thanks alot all Mr. Neo_vi

I got it
0
JosipK's Avatar, Join Date: Dec 2009
Newbie Member
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");
0
ice123456's Avatar, Join Date: Dec 2010
Newbie Member
Hi,

Spire.XLS for .NET also can easily help you deal with this kind of stuff. have a try