提交一把

jiangping

2024-06-07 8a266df75e912cc4ff49bc504db5b6b26f152892

 server/service/src/main/java/com/doumee/core/annotation/excel/ExcelToPdfTool.java

@@ -2,6 +2,9 @@
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

import java.io.File;
import java.io.InputStream;

/**
 * Excel导出实现
 * @author Eva.Caesar Liu
@@ -10,8 +13,8 @@
public class ExcelToPdfTool  {

        public static void main(String[] args)  {
            String inputExcelPath = "D:\\1.xlsx";
            String outputPdfPath = "D:\\555.pdf";
            String inputExcelPath = "/temp/1.xlsx";
            String outputPdfPath = "/temp/1..pdf";
/*            Workbook workbook = new Workbook();
            workbook.loadFromFile(inputExcelPath);

@@ -30,7 +33,34 @@
            //创建Workbook 实例并加载示例文档
            Workbook workbook = new Workbook();
            workbook.loadFromFile(inputExcelPath);
            //转换时设置工作表适应宽度
            workbook.getConverterSetting().setSheetFitToWidth(true);

            //获取第一个工作表
            Worksheet worksheet = workbook.getWorksheets().get(0);

            //保存为PDF文档格式
            worksheet.saveToPdf(outputPdfPath);

        }
        public static void excelToPdf(InputStream is,String outputPdfPath) {
            //创建Workbook 实例并加载示例文档
            Workbook workbook = new Workbook();
            workbook.loadFromStream(is);
            //转换时设置工作表适应宽度
            workbook.getConverterSetting().setSheetFitToWidth(true);

            //获取第一个工作表
            Worksheet worksheet = workbook.getWorksheets().get(0);

            //保存为PDF文档格式
            worksheet.saveToPdf(outputPdfPath);

        }
        public static void excelToPdf(String file, String outputPdfPath) {
            //创建Workbook 实例并加载示例文档
            Workbook workbook = new Workbook();
            workbook.loadFromFile(file);
            //转换时设置工作表适应宽度
            workbook.getConverterSetting().setSheetFitToWidth(true);