/// <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);
}
