/// <summary> /// 打印Excel文件,可以设置是否打印预览,以及打印的份数 /// </summary> /// <param name="IsPrintPreview">打印前是否预览 , true:打印前预览false:直接打印,不预览</param> /// <param name="iCopy">打印的份数</param> public void Print(bool IsPrintPreview, int iCopy) { if (iCopy < 1) { iCopy = 1; } ExlWorkSheet.PrintOut(Missing.Value, Missing.Value, Missing.Value, IsPrintPreview, iCopy, Missing.Value, Missing.Value, Missing.Value); }
/// <summary> /// 打印Excel文件,可以设置是否是打印前预览打印的Excel文件 /// </summary> /// <param name="IsPrintPreview">打印前是否预览 , true:打印前预览false:直接打印,不预览 </param> public void Print(bool IsPrintPreview) { bool flag = ExlApp.Visible; if (ExlApp.Visible) { ExlApp.Visible = true; } ExlWorkSheet.PrintOut(Missing.Value, Missing.Value, Missing.Value, IsPrintPreview, Missing.Value, Missing.Value, Missing.Value, Missing.Value); ExlApp.Visible = flag; }
/// <summary> /// 保存Excel文件 /// </summary> /// <param name="fileName">保存的文件名</param> public void SaveAs(string fileName) { if (ExlWorkSheet == null) { throw new Exception("未初始化的表格"); } try { ExlWorkSheet.SaveAs(fileName, Missing.Value, Missing.Value, Missing.Value, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value); } catch (Exception ex) { Console.WriteLine("ExcelSaveAs()" + ex.Message); } }
/// <summary> /// 打印预览Excel文件 /// </summary> public void PrintPreview() { ExlWorkSheet.PrintPreview(Missing.Value); }