C# WinForm创建Excel文件的实例

实例如下：

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文件的实例就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持。