Go4Expert

Go4Expert (http://www.go4expert.com/)
-   C# (http://www.go4expert.com/forums/c-sharp/)
-   -   Opening Excel 2003 file by c# (http://www.go4expert.com/forums/excel-2003-file-c-sharp-t15682/)

hesham_51 31Dec2008 01:50

Opening Excel 2003 file by c#
 
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");

:confused:

neo_vi 31Dec2008 17:38

Re: Opening Excel 2003 file by c#
 
is there any use in opening an EXCEL file in c#. if s wats it!

hesham_51 31Dec2008 21:36

Re: Opening Excel 2003 file by c#
 
I need to make a form that can store the specific data to specific cells ,thats it

hesham_51 1Jan2009 19:16

Re: Opening Excel 2003 file by c#
 
Hi
Any Help ?

neo_vi 5Jan2009 21:22

Re: Opening Excel 2003 file by c#
 
pls see the following links
http://support.microsoft.com/kb/306572/
http://blog.brezovsky.net/en-text-38.html

hesham_51 10Jan2009 19:11

Re: Opening Excel 2003 file by c#
 
Thanks alot all Mr. Neo_vi

I got it

JosipK 27Sep2010 15:25

Re: Opening Excel 2003 file by c#
 
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");


ice123456 15Dec2010 12:34

Re: Opening Excel 2003 file by c#
 
Hi,

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


All times are GMT +5.5. The time now is 16:10.