read from exel file c#

[emilio]

hello
is there a way i can read from a table in microsoft exel file into an array or matrix in c# ?

[ddanbe]

This might help, although I would not suggest it to the faint of heart...
http://www.arstdesign.com/articles/office2007bin.html

[dickersonka]

you can use office pia's, then you have an object model to work off of

http://stackoverflow.com/questions/261374/efficient-method-to-enumerate-cells-in-an-excel-workbook-using-c

here's the pia's
http://www.microsoft.com/downloads/details.aspx?FamilyId=3C9A983A-AC14-4125-8BA0-D36D67E0F4AD&displaylang=en

[emilio]

i tried to use this code and on line 15 i get null pointer error.
i dont know the reason.
the workBookToOpen string i wrote is in my projects directory

private void Form1_Load(object sender, EventArgs e)
        {
            OpenWorkBook("Data.xls");
        }

        public static void OpenExcelApplication()
        {
            ExlApp = new ExcelXptlb.Application();
        }

        public static void OpenWorkBook(string WorkBookToOpen)
        {
            if (WorkBookToOpen != null)
            {
                ExlWrkBook = ExlApp.Workbooks.Open(WorkBookToOpen.ToString()
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                    , Opt
                                                 );
            }

        }

[dickersonka]

for one, you don't need to call WorkBookToOpen.ToString(), it already is a string

is workbooktoopen a valid path? and are you calling open first?

[emilio]

i deleted the ToString
the excel file is in my projects folder
i tried it like this too OpenWorkBook("..\\..\\Data.xls");

it gives the same null pointer error

[dickersonka]

just to make sure, you have used the full path
C:\folder\Data.xls?

what version of excel?

[emilio]

i tried like this OpenWorkBook("C:\\Data.xls");
it's excel from office 2003

[emilio]

i checked again and as you said i forgot to open excel applicaton.
i tried it with ("c:\\data.xls") and it worked.
thanks for the help