1. 之前在一個(gè)項(xiàng)目中，客戶需要將生成的Excel文件進(jìn)一步生成圖片。在google上找到了一個(gè)博客：
   ExcelToImage
   核心代碼如下：

public class ExcelToImageConverter {

    public static String generateImages(final String excelPath, String saveDir) {
        long currentTimes = System.currentTimeMillis();

        String imageFilePath = null;
        if (saveDir.lastIndexOf("/") != saveDir.length() - 1) {
            saveDir += "/";
        }

        try {
            Workbook workbook = new Workbook(excelPath);
            CellsHelper.setFontDir(fontDir);
            List<Worksheet> worksheets = getAllWorksheets(workbook);
            if (worksheets != null && worksheets.size() > 0) {
                for (Worksheet worksheet : worksheets) {
                    Worksheet worksheet = worksheets.get(0);
                    if (worksheet.getCells().getCount() > 0 || worksheet.getCharts().getCount() > 0 || worksheet.getPictures().getCount() > 0) {
                        imageFilePath = saveDir + RandomStringUtils.randomAlphanumeric(30) + ".jpeg";
                        SheetRender sr = new SheetRender(worksheet, getImageOrPrintOptions());
                        sr.toImage(0, imageFilePath);
                        return imageFilePath;
                    }
              }
            }
        } catch (Exception e) {
            log.error("excel轉(zhuǎn)圖片失敗，excelPath={}", excelPath, e);
        }

        long endTimes = System.currentTimeMillis();
        System.out.println(endTimes - currentTimes);

        return imageFilePath;
    }

    /**
     * Returns all worksheets present in given workbook.
     *
     * @param workbook
     * @return all worksheets present in given workbook.
     */
    private static List<Worksheet> getAllWorksheets(final Workbook workbook) {
        List<Worksheet> worksheets = new ArrayList<Worksheet>();
        WorksheetCollection worksheetCollection = workbook.getWorksheets();
        for (int i = 0; i < worksheetCollection.getCount(); i++) {
            worksheets.add(worksheetCollection.get(i));
        }
        return worksheets;
    }

    /**
     * Returns ImageOrPrintOptions for png images
     *
     * @return
     */
    private static ImageOrPrintOptions getImageOrPrintOptions() {
        ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
        imgOptions.setImageFormat(ImageFormat.getJpeg());
        imgOptions.setOnePagePerSheet(true);
        return imgOptions;
    }
}

它用到的框架是aspose.cells,如果Excel中存在中文字符，而你部署的Linux服務(wù)器沒有中文字體，那么會(huì)顯示中文亂碼。解決辦法CellsHelper.setFontDir(fontDir);，同時(shí)把你的中文字體放到服務(wù)器的fontDir路徑下。獲取中文字體辦法：在Windows系統(tǒng)下進(jìn)入路徑C:\Windows\Fonts

2. Excel轉(zhuǎn)成的圖片的表頭含有aspose這個(gè)框架的開源協(xié)議，解決辦法：完成Excel轉(zhuǎn)圖片的操作后，對(duì)圖片進(jìn)行裁剪，將開源協(xié)議部分裁去。裁剪圖片