//建立Excel对象
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
excel.Visible = isShowExcle;
Microsoft.Office.Interop.Excel.Range range;
//生成字段名称
for (int c = 0; c < columnNumber; c++)
{
if (c != 11 && c != 12)
{
colIndex++;
excel.Cells[1, colIndex] = gvData.Columns[c].HeaderText;
}
}
object[,] objData = new object[rowNumber, 13];
for (int r = 0; r < rowNumber; r++)
{
//for (int c = 0; c < columnNumber; c++)
//{
objData[r, 0] = (gvData.Rows[r].FindControl("Label_xh") as Label).Text;
objData[r, 1] = (gvData.Rows[r].FindControl("Label1") as Label).Text;
objData[r, 2] = (gvData.Rows[r].FindControl("Label2") as Label).Text;
objData[r, 3] = (gvData.Rows[r].FindControl("Label3") as Label).Text;
objData[r, 4] = (gvData.Rows[r].FindControl("Label4") as Label).Text;
objData[r, 5] = (gvData.Rows[r].FindControl("Label5") as Label).Text;
objData[r, 6] = (gvData.Rows[r].FindControl("Label6") as Label).Text;
objData[r, 7] = (gvData.Rows[r].FindControl("Label7") as Label).Text;
objData[r, 8] = (gvData.Rows[r].FindControl("Label8") as Label).Text;
objData[r, 9] = gvData.Rows[r].Cells[9].Text;
objData[r, 10] = (gvData.Rows[r].FindControl("Label9") as Label).Text;
objData[r, 11] = "";
objData[r, 12] = "";
//}
}
// 写入Excel
range = worksheet.get_Range(excel.Cells[2, 1], excel.Cells[rowNumber + 1, 13]);
//range.NumberFormat = "@";//设置单元格为文本格式
range.Value2 = objData;
return true;
