透過 Aspose 將 datatable 的資料轉出成有浮水印的 PDF 檔 (2)

2018-07-13

前言

在透過 Aspose 將 datatable 的資料轉出成有浮水印的 PDF 檔一文中，驗證可透過 Aspose 元件來達到將 DataTable 的資料轉成有浮水印的 PDF 檔案。但實際用在專案上還有段距離，例如，

設定表頭/表尾
欄位名稱可否換行，對齊方式
可否設定欄位的寬度，格式(日期、數值)，對齊方式
可否設定列印比例
浮水印要有一定的覆蓋比率

實作

DataTable => 換 ColumnName => Excel => Pdf => Pdf+浮水印
以上面的需求，我們可以將程式切分成 2 段，一是 DataTable 轉資料到 Excel 轉存成 PDF，二再將該 PDF 加上浮水印。

設定表頭/表尾
可以透過 PageSetup.SetHeader(0, “表頭左邊”); 或是 PageSetup.SetFooter(2, “表尾右邊”); 它是使用 0 ~ 2 來表示左、中、右區段。這裡有一個部份要注意的是，如果在表頭、表尾區段要換行的話，也是使用 \n 嗎? 不可以哦~ 用 \n 中間會多一行哦! 所以這裡要改用 \r 才可以哦!
欄位名稱可否換行，對齊方式
在 ColumnName 中加入 \n 來換行，同時要設定 Cell 的 Stype IsTextWrapped 值為 true。如果 IsTextWrapped 設定為 fasle 的話，在 ColumnName 設定 \n 也不會換行的哦! 另外，程式中會呼叫 AutoFitColumns 及 AutoFitRows ，所以要讓它可以計算正常的話，請記得要設定系統中有的字型哦~ 例如「標楷體」
可否設定欄位的寬度，格式(日期、數值)，對齊方式
可以透過 Worksheet.Cells.SetColumnWidth 來設定欄寬 (0~255)Cells.SetColumnWidth，因為在設定欄位部份，除了設定顯示名稱之外，多了一個設定欄寬及欄位的屬性(用於格式(日期、數值)，對齊方式)，所以傳遞參數中我們改用 Tuple 可以讓我們存放多個值。
可否設定列印比例
可以設定 PageSetup.Zoom 的值 (10~400)，預設值是 100。有時如果我們的內容太長時，有可能會跨頁，所以我們可以設定「列印比例」來讓 Excel 印到 PDF 時，可以縮到一頁以內，這時就可以設定這個值了哦!
浮水印要有一定的覆蓋比率
在 PDF 要使用浮水印，我們可以透過 Stamp 物件來貼到 PDF 文件之中，因為我們範例是使用文字，所以是建立 TextStamp 物件，要針對文字做處理，可以透過 FormattedText 來處理。所以，如果浮水印要換行的話，可以使用 \n 或是加入 Environment.NewLine 即可。
建立好 TextStamp 後，就要依需求來貼到 PDF 之中，如果是蓋滿整個 PDF 文件的話，就可以設定 TextStamp 物件的 Width, Height 跟 PDF Page 的 CropBox Width 及 Height 一樣的大小。
如果是要依 TextStamp 物件去蓋滿 PDF Page 的話，就可以從 PDF Page 的 CropBox Width 及 Height 去 loop 貼到 PDF Page 上。

透過以上的分析後，我們就可以將它抽出來成為公用的 PDFReportUtility Class，如下，

public class PDFReportUtility
{

	// 增加功能
	// 1.excel header 及 footer 及 可設定欄寬
	// 2.pdf watermark 整頁或是充滿

	/// <summary>
	/// DataTable 轉到 Excel 的參數
	/// </summary>
	/// <remarks>
	/// 2018/07/16 欄位需要設定數值或是日期
	/// </remarks>
	public struct ExportDataTable2ExcelArg
	{
		public DataTable dataSource;
		//columnId, columnDisplayName, columnWidth, cloumnStyle
		public Dictionary<string, Tuple<string, double, Style>> ColumnInfos;
		//是否允許換行
		public bool IsTextWrapped;
		//字型名稱，如果不允許換行的話，autoFitColumns 會依字型去算寬度
		public string FontName;
		//直/橫 印
		public PageOrientationType PageOrientation;
		//縮放比例
		public int PageScale; //10~400

		//表頭 左、中、右
		public string HeaderLeft;
		public string HeaderCenter;
		public string HeaderRight;
		//表尾 左、中、右
		public string FooterLeft;
		public string FooterCenter;
		public string FooterRight;
		//欄位對齊方式
		public TextAlignmentType HeaderHorizontalAlignment;

	}

	/// <summary>
	/// 浮水印設定參數
	/// </summary>
	public struct WatermarkArg
	{
		//浮水印字串
		public string Watermark;
		//浮水印 Stamp 的 Height
		public double WatermarkHeight;
		//浮水印 Stamp 的 Width
		public double WatermarkWidth;
		//浮水印 Stamp 的 水平間隔
		public double WatermarkHorizontalSpace;
		//浮水印 Stamp 的 垂直間隔
		public double WatermarkVerticalSpace;
		//浮水印 Stamp 貼上Style，目前有蓋滿一頁及水平蓋滿
		public WatermarkStyle WMStyle;
		//不透明度 0~ `
		public double Opacity;
		//旋轉角度
		public double RotateAngle;
	}

	public enum WatermarkStyle
	{
		//蓋滿一頁
		FitPage,
		//水平蓋滿
		RepeatHorizontal
	}



	/// <summary>
	/// 設定 DataTable 的 Column Name
	/// </summary>
	/// <param name="dt">datatable</param>
	/// <param name="columnInfos">item1:Column Name, item2:Column Width</param>
	private static void ChangedDataTableColumnName(DataTable dt, Dictionary<string, Tuple<string, double, Style>> columnInfos)
	{

		//change columnName
		if (columnInfos != null)
		{
			foreach (KeyValuePair<string, Tuple<string, double, Style>> columnInfo in columnInfos)
			{
				if (dt.Columns[columnInfo.Key] != null)
					dt.Columns[columnInfo.Key].ColumnName = columnInfo.Value.Item1;
			}
		}
	}

	/// <summary>
	/// 設定 Worksheet 的 欄位寬度
	/// </summary>
	/// <param name="sheet">綁定 DataTable 的 Worksheet </param>
	/// <param name="columnInfos">item1:Column Name, item2:Column Width</param>
	private static void ChangedSheetColumnStyle(Worksheet sheet, Dictionary<string, Tuple<string, double, Style>> columnInfos, TextAlignmentType headerHorizontalAlignment)
	{
		//change columnName
		if (columnInfos != null)
		{
			var columnIndex = 0;
			foreach (KeyValuePair<string, Tuple<string, double, Style>> columnInfo in columnInfos)
			{
				if (columnInfo.Value.Item2 > -1)
				{
					sheet.Cells.SetColumnWidth(columnIndex, columnInfo.Value.Item2);
				}

				if(columnInfo.Value.Item3 != null)
				{
					var styleFlag = new StyleFlag();
					styleFlag.NumberFormat = true;
					styleFlag.HorizontalAlignment = true;
					sheet.Cells.Columns[columnIndex].ApplyStyle(columnInfo.Value.Item3, styleFlag);
				}

				//設定 header 列
				var cellStyle = sheet.Cells[columnIndex, 0].GetStyle();
				var cellStyleFlag = new StyleFlag();
				cellStyleFlag.HorizontalAlignment = true;
				cellStyle.HorizontalAlignment = headerHorizontalAlignment;
				sheet.Cells[0, columnIndex].SetStyle(cellStyle, cellStyleFlag);
				columnIndex++;
			}
		}
	}

	/// <summary>
	/// 將 DataTable 的資料轉到Excel處理並存成 PDF Stream
	/// </summary>
	/// <param name="arg"></param>
	/// <returns></returns>
	public static MemoryStream GenPDFFromDataTable(ExportDataTable2ExcelArg arg)
	{
		//Change DataTable's ColumnName
		ChangedDataTableColumnName(arg.dataSource, arg.ColumnInfos);

		//proc excel
		// Instantiating a Workbook object
		var workbook = new Workbook();
		if (!string.IsNullOrWhiteSpace(arg.FontName))
		{
			var wbStyle = workbook.DefaultStyle;
			wbStyle.Font.Name = arg.FontName;
			workbook.DefaultStyle = wbStyle;
		}
		var worksheet = workbook.Worksheets[0];
		worksheet.Cells.ImportDataTable(arg.dataSource, true, "A1");



		//https://docs.aspose.com/display/cellsnet/Setting+Page+Options
		var pageSetup = workbook.Worksheets[0].PageSetup;
		pageSetup.PrintTitleRows = "$1:$1";
		pageSetup.IsPercentScale = true;
		pageSetup.Orientation = arg.PageOrientation;
		pageSetup.Zoom = arg.PageScale < 10 ? 100 : arg.PageScale;
		//https://docs.aspose.com/display/cellsnet/Setting+Headers+and+Footers
		if (!string.IsNullOrEmpty(arg.HeaderLeft))
		{
			pageSetup.SetHeader(0, arg.HeaderLeft);
		}
		if (!string.IsNullOrEmpty(arg.HeaderCenter))
		{
			pageSetup.SetHeader(1, arg.HeaderCenter);
		}
		if (!string.IsNullOrEmpty(arg.HeaderRight))
		{
			pageSetup.SetHeader(2, arg.HeaderRight);
		}

		if (!string.IsNullOrEmpty(arg.FooterLeft))
		{
			pageSetup.SetFooter(0, arg.FooterLeft);
		}
		if (!string.IsNullOrEmpty(arg.FooterCenter))
		{
			pageSetup.SetFooter(1, arg.FooterCenter);
		}
		if (!string.IsNullOrEmpty(arg.FooterRight))
		{
			pageSetup.SetFooter(2, arg.FooterRight);
		}

		var range = worksheet.Cells.MaxDisplayRange;
		//border
		//Setting border for each cell in the range
		var style = workbook.CreateStyle();
		var colorBlack = System.Drawing.Color.Black;
		style.SetBorder(BorderType.BottomBorder, CellBorderType.Medium, colorBlack);
		style.SetBorder(BorderType.LeftBorder, CellBorderType.Medium, colorBlack);
		style.SetBorder(BorderType.RightBorder, CellBorderType.Medium, colorBlack);
		style.SetBorder(BorderType.TopBorder, CellBorderType.Medium, colorBlack);
		style.IsTextWrapped = arg.IsTextWrapped;
		range.SetStyle(style);
		worksheet.AutoFitColumns();
		//adjust columns
		ChangedSheetColumnStyle(worksheet, arg.ColumnInfos, arg.HeaderHorizontalAlignment);
		worksheet.AutoFitRows();
		//string xlsFile = Path.Combine(HttpContext.Current.Server.MapPath("./data"), $"test.xlsx");
		//workbook.Save(xlsFile, Aspose.Cells.SaveFormat.Xlsx);
		//save to stream
		var pdfStream = new MemoryStream();
		workbook.Save(pdfStream, Aspose.Cells.SaveFormat.Pdf);

		return pdfStream;
	}

	/// <summary>
	/// 將 PDF 加上 浮水印
	/// </summary>
	/// <param name="pdfStream"></param>
	/// <param name="arg"></param>
	/// <returns></returns>
	public static MemoryStream AddWatermark(MemoryStream pdfStream, WatermarkArg arg)
	{

		var pdfDocument = new Aspose.Pdf.Document(pdfStream);
		if (!string.IsNullOrWhiteSpace(arg.Watermark))
		{
			var text = new FormattedText(arg.Watermark);
			foreach (var page in pdfDocument.Pages)
			{
				switch (arg.WMStyle)
				{
					case WatermarkStyle.FitPage:
						AddWatermarkFitPage(page, arg);
						break;
					case WatermarkStyle.RepeatHorizontal:
						AddWatermarkRepeatHorizontal(page, arg);
						break;

					default:
						break;
				}
			}
		}
		var newPdfStream = new MemoryStream();
		pdfDocument.Save(newPdfStream);
		return newPdfStream;
	}

	/// <summary>
	/// 浮水印跟頁面一樣大
	/// </summary>
	/// <param name="pdfPage"></param>
	/// <param name="arg"></param>
	private static void AddWatermarkFitPage(Aspose.Pdf.Page pdfPage, WatermarkArg arg)
	{
		var text = new FormattedText(arg.Watermark);
		var stamp = new TextStamp(text);
		stamp.RotateAngle = arg.RotateAngle;
		stamp.XIndent = arg.WatermarkHorizontalSpace;
		stamp.YIndent = arg.WatermarkVerticalSpace;
		stamp.Opacity = arg.Opacity;
		stamp.Width = pdfPage.CropBox.Width;
		stamp.Height = pdfPage.CropBox.Height;
		pdfPage.AddStamp(stamp);
	}

	//最小的 浮水印 長、寬
	const double minValue = 30;

	/// <summary>
	/// 依 浮水印 水平地蓋滿整個頁面
	/// </summary>
	/// <param name="pdfPage"></param>
	/// <param name="arg"></param>
	private static void AddWatermarkRepeatHorizontal(Aspose.Pdf.Page pdfPage, WatermarkArg arg)
	{

		if (arg.WatermarkHeight < minValue)
			throw new ArgumentException($"{nameof(arg.WatermarkHeight)} must greater than {minValue}");
		if (arg.WatermarkWidth < minValue)
			throw new ArgumentException($"{nameof(arg.WatermarkWidth)} must greater than {minValue}");

		var text = new FormattedText(arg.Watermark);
		var yIndent = pdfPage.CropBox.Height - arg.WatermarkHeight;
		var yLimit = 0 - (arg.WatermarkHeight + arg.WatermarkVerticalSpace);
		var pageWidth = pdfPage.CropBox.Width;
		var xIndent = 0d;
		while (yIndent > yLimit)
		{
			while (xIndent < pageWidth)
			{
				var stamp = new TextStamp(text);
				stamp.RotateAngle = arg.RotateAngle;
				stamp.XIndent = xIndent;
				stamp.YIndent = yIndent;
				stamp.Opacity = arg.Opacity;
				stamp.Width = arg.WatermarkWidth;
				stamp.Height = arg.WatermarkHeight;
				pdfPage.AddStamp(stamp);
				xIndent += (arg.WatermarkWidth + arg.WatermarkHorizontalSpace);
			}
			xIndent = 0;
			var yIdentReduce = (arg.WatermarkHeight + arg.WatermarkVerticalSpace);

			yIndent -= yIdentReduce;
		}

	}

	/// <summary>
	/// 以角度線性期function來呈現
	/// </summary>
	/// <param name="pdfPage"></param>
	/// <param name="arg"></param>
	private static void AddWatermarkRepeatRotateAngle(Aspose.Pdf.Page pdfPage, WatermarkArg arg)
	{

		if (arg.WatermarkHeight < minValue)
			throw new ArgumentException($"{nameof(arg.WatermarkHeight)} must greater than {minValue}");
		if (arg.WatermarkWidth < minValue)
			throw new ArgumentException($"{nameof(arg.WatermarkWidth)} must greater than {minValue}");

		var text = new FormattedText(arg.Watermark);
		var yIndent = pdfPage.CropBox.Height - arg.WatermarkHeight;
		var yLimit = 0 - (arg.WatermarkHeight + arg.WatermarkVerticalSpace);
		var pageWidth = pdfPage.CropBox.Width;
		var pageHeight = pdfPage.CropBox.Height;
		var xIndent = 0d;
		while (yIndent > yLimit)
		{
			var y = yIndent;
			while (xIndent < pageWidth && y < pageHeight)
			{
				var stamp = new TextStamp(text);
				stamp.RotateAngle = arg.RotateAngle;
				stamp.XIndent = xIndent;
				stamp.YIndent = y;
				stamp.Opacity = arg.Opacity;
				stamp.Width = arg.WatermarkWidth;
				stamp.Height = arg.WatermarkHeight;
				pdfPage.AddStamp(stamp);
				xIndent += (arg.WatermarkWidth + arg.WatermarkHorizontalSpace);
				xIndent = xIndent + Math.Cos(30) * arg.WatermarkWidth;
				y = y + Math.Sign(30) * (arg.WatermarkHeight + arg.WatermarkVerticalSpace);
			}
			xIndent = 0;
			var yIdentReduce = (arg.WatermarkHeight + arg.WatermarkVerticalSpace);
			yIndent -= yIdentReduce;
		}

		//到底了，要再連走 X
		var baseX = 0d;
		while (baseX < pageWidth)
		{
			var y = yIndent;
			xIndent = baseX;
			while (xIndent < pageWidth)
			{
				var stamp = new TextStamp(text);
				stamp.RotateAngle = arg.RotateAngle;
				stamp.XIndent = xIndent;
				stamp.YIndent = y;
				stamp.Opacity = arg.Opacity;
				stamp.Width = arg.WatermarkWidth;
				stamp.Height = arg.WatermarkHeight;
				pdfPage.AddStamp(stamp);
				xIndent += (arg.WatermarkWidth + arg.WatermarkHorizontalSpace);
				xIndent = xIndent + Math.Cos(30) * arg.WatermarkWidth;
				y = y + Math.Sign(30) * (arg.WatermarkHeight + arg.WatermarkVerticalSpace);
			}
			baseX += (arg.WatermarkWidth + arg.WatermarkHorizontalSpace); ;
		}
	}
}

測試

所以我們新增 2 個 Button 來測試，

註: 因為共用的 function 都是回傳 Stream，所以這們可以將做好的 PDF 檔放到 Byte Array 之中，再透過 Response.BinaryWrite 傳給使用者下載檔案 ^_^

產生測試的 DataTable

private DataTable GetDataSource()
{
	// Instantiating a "Products" DataTable object
	var dataTable = new DataTable("Products");
	// Adding columns to the DataTable object
	dataTable.Columns.Add("ProductID", typeof(Int32));
	dataTable.Columns.Add("ProductName", typeof(string));
	dataTable.Columns.Add("ProductDesc", typeof(string));
	dataTable.Columns.Add("Units", typeof(Double));
	dataTable.Columns.Add("CreDte", typeof(DateTime));
	var rand = new Random();
	for (var i = 0; i < 90; i++)
	{
		dataTable.Rows.Add(i, $"產品名稱-{i} 讓產品名稱自己說話 abc {i} ...{i}", $"產品描述 -{i}塑造出帶有「情感」的品牌概念 -{i}產品描述 -產品描述 -產品描述 -", rand.NextDouble(), DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
	}
	return dataTable;
}

1.ColumnName 換行，IsTextWrapped = true, 設定寬度為 5，右表頭加入 2 列(換行)，設定日期格式，第一列表頭對齊方式為置中，浮水印蓋滿一頁。

protected void btnGenPDFFitPage_Click(object sender, EventArgs e)
{

	var excelArg = new ExportDataTable2ExcelArg
	{
		dataSource = GetDataSource(),
		HeaderCenter = "&24 This is Report Header ...",
		HeaderRight = $"&10 使用者:Rainmaker\r日期:{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")}",
		FooterRight = "&10 &P/&N",
		ColumnInfos = new Dictionary<string, Tuple<string, double, Aspose.Cells.Style>>
		{
			{"ProductID", new Tuple<string, double, Aspose.Cells.Style>($"產品\n代號", 5, null) },
			{"ProductName", new Tuple<string, double, Aspose.Cells.Style>("產品名稱" , -1, null) },
			{"ProductDesc", new Tuple<string, double, Aspose.Cells.Style>("產品 \n描述" , -1,null) },
			{"Units", new Tuple<string, double, Aspose.Cells.Style>("產品 庫存" , -1, new Aspose.Cells.Style{  HorizontalAlignment= TextAlignmentType.Center})},
			 {"CreDte", new Tuple<string, double, Aspose.Cells.Style>("日期" , 20, new Aspose.Cells.Style{ Number=22, Custom = "yyyy/mm/dd hh:mm:ss" , HorizontalAlignment= TextAlignmentType.Center}) }
		},
		PageOrientation = PageOrientationType.Landscape,
		IsTextWrapped = true,
		PageScale = 80,
		HeaderHorizontalAlignment = TextAlignmentType.Center
	};
	var pdfStream = GenPDFFromDataTable(excelArg);
	var fileNameWithoutExt = $"{Guid.NewGuid().ToString("N")}";
	//string pdfFileName = Path.Combine(Server.MapPath("./data"), $"{fileNameWithoutExt}_temp.pdf");
	//using (FileStream file = new FileStream(pdfFileName, FileMode.Create, System.IO.FileAccess.Write))
	//    pdfStream.CopyTo(file);

	var watermarkArg = new WatermarkArg
	{
		Watermark = $"* 使用者:亂馬客 *{Environment.NewLine}{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")}",
		WMStyle = WatermarkStyle.FitPage,
		RotateAngle = 0,
		Opacity = .1

	};
	var waterStream = AddWatermark(pdfStream, watermarkArg);
	//另存檔案
	//string watermarkFileName = Path.Combine(Server.MapPath("./data"), $"{fileNameWithoutExt}.pdf");
	//using (FileStream file = new FileStream(watermarkFileName, FileMode.Create, System.IO.FileAccess.Write))
	//    waterStream.CopyTo(file);
	//直接給Client
	Response.ContentType = "application/pdf";
	Response.AddHeader("content-disposition", "attachment; filename=" + $"{fileNameWithoutExt}.pdf");
	var fileSize = waterStream.Length;
	byte[] pdfBuffer = new byte[(int)fileSize];
	waterStream.Read(pdfBuffer, 0, (int)fileSize);
	waterStream.Close();
	Response.BinaryWrite(pdfBuffer);
	Response.End();
}

產生出來的 PDF 如下圖，

2.ColumnName 自動調整，IsTextWrapped = false，列印比例設定為 90，右表頭加入 2 列(換行)，Cell 字型設定為 “標楷體”(請檢查 Windows\fonts 中是否有該字型)，浮水印水平蓋滿一頁，旋轉角度 30 度。

protected void btnGenPDFRepeatHorizontal_Click(object sender, EventArgs e)
{
	var excelArg = new ExportDataTable2ExcelArg
	{
		dataSource = GetDataSource(),
		HeaderCenter = "&24 This is Report Header ...",
		HeaderRight = $"&12 使用者:Rainmaker\r日期:{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")}",
		FooterRight = "&10 &P/&N",
		ColumnInfos = new Dictionary<string, Tuple<string, double, Aspose.Cells.Style>>
		{
			{"ProductID", new Tuple<string, double, Aspose.Cells.Style>($"產品代號", -1, null) },
			{"ProductName", new Tuple<string, double, Aspose.Cells.Style>("產品名稱" , -1, null) },
			{"ProductDesc", new Tuple<string, double, Aspose.Cells.Style>("產品描述" , -1, null) },
			{"Units", new Tuple<string, double, Aspose.Cells.Style>("產品 庫存" , -1, null) },
			{"CreDte", new Tuple<string, double, Aspose.Cells.Style>("日期" , 10, new Aspose.Cells.Style{ Number = 14 }) }
		},
		PageOrientation = PageOrientationType.Landscape,
		IsTextWrapped = false,
		PageScale = 80,
		FontName = "標楷體",
		HeaderHorizontalAlignment = TextAlignmentType.Center
	};
	var pdfStream = GenPDFFromDataTable(excelArg);
	var fileNameWithoutExt = $"{Guid.NewGuid().ToString("N")}";
	//string pdfFileName = Path.Combine(Server.MapPath("./data"), $"{fileNameWithoutExt}_temp.pdf");
	//using (FileStream file = new FileStream(pdfFileName, FileMode.Create, System.IO.FileAccess.Write))
	//    pdfStream.CopyTo(file);

	var watermarkArg = new WatermarkArg
	{
		Watermark = $"* 使用者:亂馬客  *{Environment.NewLine}{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")}",
		WMStyle = WatermarkStyle.RepeatHorizontal,
		WatermarkHeight = 100,
		WatermarkWidth = 130,
		WatermarkHorizontalSpace = 50,
		WatermarkVerticalSpace = 30,
		RotateAngle = 30,
		Opacity = .1

	};
	var waterStream = AddWatermark(pdfStream, watermarkArg);
	//string watermarkFileName = Path.Combine(Server.MapPath("./data"), $"{fileNameWithoutExt}.pdf");
	//using (FileStream file = new FileStream(watermarkFileName, FileMode.Create, System.IO.FileAccess.Write))
	//    waterStream.CopyTo(file);
	Response.ContentType = "application/pdf";
	Response.AddHeader("content-disposition", "attachment; filename=" + $"{fileNameWithoutExt}.pdf");
	var fileSize = waterStream.Length;
	byte[] pdfBuffer = new byte[(int)fileSize];
	waterStream.Read(pdfBuffer, 0, (int)fileSize);
	waterStream.Close();
	Response.BinaryWrite(pdfBuffer);
	Response.End();
}

產生出來的 PDF 如下圖，

參考資料

透過 Aspose 將 datatable 的資料轉出成有浮水印的 PDF 檔
 Setting Page Options
Setting Headers and Footers
Aspose Stamps-Watermarks
Aspose Cells Style.Number Property
How to control and understand settings in the Format Cells dialog box in Excel
Column Number format to 4 decimal places

Demo 專案:rainmakerho/asposeExcel2PDF

jsonContent: meta: false pages: false posts: title: true date: true path: true text: false raw: false content: false slug: false updated: false comments: false link: false permalink: false excerpt: false categories: false tags: true