DaniWeb Home > Forums > Software Development > C#

RSS

opening Excel 2003 file by c#

Please support our C# advertiser: DiscountASP.NET – 3 Months Free on C# Web Hosting

•

Posts: 2

Reputation: hesham_51 is an unknown quantity at this point

Solved Threads: 0

hesham_51

Offline

Newbie Poster

opening Excel 2003 file by c#

Jan 3rd, 2009

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 from many reference.
The replies are valuable.

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

•

Posts: 1,867

Reputation: Ramy Mahrous has a spectacular aura about

Solved Threads: 214

Ramy Mahrous Ramy Mahrous is offline

Offline

Posting Virtuoso

Re: opening Excel 2003 file by c#

Jan 3rd, 2009

What's your Office SDK version?

BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous

•

Posts: 1,734

Reputation: LizR has a spectacular aura about

Solved Threads: 184

LizR

Offline

Posting Virtuoso

Re: opening Excel 2003 file by c#

Jan 3rd, 2009

And, more to the point, which version of excel did you add as a reference?

Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.

•

Posts: 2

Reputation: hesham_51 is an unknown quantity at this point

Solved Threads: 0

hesham_51

Offline

Newbie Poster

Re: opening Excel 2003 file by c#

Jan 5th, 2009

Hi
I'm using

Microsoft.Office.Interop

•

Posts: 3

Reputation: pferian is an unknown quantity at this point

Solved Threads: 0

pferian

Offline

Newbie Poster

Re: opening Excel 2003 file by c#

May 20th, 2009

Hy,
I did something like what you want in VC++ .NET Framework language. Just use the same classes in C# and it should work (there are some peaces of code that are usefull in my application but do no refer to Excell handling - just not care of). Please note that you have to install Excel 2003 and Windows XP or higher in the system where the application runs.

private: System::Void button7_Click(System::Object^ sender, System::EventArgs^ e)
{
String^ XlsFile = String::Format("Z:\\Documenti\\Lavoro\\Fatture\\2009\\Fattura_02_AEM_marzo_09.xls");
String^ XlsSheet = String::Format("Milano, {0}/{1}/{2}",
dateTimePicker1->Value.Day.ToString(),
dateTimePicker1->Value.Month.ToString(),
dateTimePicker1->Value.Year.ToString());

Excel::Application^ oXLApp;
Excel::Workbook^ oXLWBook;
//Excel::Sheets^ oXLSheet;
//Excel::Worksheet^ oXLWSheet;

Excel::Range^ rng;

//starts Excel application
oXLApp = (gcnew Excel::Application());
oXLApp->Visible = true;
//opens the workbook of the file "XlsFile"
oXLWBook = oXLApp->Workbooks->Open(XlsFile, 0, false, 5, "", "",
true,Excel::XlPlatform::xlWindows, "\t", true, false, 0, false, true, true);
//updates the range of sheet1, cell D4
rng = oXLApp->Range::get("D4","D4");
rng->Value2 = XlsSheet;

}

•

Posts: 1,111

Reputation: adatapost is a jewel in the rough

Solved Threads: 177

adatapost

Offline

Veteran Poster

Re: opening Excel 2003 file by c#

May 20th, 2009

Hi!
Hope this code will resolve your problem.

Help with Code Tags

(Toggle Plain Text)

using System.Collections;
using Microsoft.Office.Interop.Excel;
using System;
using System.Reflection;
class Sample
{
    static void Main()
    {
        string file = @"c:\csnet\jap\ex1\sample1.xls";
        Microsoft.Office.Interop.Excel.ApplicationClass ap = new ApplicationClass();
        Missing m=Missing.Value;
       Workbook wb=ap.Workbooks.Open(file, m, m, m, m, m, m, m, m, m, m, m, m, m, m);
       Worksheet sh =(Worksheet) wb.Sheets[1];
       for (int i = 1; i < 10; i++)
       {

          string[] p = new string[10];
           for (int j = 1; j <= 10; j++)
           {
               Range r = (Range)sh.Cells[i, j];
               p[j - 1] = r.Value2;
           }
           
       }
        ap.Quit();
       
    }
}

Last edited by adatapost : May 20th, 2009 at 9:32 am.

adatapost
------------

•

Posts: 13

Reputation: Poojasrivastava is an unknown quantity at this point

Solved Threads: 0

Poojasrivastava Poojasrivastava is offline

Offline

Newbie Poster

Re: opening Excel 2003 file by c#

May 21st, 2009

i did the same thing using javascript..may be that helps you..
here is the javascript code:

Help with Code Tags

(Toggle Plain Text)

<html>

<head>

<title></title>

</head>

<body>
<script type="text/javascript">
function read()
{

var myApp = new ActiveXObject("Excel.Application");
if (myApp != null)
{
myApp.visible = true;
myApp.workbooks.open("C:\\Book2.xls");
}
}

</script>
<button onclick="read();">READ</button>
</body>

</html>

•

Posts: 1,111

Reputation: adatapost is a jewel in the rough

Solved Threads: 177

adatapost

Offline

Veteran Poster

Re: opening Excel 2003 file by c#

May 21st, 2009

•

Originally Posted by Poojasrivastava

i did the same thing using javascript..may be that helps you..
here is the javascript code:
Help with Code Tags

(Toggle Plain Text)
<html>

<head>

<title></title>

</head>

<body>
<script type="text/javascript">
function read()
{

var myApp = new ActiveXObject("Excel.Application");
if (myApp != null)
{
myApp.visible = true;
myApp.workbooks.open("C:\\Book2.xls");
}
}

</script>
<button onclick="read();">READ</button>
</body>

</html>
<html> <head> <title></title> </head> <body> <script type="text/javascript"> function read() { var myApp = new ActiveXObject("Excel.Application"); if (myApp != null) { myApp.visible = true; myApp.workbooks.open("C:\\Book2.xls"); } } </script> <button onclick="read();">READ</button> </body> </html>