Форум программистов [Powered by Invision Power Board]

Код


            excelapp = new Excel.Application();
            excelapp.Visible = false;

            excelappworkbooks = excelapp.Workbooks;
            //Открываем книгу и получаем на нее ссылку
            excelappworkbook = excelapp.Workbooks.Open(@"E:\Fam1.xls", Type.Missing, 1, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

            excelsheets = excelappworkbook.Worksheets;
            //Получаем ссылку на лист 1
            excelworksheet = (Excel.Worksheet)excelsheets.get_Item(1);
            //Выделение группы ячеек
            //Десять строк с 1 по 10ю
            excelcells = (Excel.Range)excelworksheet.Rows["1:3", Type.Missing];
  
               string sStr;
                int i;

                for(i=1;i<4;i++) {
                sStr = Convert.ToString(excelcells.get_Item(i,1));
                MessageBox.Show(sStr);
                }

Код


sStr = Convert.ToString(excelcells.get_Item(i,1));

на

sStr = ((Object[,])excelcells.Cells.Value2)[i,1].ToString()

Код



//------------------------------------------------------------------
using Excel = Microsoft.Office.Interop.Excel;
//------------------------------------------------------------------

//------------------------------------------------------------------
        private Excel.Application excelapp;
        private Excel.Window excelWindow;

        private Excel.Workbooks excelappworkbooks;
        private Excel.Workbook excelappworkbook;

        private Excel.Sheets excelsheets;
        private Excel.Worksheet excelworksheet;

        private Excel.Range excelcells;
//------------------------------------------------------------------


                                excelapp = new Excel.Application();
                                excelapp.Visible = false;

                                excelappworkbooks = excelapp.Workbooks;

                                //Открываем книгу и получаем на нее ссылку
                                excelappworkbook = excelapp.Workbooks.Open(PathToFile, Type.Missing, 1, Type.Missing, Type.Missing, Type.Missing,
                                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

                                excelsheets = excelappworkbook.Worksheets;
                                //Получаем ссылку на лист 1
                                excelworksheet = (Excel.Worksheet)excelsheets.get_Item(1);

                                // Считывание в переменные значений из Excel:

                                excelcells = excelworksheet.get_Range("A1", Type.Missing);
                                MessageBox.Show(Convert.ToString(excelcells.Value2));