C创建Ecel表分析和总结.docx

privatevoidbutton1_Click(objectsender,EventArgse)

{

CreateEx(标题,工作页面);

}

///summary

///创建excel表格

////summary

///paramname=title标题/param

///paramname=fileName文件名/param

///paramname=sheetNamessheet名/paramprivatevoidCreateEx(stringtitle,stringsheetNames)

{

label1.Text=;

///summary

///打开保存窗口自由选取路径

////summary

///paramname=fileName文件名/param

///paramname=DefaultExt默认文件格式/param

///paramname=Filter显示格式/paramstringfileName=saveFileDialog1.FileName;

stringFileName;

saveFileDialog1.FileName=报表;saveFileDialog1.DefaultExt=.xlsx;

saveFileDialog1.Filter=excel文件(*.xlsx)|*.xlsx|所有文件(*.*)|*.*;if(this.saveFileDialog1.ShowDialog(this)==DialogResult.OK)

{

fileName=saveFileDialog1.FileName;FileName=fileName;

}

stringFilePath=saveFileDialog1.FileName;

//stringfileName=报表;//报表名称

//stringFilePath=@E:\报表;//生成文件在E盘目录下if(File.Exists(FilePath))

{

File.Delete(FilePath);

}

if(fileName==)

{

return;

}

if(sheetNames!=nullsheetNames!=)

{

Excel.Applicationm_Excel=newExcel.Application();

m_Excel.SheetsInNewWorkbook=1;

Excel._Workbookm_Book=(Excel._Workbook)(m_Excel.Workbooks.Add(Missing.Value));//添加新工作簿

Excel._Worksheetm_Sheet= (Excel._Worksheet)(m_Excel.Worksheets.Add(Missing.Value));//添加新工作表

m_Sheet.Name=销售部;

//创建[A/W]表格查询stringsql1=select*from[A/W];

DataSetds=DBHelperSQL.GetDataSet(sql1);introwCount1=ds.Tables[0].Rows.Count;//=5

intcolumnCount1=ds.Tables[0].Columns.Count;//=5DataToSheet(title,ds,m_Sheet,m_Book,2);//创建A/W表格

m_Book.SaveAs(FilePath, Missing.Value, Missing.Value, Missing.Value,Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value,Missing.Value,Missing.Value,Missing.Value);

//保存文件m_Book.Close(false,Missing.Value,Missing.Value);

//关闭工作簿

Missing.Value,Missing.Value,

m_Excel.Quit();

放资源放资源

m_Book=null;m_Sheet=null;m_Excel=null;GC.Collect();

}

//退出进程System.Runtime.InteropServices.Marshal.ReleaseComObject(m_Book);// 释

System.Runtime.InteropServices.Mars