default.aspx.cs

把datagrid,datagridview,gdridview,datatable里的数据导出excel

                    rd3.Read();


                    string s = rd3["jh_jx_date"].ToString();
                    SqlDataReader rd21 = boperate.getread("select *from jx_plan_detail where jh_jx_date='" + s + "'" + "and jh_page='" + this.TextBox1.Text.Trim() + "'");

                    int j = 4;
                    while (rd21.Read())
                    {
                        mySheet.Cells[++j, i - 2] = rd21["jx_eighttime"].ToString();

                    }
                }
                String str4 = "select *from  jx_plan_detail where jh_page='" + this.TextBox1.Text.Trim() + "'" + " order by jh_jx_date";
                SqlDataReader rd4 = boperate.getread(str4);
                for (int i = 6; i < 26; i++)
                {
                    mySheet.Cells[4, i] = "4点";
                    i = i + 2;
                    rd4.Read();

                    string s = rd4["jh_jx_date"].ToString();
                    SqlDataReader rd21 = boperate.getread("select *from jx_plan_detail where jh_jx_date='" + s + "'" + "and jh_page='" + this.TextBox1.Text.Trim() + "'");

                    int j = 4;
                    while (rd21.Read())
                    {
                        mySheet.Cells[++j, i - 2] = rd21["jx_fourtime"].ToString();

                    }
                }


                string s3 = "A" + "A" + "3";
                string s4 = "A" + "A" + "2";
                mySheet.get_Range("Y3", s3).Merge(oo);
                //mySheet.get_Range("Y3", s3).Value2 = s++;
                mySheet.get_Range("D2", s4).Merge(oo);
                mySheet.get_Range("D2", s4).Value2 = "施工进度";
                mySheet.get_Range("Y4", "Y4").Value2 = "0点";
                mySheet.get_Range("Z4", "Z4").Value2 = "8点";
                mySheet.get_Range("AA4", "AA4").Value2 = "4点";
                s3 = "A" + (char)(a1 + 1) + "2";
                s4 = "A" + (char)(a1 + 1) + "4";
                mySheet.get_Range(s3, s4).Merge(oo);
                mySheet.get_Range(s3, s4).Value2 = "施工单位";
                s3 = "A" + (char)(a1 + 2) + "2";
                s4 = "A" + (char)(a1 + 2) + "4";
                mySheet.get_Range(s3, s4).Merge(oo);
                mySheet.get_Range(s3, s4).Value2 = "施工负责人";
                s3 = "A" + (char)(a1 + 3) + "2";
                s4 = "A" + (char)(a1 + 3) + "4";
                mySheet.get_Range(s3, s4).Merge(oo);
                mySheet.get_Range(s3, s4).Value2 = "参加人数";
                s3 = "A" + (char)(a1 + 4) + "2";
                s4 = "A" + (char)(a1 + 4) + "4";
                mySheet.get_Range(s3, s4).Merge(oo);
                mySheet.get_Range(s3, s4).Value2 = "备注";
            }

            if (r > 8 && r < 16)
            {
                for (int n = 1; n < 8; n++)
                {

                    String s1;
                    String s2;
                    s1 = (char)(a + 2) + "3";
                    s2 = a + "3";
                    mySheet.get_Range(s2, s1).Merge(oo);//合并单元格 
                    if (rd.Read())
                    {
                        string s = rd["jh_jx_date"].ToString().Substring(0, 10);//写入对应单元格日期
                        mySheet.get_Range(s2, s1).Value2 = s;
                    }
                    a = (char)(a + 3);
                }

                String str2 = "select *from  jx_plan_detail where jh_page='" + this.TextBox1.Text.Trim() + "'" + " order by jh_jx_date";
                SqlDataReader rd2 = boperate.getread(str2);
                for (int i = 4; i < 24; i++)
                //region 写单元格
                {
                    mySheet.Cells[4, i] = "0点";
                    i = i + 2;
                    rd2.Read();

                    string s = rd2["jh_jx_date"].ToString();
                    SqlDataReader rd21 = boperate.getread("select *from jx_plan_detail where jh_jx_date='" + s + "'" + "and jh_page='" + this.TextBox1.Text.Trim() + "'");

                    int j = 4;
                    while (rd21.Read())
                    {
                        mySheet.Cells[++j, i - 2] = rd21["jx_zerotime"].ToString();

                    }
                }
                String str3 = "select *from  jx_plan_detail where jh_page='" + this.TextBox1.Text.Trim() + "'" + " order by jh_jx_date";
                SqlDataReader rd3 = boperate.getread(str3);
          
                for (int i = 5; i < 25; i++)
                {
                    mySheet.Cells[4, i] = "8点";
                    i = i + 2;
                    rd3.Read();


                    string s = rd3["jh_jx_date"].ToString();
                    SqlDataReader rd21 = boperate.getread("select *from jx_plan_detail where jh_jx_date='" + s + "'" + "and jh_page='" + this.TextBox1.Text.Trim() + "'");

                    int j = 4;
                    while (rd21.Read())
                    {
                        mySheet.Cells[++j, i - 2] = rd21["jx_eighttime"].ToString();

                    }
                }
                String str4 = "select *from  jx_plan_detail where jh_page='" + this.TextBox1.Text.Trim() + "'" + " order by jh_jx_date";
                SqlDataReader rd4 = boperate.getread(str4);
                for (int i = 6; i < 26; i++)
                {
                    mySheet.Cells[4, i] = "4点";
                    i = i + 2;
                    rd4.Read();

                    string s = rd4["jh_jx_date"].ToString();
                    SqlDataReader rd21 = boperate.getread("select *from jx_plan_detail where jh_jx_date='" + s + "'" + "and jh_page='" + this.TextBox1.Text.Trim() + "'");

                    int j = 4;
                    while (rd21.Read())
                    {
                        mySheet.Cells[++j, i - 2] = rd21["jx_fourtime"].ToString();

                    }
                }
                string s3;
                s3 = "A" + "A" + "3";
                mySheet.get_Range("Y3", s3).Merge(oo);
                //mySheet.get_Range("Y3", s3).Value2 = s++;
                mySheet.get_Range("Y4", "Y4").Value2 = "0点";
                mySheet.get_Range("Z4", "Z4").Value2 = "8点";
                mySheet.get_Range("AA4", "AA4").Value2 = "4点";

                for (int n = 9; n <= r; n++)
                {
                    string s1;
                    string s2;
                    s1 = "A" + (char)(b1 + 2) + "3";
                    s2 = "A" + b1 + "3";
                    mySheet.get_Range(s2, s1).Merge(oo);
                    //mySheet.get_Range(s2, s1).Value2 = s++;
                    b1 = (char)(b1 + 3);
                }
                int w = 3 * r + 4;
                for (int i = 4; i < w; i++)
                //region 写单元格
                {
                    mySheet.Cells[4, i] = "0点";
                    i = i + 2;
                }
                for (int i = 5; i < w; i++)
                {
                    mySheet.Cells[4, i] = "8点";
                    i = i + 2;
                }
                for (int i = 6; i < w; i++)
                {
                    mySheet.Cells[4, i] = "4点";
                    i = i + 2;
                }
                string b2 = "A" + (char)(b1 - 1) + "2";
                mySheet.get_Range("D2", b2).Merge(oo);
                mySheet.get_Range("D2", b2).Value2 = "施工进度";

                b2 = "A" + (char)b1 + "2";
                string b3 = "A" + (char)b1 + "4";
                mySheet.get_Range(b2, b3).Merge(oo);
                mySheet.get_Range(b2, b3).Value2 = "施工单位";

                b2 = "A" + (char)(b1 + 1) + "2";
                b3 = "A" + (char)(b1 + 1) + "4";
                mySheet.get_Range(b2, b3).Merge(oo);
                mySheet.get_Range(b2, b3).Value2 = "施工负责人";

                b2 = "A" + (char)(b1 + 2) + "2";
                b3 = "A" + (char)(b1 + 2) + "4";
                mySheet.get_Range(b2, b3).Merge(oo);
                mySheet.get_Range(b2, b3).Value2 = "参加人数";

                b2 = "A" + (char)(b1 + 3) + "2";
                b3 = "A" + (char)(b1 + 3) + "4";
                mySheet.get_Range(b2, b3).Merge(oo);
                mySheet.get_Range(b2, b3).Value2 = "备注";

                b2 = "A" + (char)(b1 + 3) + "1";
                mySheet.get_Range("A1", b2).Merge(oo);
                mySheet.get_Range("A1", b2).Value2 = "机电检修计划";
            }
              
            myBook.Save();
            //myBook.Close(true, strFilename, true);
            myApp.Save(strFilename);
            Response.Write("写入文件成功");
        }
        catch
        {
            Response.Write("写入文件失败");
        }
        finally
        {
            myApp.Quit();
            myApp = null;
        }
           

           

        }
    }