java excel转pdf jacob设置页边距

使用jacob将Excel转换为PDF并设置页边距的示例代码如下：

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.Dispatch;
import com.jacob.com.Variant;

public class ExcelToPdfConverter {

    public static void main(String[] args) {
        convertExcelToPdf("C:\\temp\\test.xlsx", "C:\\temp\\test.pdf");
    }

    public static void convertExcelToPdf(String excelFile, String pdfFile) {
        ActiveXComponent excel = new ActiveXComponent("Excel.Application");
        try {
            excel.setProperty("Visible", false);

            Dispatch workbooks = excel.getProperty("Workbooks").toDispatch();
            Dispatch workbook = Dispatch.call(workbooks, "Open", excelFile).toDispatch();

            Dispatch sheets = Dispatch.get(workbook, "Sheets").toDispatch();
            Dispatch sheet = Dispatch.call(sheets, "Item", 1).toDispatch();

            Dispatch pageSetup = Dispatch.get(sheet, "PageSetup").toDispatch();
            Dispatch.put(pageSetup, "LeftMargin", new Variant(10));
            Dispatch.put(pageSetup, "RightMargin", new Variant(10));
            Dispatch.put(pageSetup, "TopMargin", new Variant(10));
            Dispatch.put(pageSetup, "BottomMargin", new Variant(10));

            Dispatch.call(sheet, "ExportAsFixedFormat", new Variant(0), pdfFile);

            Dispatch.call(workbook, "Close", new Variant(false));
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            excel.invoke("Quit", new Variant[]{});
        }
    }
}

在上面的代码中，我们使用jacob库来打开Excel文件并将第一个sheet导出为PDF文件。我们使用Dispatch类来获取Excel对象的属性和方法。在设置页边距时，我们获取了PageSetup对象并使用put方法设置左、右、上、下边距的值。

注意：在使用jacob之前，您需要将jacob.dll文件添加到您的项目中，并将其路径添加到您的系统路径中。