输出指定格式的文件（支持格式：HTML，CSV，TEXT，E

最新推荐文章于 2022-06-21 17:15:29 发布

张家可

最新推荐文章于 2022-06-21 17:15:29 发布

阅读量1.3k

点赞数

分类专栏： C#操作Excel

本文链接：https://blog.csdn.net/llxlett/article/details/8512934

版权

C#操作Excel 专栏收录该内容

40 篇文章 0 订阅

订阅专栏

/// <summary>
  /// 输出Excel文件并退出
  /// </summary>
  public void OutputExcelFile()
  {
   if(this.outputFile == null)
    throw new Exception("没有指定输出文件路径！");

   try
   {
    workBook.SaveAs(outputFile,missing,missing,missing,missing,missing,Excel.XlSaveAsAccessMode.xlExclusive,missing,missing,missing,missing);
   }
   catch(Exception e)
   {
    throw e;
   }
   finally
   {
    this.Dispose();
   }
  }

  /// <summary>
  /// 输出指定格式的文件（支持格式：HTML，CSV，TEXT，EXCEL）
  /// </summary>
  /// <param name="format">HTML，CSV，TEXT，EXCEL，XML</param>
  public void OutputFile(string format)
  {
   if(this.outputFile == null)
    throw new Exception("没有指定输出文件路径！");

   try
   {
    switch(format)
    {
     case "HTML":
     {
      workBook.SaveAs(outputFile,Excel.XlFileFormat.xlHtml,missing,missing,missing,missing,Excel.XlSaveAsAccessMode.xlExclusive,missing,missing,missing,missing);
      break;
     }
     case "CSV":
     {
      workBook.SaveAs(outputFile,Excel.XlFileFormat.xlCSV,missing,missing,missing,missing,Excel.XlSaveAsAccessMode.xlExclusive,missing,missing,missing,missing);
      break;
     }
     case "TEXT":
     {
      workBook.SaveAs(outputFile,Excel.XlFileFormat.xlHtml,missing,missing,missing,missing,Excel.XlSaveAsAccessMode.xlExclusive,missing,missing,missing,missing);
      break;
     }
//     case "XML":
//     {
//      workBook.SaveAs(outputFile,Excel.XlFileFormat.xlXMLSpreadsheet, Type.Missing, Type.Missing,
//       Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange,
//       Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
//      break;
//
//     }
     default:
     {
      workBook.SaveAs(outputFile,missing,missing,missing,missing,missing,Excel.XlSaveAsAccessMode.xlExclusive,missing,missing,missing,missing);
      break;
     }
    }
   }
   catch(Exception e)
   {
    throw e;
   }
   finally
   {
    this.Dispose();
   }
  }