public void SaveAsPDF(MSExcel._Workbook _excelDoc, string targetPath, string tempPath, out bool success)
{
object missing = Type.Missing;
try
{
string temp = Util.PathExt.PathChangeDirectory(targetPath, tempPath);
_excelDoc.ExportAsFixedFormat(MSExcel.XlFixedFormatType.xlTypePDF, temp, MSExcel.XlFixedFormatQuality.xlQualityStandard, true, false, missing, missing, false, missing);
success = PDFEncrypt(temp, targetPath, true);
}
catch (Exception ex)
{
Log.LogHelper.AddException(ex.Message, true);
success = false;
}
}
/// <summary>
/// WorkbookをPDFファイルとして別名保存
/// </summary>
/// <param name="book">Workbook</param>
/// <param name="oPath">保存先のファイルパス</param>
public void SaveAsPdfAs(Excel.Workbook book, string oPath)
{
// http://msdn.microsoft.com/ja-jp/library/microsoft.office.tools.word.document.exportasfixedformat.aspx
// http://msdn.microsoft.com/en-us/library/bb412305.aspx
try {
book.ExportAsFixedFormat(
Type: Excel.XlFixedFormatType.xlTypePDF,
Filename: oPath,
Quality: Excel.XlFixedFormatQuality.xlQualityMinimum,
IncludeDocProperties: true,
IgnorePrintAreas: false,
OpenAfterPublish: false);
} catch (Exception e) {
System.Diagnostics.Debug.WriteLine(e.Message);
throw e;
}
}
