package com.doumee.core.annotation.excel;
|
import com.spire.xls.Workbook;
|
import com.spire.xls.Worksheet;
|
|
import java.io.File;
|
import java.io.InputStream;
|
|
/**
|
* Excel导出实现
|
* @author Eva.Caesar Liu
|
* @date 2023/02/14 11:14
|
*/
|
public class ExcelToPdfTool {
|
|
public static void main(String[] args) {
|
String inputExcelPath = "/temp/1.xlsx";
|
String outputPdfPath = "/temp/1..pdf";
|
/* Workbook workbook = new Workbook();
|
workbook.loadFromFile(inputExcelPath);
|
|
//转换时设置工作表适应宽度
|
workbook.getConverterSetting().setSheetFitToWidth(true);
|
|
//获取第一个工作表
|
Worksheet worksheet = workbook.getWorksheets().get(0);
|
// File f = new File(outputPdfPath);
|
// if(!f.exists()){
|
// f.createNewFile();
|
// }
|
//保存为PDF文档格式
|
worksheet.saveToPdf(outputPdfPath);*/
|
|
//创建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);
|
|
//获取第一个工作表
|
Worksheet worksheet = workbook.getWorksheets().get(0);
|
|
//保存为PDF文档格式
|
worksheet.saveToPdf(outputPdfPath);
|
|
}
|
|
}
|
