【www.bbyears.com--WinForm】
实例如下:
代码如下
privateboolcreatExcel(stringxlsfile)
{
try
{
objectmissing = System.Reflection.Missing.Value;
Excel.ApplicationClass myExcel =newExcel.ApplicationClass();
Excel._Workbook xBk; //工作薄
Excel._Worksheet xSt; //工作Sheet
xBk = myExcel.Workbooks.Add(true);
for(inti = 0; i < 1; i++)
{
xSt = (Excel._Worksheet)xBk.ActiveSheet;
xSt.Name ="Sheet"+ i;
myExcel.Sheets.Add(missing, missing, 1, Excel.XlSheetType.xlWorksheet);
}
//myExcel.Visible = true;
if(xlsfile.ToLower().EndsWith(".xlsx"))
{
xBk.SaveAs(xlsfile, 56, missing,
missing, missing, missing, Excel.XlSaveAsAccessMode.xlShared,
missing, missing, missing, missing, missing);
}
else
{
xBk.SaveAs(xlsfile, missing, missing,
missing, missing, missing, Excel.XlSaveAsAccessMode.xlShared,
missing, missing, missing, missing, missing);
}
myExcel.Quit();
returntrue;
}
catch(Exception ex)
{
MessageBox.Show("Excel创建失败!原因:"+ ex.Message);
returnfalse;
}
}