public void ToExcel(DataGridView gv, bool isShow)

        {

            //判断数据源控件 数据行是否为空

            if (gv.RowCount > 1)

            {

                //进行Excel程序的运行

                Excel.Application excel = new Excel.Application();

                // 新建一张excel工作簿

                excel.Application.Workbooks.Add(true);

                // excel程序是否显示

                excel.Visible = isShow;



                //生成excel标题

                for (int i = 0; i < gv.ColumnCount; i++)

                {

                    if (gv.Columns[i].Visible == true && (gv.Columns[i] is DataGridViewTextBoxColumn))

                    {

                        //根据数据源控件的列数，生成相应的excel列数,

                        // excel的列标题与数据源列标题相同

                        //excel的第一行 

                        excel.Cells[1, i + 1] = gv.Columns[i].HeaderText;

                        //设定单元格的宽度

                        excel.Cells.ColumnWidth = 20;

                    }

                }



                //填充数据

                for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)

                {

                    f