Ways to read Excel

Private voidButton9_click (Objectsender, EventArgs e) {            varfolder =NewFolderBrowserDialog (); if(folder. ShowDialog () = =DialogResult.OK) {getalldirlist (folder.                SelectedPath); varSixcount =0; varSevencount =0; varSIXSB =NewStringBuilder (); varSEVENSB =NewStringBuilder ();  for(vari =0; I < fl. Count; i++)                {                    varsix =false; varSeven =false; varfi =(FileInfo) fl[i]; varDataTable =Readexcel (FI.                    FullName);  for(varK =0; K < DataTable.Rows.Count; k++)                    {                        if(DataTable.Columns.Count = =6)                        {                            vara0 = datatable.rows[k][0].                            ToString (); varA1 = datatable.rows[k][1].                            ToString (); varA2 = datatable.rows[k][2].                            ToString (); varA3 = datatable.rows[k][3].                            ToString (); vara4 = datatable.rows[k][4].                            ToString (); varA5 = datatable.rows[k][5].                            ToString (); if(a0 = ="") || (A1 = ="") || (A2 = ="") || (A3 = ="") || (A4 = ="") || (A5 = =""))                            {                                Continue; } Six=true; Sixsb. Append (datatable.columns[0]. ColumnName +"  "+ datatable.columns[1]. ColumnName +"  "+ datatable.columns[2]. ColumnName +"  "+ datatable.columns[3]. ColumnName +"  "+ datatable.columns[4]. ColumnName +"  "+ datatable.columns[5].                            ColumnName); Sixsb. Append ("\ r \ n"); Sixsb. Append (A0+"  "+ A1 +"  "+ A2 +"  "+ A3 +"  "+ A4 +"  "+a5); Sixsb. Append ("\ r \ n"); }                        if(DataTable.Columns.Count = =7)                        {                            vara0 = datatable.rows[k][0].                            ToString (); varA1 = datatable.rows[k][1].                            ToString (); varA2 = datatable.rows[k][2].                            ToString (); varA3 = datatable.rows[k][3].                            ToString (); vara4 = datatable.rows[k][4].                            ToString (); varA5 = datatable.rows[k][5].                            ToString (); varA6 = datatable.rows[k][6].                            ToString (); if(a0 = ="") || (A1 = ="") || (A2 = ="") || (A3 = ="") || (A4 = ="") || (A5 = ="") || (A6 = =""))                            {                                Continue; } Seven=true; Sevensb. Append (datatable.columns[0]. ColumnName +"  "+ datatable.columns[1]. ColumnName +"  "+ datatable.columns[2]. ColumnName +"  "+ datatable.columns[3]. ColumnName +"  "+ datatable.columns[4]. ColumnName +"  "+ datatable.columns[5]. ColumnName +"  "+ datatable.columns[6].                            ColumnName); Sixsb. Append ("\ r \ n"); Sevensb. Append (A0+"  "+ A1 +"  "+ A2 +"  "+ A3 +"  "+ A4 +"  "+ A5 +"  "+a6); Sevensb. Append ("\ r \ n"); }                    }                    if(six) sixcount++; if(Seven) sevencount++; Program.MyFrm.SetTextMessage ("Sixcount:"+sixcount); Program.MyFrm.SetTextMessage ("Sevencount:"+sevencount); Program.MyFrm.SetTextMessage ("======== The following are six fields of information ======================================"); Program.MyFrm.SetTextMessage (SIXSB.                    ToString ()); Program.MyFrm.SetTextMessage ("======== The following are seven fields of information ======================================"); Program.MyFrm.SetTextMessage (SEVENSB.                ToString ()); }            }        }        Private StaticDataTable Readexcel (stringstrFileName) {            varBook =NewWorkbook (strFileName); varSheet = Book. worksheets[0]; varCells =sheet.            Cells; returnCells. Exportdatatableasstring (0,0, cells. Maxdatarow +1, cells. Maxdatacolumn +1,true); }        Private StaticArrayList FL =NewArrayList (); //I use ArrayList as a dynamic array, very useful        Private Static voidGetalldirlist (stringStrbasedir) {fl.            Clear (); varDI =NewDirectoryInfo (Strbasedir); varDiA =di.            GetDirectories (); varFiA = di. GetFiles ();//get all the files from the start directory             for(vari =0; i < fia.length; i++) {fl.            ADD (Fia[i]); }             for(vari =0; i < dia.length; i++) {getalldirlist (Dia[i].            FullName); }        }

Ways to read Excel