C#写excel,为什么小弟我这回弹出两次保存,第2次保存的一个空excel
C#写excel,为什么我这回弹出两次保存,第2次保存的一个空excel
C#写excel,为什么我这回弹出两次保存,第2次保存的一个空excel,帮我看看。
protected void AddExcel(DataSet ds)
{
DataTable dt = ds.Tables[0];
//获取excel的文件名称(Guid是一个全球表示,使excel的文件名不同)
//--- string fileName = Guid.NewGuid() + ".xls";
string fileName = System.DateTime.Now.ToString("yyyymmdd");
//初始化excel对象
Excel.Application excel = new Excel.ApplicationClass();
//Excel.Application excel1 = new Excel.ApplicationClass();
//定义列
int rowIndex = 3;
//定义行
int colIndex = 0;
//开始添加
excel.Application.Workbooks.Add(true);
Excel.Range range = excel.get_Range(excel.Cells[1, 1], excel.Cells[2, 1]);
//Excel.Range range1 = excel.get_Range(excel.Cells[2, 1], excel.Cells[3, 1]);
//myrange.NumberFormatLocal = "asd";
Excel.Workbooks workbooks = excel.Workbooks;
Excel.Workbook workbook = workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];
range.NumberFormatLocal = "@"; //设置单元格格式为文本
Excel.Worksheet workSheet = (Excel.Worksheet)workbook.Worksheets[1];
Excel.Range excelRange = workSheet.get_Range(workSheet.Cells[2, 1], workSheet.Cells[2, 1]);
workSheet.get_Range("A1", "M1").Merge(workSheet.get_Range("A1", "O1").MergeCells);
workSheet.get_Range("B2", "M2").Merge(workSheet.get_Range("B2", "O2").MergeCells);
worksheet.Cells[2, 1] = "2010年第二季度产品质量定期监督检查动态监管档案表"; //Excel单元格赋值
worksheet.Cells[4, 1] = "序号";
worksheet.Cells[4, 2] = "产品分类";
worksheet.Cells[4, 3] = "企业名称";
worksheet.Cells[4, 4] = "详细地址及邮政编码";
worksheet.Cells[4, 5] = "企业负责人及联系电话";
workSheet.Cells[4, 6] = "企业规模许可证书编号";
//向Excel表格中添加数据
foreach (DataRow row in dt.Rows)
{
rowIndex++;
colIndex = 0;
for (colIndex = 0; colIndex < dt.Columns.Count; colIndex++)
{
excel.Cells[rowIndex, colIndex + 1] = row[colIndex].ToString();
}
}
//导出表格后是否打开,(false)为不打开 (true)为打开
excel.Visible = false;
//保存文件(可以自己更改路径)
C#写excel,为什么我这回弹出两次保存,第2次保存的一个空excel,帮我看看。
protected void AddExcel(DataSet ds)
{
DataTable dt = ds.Tables[0];
//获取excel的文件名称(Guid是一个全球表示,使excel的文件名不同)
//--- string fileName = Guid.NewGuid() + ".xls";
string fileName = System.DateTime.Now.ToString("yyyymmdd");
//初始化excel对象
Excel.Application excel = new Excel.ApplicationClass();
//Excel.Application excel1 = new Excel.ApplicationClass();
//定义列
int rowIndex = 3;
//定义行
int colIndex = 0;
//开始添加
excel.Application.Workbooks.Add(true);
Excel.Range range = excel.get_Range(excel.Cells[1, 1], excel.Cells[2, 1]);
//Excel.Range range1 = excel.get_Range(excel.Cells[2, 1], excel.Cells[3, 1]);
//myrange.NumberFormatLocal = "asd";
Excel.Workbooks workbooks = excel.Workbooks;
Excel.Workbook workbook = workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];
range.NumberFormatLocal = "@"; //设置单元格格式为文本
Excel.Worksheet workSheet = (Excel.Worksheet)workbook.Worksheets[1];
Excel.Range excelRange = workSheet.get_Range(workSheet.Cells[2, 1], workSheet.Cells[2, 1]);
workSheet.get_Range("A1", "M1").Merge(workSheet.get_Range("A1", "O1").MergeCells);
workSheet.get_Range("B2", "M2").Merge(workSheet.get_Range("B2", "O2").MergeCells);
worksheet.Cells[2, 1] = "2010年第二季度产品质量定期监督检查动态监管档案表"; //Excel单元格赋值
worksheet.Cells[4, 1] = "序号";
worksheet.Cells[4, 2] = "产品分类";
worksheet.Cells[4, 3] = "企业名称";
worksheet.Cells[4, 4] = "详细地址及邮政编码";
worksheet.Cells[4, 5] = "企业负责人及联系电话";
workSheet.Cells[4, 6] = "企业规模许可证书编号";
//向Excel表格中添加数据
foreach (DataRow row in dt.Rows)
{
rowIndex++;
colIndex = 0;
for (colIndex = 0; colIndex < dt.Columns.Count; colIndex++)
{
excel.Cells[rowIndex, colIndex + 1] = row[colIndex].ToString();
}
}
//导出表格后是否打开,(false)为不打开 (true)为打开
excel.Visible = false;
//保存文件(可以自己更改路径)