|
|
using Aspose.Cells;
|
using Aspose.Cells.Rendering;
|
using iWareCommon.Utils;
|
using System;
|
using System.Threading;
|
using WindowsFormsApplication1;
|
|
|
|
|
namespace autuPrint.printService
|
{
|
public static class print
|
{
|
private static Mutex single = new Mutex();
|
static Form1 form = Program.f;
|
/// <summary>
|
/// 打印指定文件
|
/// </summary>
|
/// <param name="path">要打印的路径</param>
|
|
/// <returns>成功返回true</returns>
|
public static bool printExcel(string path, double leftMargin, double topMargin)
|
{
|
//获取模板
|
|
if (single.WaitOne())//增加线程锁防止双击并发
|
{
|
try
|
{
|
Workbook workbook = new Workbook(path);
|
/// Cells cells = worksheet.Cells;//获取所有单元格
|
Worksheet worksheet = workbook.Worksheets[0];//获取该Excel文档的第一个工作表
|
PageSetup pageSetup = worksheet.PageSetup;
|
pageSetup.Orientation = PageOrientationType.Portrait;//纵向打印
|
pageSetup.LeftMargin = leftMargin;//偏移量
|
// pageSetup.RightMargin = 0.1;
|
// pageSetup.BottomMargin = 0.3;
|
pageSetup.TopMargin = topMargin;
|
//pageSetup.PaperSize = PaperSizeType.;//设置纸张大小
|
Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions();
|
SheetRender sr = new SheetRender(worksheet, options);
|
//找到默认打印机
|
System.Drawing.Printing.PrinterSettings printSettings = new System.Drawing.Printing.PrinterSettings();
|
string strPrinterName = printSettings.PrinterName;
|
|
|
sr.ToPrinter(strPrinterName);//开始打印
|
|
|
}
|
catch (Exception ex)
|
{
|
Log4NetHelper.WriteErrorLog(LogType.Print, "类名: print 方法名: printExcel 打印文件出错 \r\n " + ex.ToString(), ex);
|
return false;
|
}
|
finally { single.ReleaseMutex(); }//一轮结束
|
}
|
return true;
|
}
|
}
|
}
|
