java将excel转为PDF

要将Excel转为PDF，可以使用Java中的Apache POI和iText库。

首先，需要从Apache POI官网下载poi-bin和poi-ooxml两个库，并将它们放在项目的classpath中。

接下来，使用POI库读取Excel文件内容，然后使用iText库将内容写入到PDF文件中。具体代码如下：

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;

import com.itextpdf.text.Document;
import com.itextpdf.text.DocumentException;
import com.itextpdf.text.PageSize;
import com.itextpdf.text.pdf.PdfWriter;

public class ExcelToPDFConverter {

    public static void main(String[] args) {
        String excelFilePath = "path/to/excel/file.xlsx";
        String pdfFilePath = "path/to/pdf/file.pdf";

        try {
            // Load Excel file
            Workbook workbook = WorkbookFactory.create(new File(excelFilePath));
            
            // Create PDF document
            Document document = new Document(PageSize.A4);
            PdfWriter.getInstance(document, new FileOutputStream(pdfFilePath));
            document.open();
            
            // Loop through all sheets in Excel file
            for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
                // Get current sheet
                org.apache.poi.ss.usermodel.Sheet sheet = workbook.getSheetAt(i);
                
                // Loop through all rows in current sheet
                for (int j = 0; j <= sheet.getLastRowNum(); j++) {
                    // Get current row
                    org.apache.poi.ss.usermodel.Row row = sheet.getRow(j);
                    
                    // Loop through all cells in current row
                    for (int k = 0; k < row.getLastCellNum(); k++) {
                        // Get current cell value
                        String cellValue = row.getCell(k).getStringCellValue();
                        
                        // Write cell value to PDF document
                        document.add(new com.itextpdf.text.Paragraph(cellValue));
                    }
                }
            }
            
            // Close PDF document and Excel workbook
            document.close();
            workbook.close();
            
            System.out.println("Excel file converted to PDF successfully!");
        } catch (IOException | DocumentException e) {
            e.printStackTrace();
        }
    }
}

在执行该代码之前，需要确保已经安装了iText库，并将其添加到项目的classpath中。