导出数据表(Excel)

首先要添加一个引用:using system.Excel(似乎是这个)    

         Excel.Application excel = new Excel.Application();
             excel.Application.Workbooks.Add(true);
           
          excel.Visible = true;
         
         for (int i = 0; i < this.dataGridView1.ColumnCount; i++)

            {
              
           excel.Cells[1, i + 1] = this.dataGridView1.Columns[i].HeaderText;
                 }

            for (int i = 0; i < this.dataGridView1.RowCount - 1; i++)
                        {
 
                for (int j = 0; j < this.dataGridView1.ColumnCount; j++)
                          {
                  
         excel.Cells[i + 2, j + 1] = this.dataGridView1[j, i].Value.ToString();

                   }
 
             }

 

posted @ 2012-01-17 21:53  空明  阅读(146)  评论(0编辑  收藏  举报