You must Sign In to post a response.

Read and Write excel file from C#

The forum thread has not been reviewed by Editors yet. Readers are advised to use their best judgement before accessing this thread.
This thread will be reviewed shortly.
If you think this thread contain inappropriate content, please report to webmaster.
Hi,
Please if somebody can help me,

I am working project in C#, and i am in need to Open an existing xls file, read, write and save the xls file from C# .

so if somebody can help me
Thank u a lot


Comments

Author: Satheesh Karthikeyan16 Jun 2004 Member Level: Bronze   Points : 2

Hi

1. In your project, Add reference to COM object library named under COM tab - Microsoft Excel 9.0 Object Library.

2. After you add reference, (Interop.Excel.dll and Interop.Office.dll) files are copied to your bin directory.

3. Excel.Application ExcelObj = = new Excel.Application();

4. Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open(
, 0, true, 5,
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,
0, true);
(Look in Object Browser for this method parameters)

5. Excel.Sheets sheets = theWorkbook.Worksheets; (To get the worksheets)

6. Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1); (Get the first work sheet)

7. You can read / write the values in worksheet using WorkSheet object created above.

Use Object Browser to view the properties / methods of WorkSheet object.

-SatheeshKarthik

Author: S S17 Jun 2004 Member Level: Bronze   Points : 2

Excel workbook can be opened just like any other OleDB like Access DB
Connection string
urlPath=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties=Excel 8.0;HRD=1;IMEX=1";
All Sql statemnets like select,update,delete etc. function on Excel DB
Select Name from [Sheet1$]
Name is column header
Instead of fieldnames use column names.
Instead of table use Sheet Names



Author: Johnny Yammine17 Jun 2004 Member Level: Bronze   Points : 2

thank u Satheeshkarthik

I was doing the same as u are saying, the problem that i ad is exactly in the fourth step, when i write the following:

Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open(
, 0, true, 5,
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,
0, true);

so i put the name of the file after Open as the first argument, for example the file name is test, i tried ......Open(test,0,true......);
so the compiler gave me an error "the name file does not exist in the class or namespace
i also tried to put test.xls and i tried to put the path before, but always i have an error.

Thank u for your help

Author: Filip21 Mar 2008 Member Level: Silver   Points : 2

There are better ways to Read/Write XLS/CSV/HTML/XLSX files than Excel Automation (http://www.gemboxsoftware.com/GBSpreadsheet.htm). You can use our Free Spreadsheet .NET Component (http://www.gemboxsoftware.com/GBSpreadsheetFree.htm) even in your commercial applications.


Sign In to post your comments