首页 > 编程 > C# > 正文

C# WinForm创建Excel文件的实例

2020-01-24 00:49:22
字体:
来源:转载
供稿:网友

实例如下:

private bool creatExcel(string xlsfile)    {      try      {        object missing = System.Reflection.Missing.Value;        Excel.ApplicationClass myExcel = new Excel.ApplicationClass();        Excel._Workbook xBk;        //工作薄         Excel._Worksheet xSt;   //工作Sheet          xBk = myExcel.Workbooks.Add(true);        for (int i = 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();        return true;      }      catch (Exception ex)      {        MessageBox.Show("Excel创建失败!原因:" + ex.Message);        return false;      }    }

以上这篇C# WinForm创建Excel文件的实例就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持武林网。

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表