Category: .NET

16 Jun 2004 12:14

Joined:	16/06/2004
Level:	Bronze
Points:	6

Points:	2

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

#924

16 Jun 2004 13:36

Joined:	09/06/2004
Level:	Bronze
Points:	38

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(
<Your File Name>, 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

#935

17 Jun 2004 04:50

Joined:	07/06/2004
Level:	Bronze
Points:	22

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

#952

17 Jun 2004 10:28

Joined:	16/06/2004
Level:	Bronze
Points:	6

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

#205071

21 Mar 2008 05:43

Joined:	21/03/2008
Level:	Silver
Points:	80

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.

Read and Write excel file from C#

About dotnetspider.com

Quick Links

General

Services