Member Avatar for hesham_51

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

  • 6 Contributors
  • 8 Replies
  • 436 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by Poojasrivastava

Recommended Answers

All 8 Replies

Member Avatar for Ramy Mahrous

What's your Office SDK version?

Member Avatar for LizR

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

Member Avatar for hesham_51

Hi
I'm using

Microsoft.Office.Interop

Member Avatar for pferian

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; 

            }
Edited by Nick Evan because: Fixed formatting
Member Avatar for kvprajapati

Hi!
Hope this code will resolve your problem.

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();
       
    }
}
Member Avatar for Poojasrivastava

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

<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>
Member Avatar for kvprajapati

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

<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>

Nice code. You should post this one on Web forum.

Member Avatar for Poojasrivastava

i hope it helped you,if it did then mark it as solved... :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.