随笔 - 76, 文章 - 0, 评论 - 5, 阅读 - 46412

导航

< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

Microsoft.Office.Interop.Excel,将xlsx换为pdf

Posted on   WinChance  阅读(111)  评论(0编辑  收藏  举报

利用Microsoft.Office.Interop.Excel,将xlsx换为pdf(保留源格式)

复制代码
public void ConvertExcelToPdf2(string inputFilePath, string outputFilePath)
{
    Application excelApp = new Application();
    Workbook workbook = excelApp.Workbooks.Open(inputFilePath);

    try
    {
        foreach (Worksheet worksheet in workbook.Worksheets)
        {
            worksheet.PageSetup.Orientation = XlPageOrientation.xlLandscape;
            worksheet.PageSetup.Zoom = false;
            worksheet.PageSetup.FitToPagesWide = 1;
            worksheet.PageSetup.FitToPagesTall = false;
        }

        workbook.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF, outputFilePath);
    }
    finally
    {
        workbook.Close(false);
        excelApp.Quit();

        ReleaseCOMObject(workbook);
        ReleaseCOMObject(excelApp);
    }
}

private void ReleaseCOMObject(object obj)
{
    try
    {
        System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
        obj = null;
    }
    catch (Exception ex)
    {
        obj = null;
        Console.WriteLine("Exception occurred while releasing COM object: " + ex.ToString());
    }
    finally
    {
        GC.Collect();
    }
}
复制代码

 

相关博文:
阅读排行:
· 震惊!C++程序真的从main开始吗?99%的程序员都答错了
· 【硬核科普】Trae如何「偷看」你的代码?零基础破解AI编程运行原理
· 单元测试从入门到精通
· 上周热点回顾(3.3-3.9)
· winform 绘制太阳,地球,月球 运作规律
点击右上角即可分享
微信分享提示