/// <summary> /// 将Excel文件另存为指定格式 /// </summary> /// <param name="format">HTML,CSV,TEXT,EXCEL,XML</param> public void SaveAsFile(SaveAsFileFormat format) { if (this.outputFile == null) { throw new Exception("没有指定输出文件路径!"); } try { switch (format) { case SaveAsFileFormat.HTML: { workBook.SaveAs(outputFile, Excel.XlFileFormat.xlHtml, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing); break; } case SaveAsFileFormat.CSV: { workBook.SaveAs(outputFile, Excel.XlFileFormat.xlCSV, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing); break; } case SaveAsFileFormat.TEXT: { workBook.SaveAs(outputFile, Excel.XlFileFormat.xlUnicodeText, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing); break; } case SaveAsFileFormat.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, missing); break; } } } catch (Exception e) { throw e; } finally { this.Quit(); } }
private void button12_Click(object sender, EventArgs e) { string filetype = comboBox1.Text; string extensions = string.Empty; SaveAsFileFormat format = SaveAsFileFormat.EXCEL; if (filetype == "") { MessageBox.Show("请选择一项!"); return; } switch (filetype) { case "EXCEL": extensions = "xls"; format = SaveAsFileFormat.EXCEL; break; case "CSV": extensions = "csv"; format = SaveAsFileFormat.CSV; break; case "TEXT": extensions = "txt"; format = SaveAsFileFormat.TEXT; break; case "XML": extensions = "xml"; format = SaveAsFileFormat.XML; break; case "HTML": extensions = "html"; format = SaveAsFileFormat.HTML; break; } string filepath = _path + "导出文件." + extensions; _helper = new ExcelHelper(_path + "初始化数据.xls", filepath); _helper.SaveAsFile(format); MessageBox.Show("已导出文件!"); }
/// <summary> /// 将Excel文件另存为指定格式 /// </summary> /// <param name="format">HTML,CSV,TEXT,EXCEL,XML</param> public void SaveAsFile(SaveAsFileFormat format) { if (this.outputFile == null) throw new Exception("没有指定输出文件路径!"); try { switch (format) { case SaveAsFileFormat.HTML: { workBook.SaveAs(outputFile, Excel.XlFileFormat.xlHtml, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing); break; } case SaveAsFileFormat.CSV: { workBook.SaveAs(outputFile, Excel.XlFileFormat.xlCSV, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing); break; } case SaveAsFileFormat.TEXT: { workBook.SaveAs(outputFile, Excel.XlFileFormat.xlUnicodeText, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing); break; } case SaveAsFileFormat.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, missing); break; } } } catch (Exception e) { throw e; } finally { this.Quit(); } }