private void button9_Click(object sender, EventArgs e)

        {

            var folder =new FolderBrowserDialog();

            if (folder.ShowDialog() == DialogResult.OK)

            {

                GetAllDirList(folder.SelectedPath);

                var SixCount = ;

                var SevenCount = ;

                var sixsb = new StringBuilder();

                var sevensb = new StringBuilder();

                for (var i = ; i < fl.Count; i++)

                {

                    var six = false;

                    var seven = false;

                    var fi = (FileInfo)fl[i];

                    var dataTable = ReadExcel(fi.FullName);

                    for (var k = ; k < dataTable.Rows.Count; k++)

                    {

                        if (dataTable.Columns.Count == )

                        {

                            var a0 = dataTable.Rows[k][].ToString();

                            var a1 = dataTable.Rows[k][].ToString();

                            var a2 = dataTable.Rows[k][].ToString();

                            var a3 = dataTable.Rows[k][].ToString();

                            var a4 = dataTable.Rows[k][].ToString();

                            var a5 = dataTable.Rows[k][].ToString();

                            if ((a0 == "") || (a1 == "") || (a2 == "") || (a3 == "") || (a4 == "") || (a5 == ""))

                            {

                                continue;

                            }

                            six = true;

                            sixsb.Append(dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName);

                            sixsb.Append("\r\n");

                            sixsb.Append(a0 + "  " + a1 + "  " + a2 + "  " + a3 + "  " + a4 + "  " + a5);

                            sixsb.Append("\r\n");

                        }

                        if (dataTable.Columns.Count == )

                        {

                            var a0 = dataTable.Rows[k][].ToString();

                            var a1 = dataTable.Rows[k][].ToString();

                            var a2 = dataTable.Rows[k][].ToString();

                            var a3 = dataTable.Rows[k][].ToString();

                            var a4 = dataTable.Rows[k][].ToString();

                            var a5 = dataTable.Rows[k][].ToString();

                            var a6 = dataTable.Rows[k][].ToString();

                            if ((a0 == "") || (a1 == "") || (a2 == "") || (a3 == "") || (a4 == "") || (a5 == "") || (a6 == ""))

                            {

                                continue;

                            }

                            seven = true;

                            sevensb.Append(dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].ColumnName + "  " + dataTable.Columns[].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("========以下为六个字段的信息======================================");

                    Program.MyFrm.SetTextMessage(sixsb.ToString());

                    Program.MyFrm.SetTextMessage("========以下为七个字段的信息======================================");

                    Program.MyFrm.SetTextMessage(sevensb.ToString());

                }

            }

        }

        private static DataTable ReadExcel(string strFileName)

        {

            var book = new Workbook(strFileName);

            var sheet = book.Worksheets[];

            var cells = sheet.Cells;

            return cells.ExportDataTableAsString(, , cells.MaxDataRow + , cells.MaxDataColumn + , true);

        }

        private static ArrayList fl = new ArrayList();

        //我把ArrayList当成动态数组用，非常好用

        private static void GetAllDirList(string strBaseDir)

        {

            fl.Clear();

            var di = new DirectoryInfo(strBaseDir);

            var diA = di.GetDirectories();

            var fiA = di.GetFiles();//获得了所有起始目录下的文件

            for (var i = ; i < fiA.Length; i++)

            {

                fl.Add(fiA[i]);

            }

            for (var i = ; i < diA.Length; i++)

            {

                GetAllDirList(diA[i].FullName);

            }

        }