Java中excel转换为jpg/png图片 采用aspose-cells-18.6.jar

一  Java中excel转换为jpg/png图片 

package com.thinkgem.jeesite.modules.task.util;

import com.aspose.cells.ImageFormat;
import com.aspose.cells.ImageOrPrintOptions;
import com.aspose.cells.SheetRender;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
import java.io.File;

public class ConvertToImage {

    public  static void ConvertToImage (){

        String dataDir = getDataDir(ConvertToImage.class);
// Create a new Workbook object
// Open a template excel file
        Workbook book = null;
        try {
            //book = new Workbook(dataDir + "2018各项目情况.xlsx");
            book = new Workbook("D:\\20180702_Game10002_DataReport.xls");
            // Get the first worksheet
            //Worksheet sheet = book.getWorksheets().get(0);
            Worksheet sheet = book.getWorksheets().get(0);
            sheet.getPageSetup().setLeftMargin(-20);
            sheet.getPageSetup().setRightMargin(0);
            sheet.getPageSetup().setBottomMargin(0);
            sheet.getPageSetup().setTopMargin(0);

// Define ImageOrPrintOptions
            ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
// Specify the image format
            imgOptions.setImageFormat(ImageFormat.getJpeg());
            imgOptions.setCellAutoFit(true);
            imgOptions.setOnePagePerSheet(true);
            //imgOptions.setDesiredSize(1000,800);
// Render the sheet with respect to specified image/print options
            SheetRender render = new SheetRender(sheet, imgOptions);

// Render the image for the sheet
            //render.toImage(0, dataDir + "SheetImage.jpg");
            render.toImage(0, "D:\\SheetImage.jpg");
        } catch (Exception e) {
            e.printStackTrace();
        }

    }

  /**
 * @param filepath  .xls或者.xlsx文件的路径
 * @parampicpath jpg或者png图片的路径
 */
    public  static void ConvertToImage (String filepath ,String picpath){

        String dataDir = getDataDir(ConvertToImage.class);
// Create a new Workbook object
// Open a template excel file
        Workbook book = null;
        try {
            //book = new Workbook(dataDir + "2018各项目情况.xlsx");
            book = new Workbook(filepath);
            // Get the first worksheet
            //Worksheet sheet = book.getWorksheets().get(0);
            Worksheet sheet = book.getWorksheets().get(0);

// Define ImageOrPrintOptions
            ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
// Specify the image format
            imgOptions.setImageFormat(ImageFormat.getJpeg());
            imgOptions.setCellAutoFit(true);
            imgOptions.setOnePagePerSheet(true);
            imgOptions.setDefaultFont("200");
// Render the sheet with respect to specified image/print options
            SheetRender render = new SheetRender(sheet, imgOptions);

// Render the image for the sheet
            //render.toImage(0, dataDir + "SheetImage.jpg");
            render.toImage(0, picpath);
        } catch (Exception e) {
            e.printStackTrace();
        }

    }

    public static String getDataDir(Class c) {
        File dir = new File(System.getProperty("user.dir"));

        System.out.println("shake" + dir.getAbsolutePath());

        dir = new File(dir, "src");
        dir = new File(dir, "main");
        dir = new File(dir, "resources");

        for (String s : c.getName().split("\\.")) {
            dir = new File(dir, s);
        }

        if (dir.exists()) {
            System.out.println("Using data directory: " + dir.toString());
        } else {
            dir.mkdirs();
            System.out.println("Creating data directory: " + dir.toString());
        }

        return dir.toString() + File.separator;
    }

    public static void main (String[] args ){
        ConvertToImage();
    }
}

 

二 linux系统中采用aspose-cells-18.6.jar包生成图片中文乱码

具体解决方案：参考帖子

在Windows中一切良好，中英文都能很好的展示，但是在我将程序部署到Linux中后，却出现生成的图片中中文全部乱码(显示成一个个的方框)。

1)查看服务器字体列表

[root@iZ2zez5rp1bmsZ share]# cd fc-list
bash: cd: fc-list: No such file or directory

悲哀，连字体库都没有

2)安装字体库

# 先安装fontconfig，用fontconfig来安装字体库
[root@iZ2zebjvdi1bmsZ share]# yum -y install fontconfig
Loaded plugins: fastestmirror
...
Installed:
  fontconfig.x86_64 0:2.10.95-10.el7

Dependency Installed:
  fontpackages-filesystem.noarch 0:1.44-8.el7 Complete! 

fontconfig安装成功后在/usr/share目录中就会看到fonts和fontconfig两个目录（没装fontconfig之前是没有这两个目录的）

接下来就可以添加字体库了

3)添加字体

添加字体之前需要先下载相应的字体文件，博主用的是simsun.ttf（宋体）字体库，可以直接点击下载：下载simsun.zip

当然也可以去windows系统下的C:/windows/fonts目录下寻找合适的字体

字体文件准备好后，下边就正式开发操作

首先在/usr/share/fonts/目录下创建目录（名称随意）

mkdir chinese

然后将上方提供的

zip包中的两个文件全部解压并放到新建的目录（chinese）中，

然后修改chinese目录的权限

chmod -R 755 /usr/share/fonts/chinese

接下来需要安装ttmkfdir，这个命令的作用是搜索目录中所有的字体信息，汇总生成fonts.scale文件。

[root@iZ2zebjvditp1bmsZ fonts]# yum -y install ttmkfdir
Loaded plugins: fastestmirror
...
Installed:
  ttmkfdir.x86_64 0:3.0.9-42.el7

Complete!

然后执行ttmkfdir命令：

[root@iZ2zz5rp1bmsZ fonts]# ttmkfdir -e /usr/share/X11/fonts/encodings/encodings.dir

最后修改字体配置文件

vi /etc/fonts/fonts.conf

如下添加配置

<dir>/usr/share/fonts/chinese</dir>

最后保存文件并执行fc-cache进行刷新字体缓存

OK，到此字体就安装完成，在看一下字体列表：

[root@iZ2zebrp1bmsZ fonts]# fc-list
/usr/share/fonts/chinese/simsun.ttc: SimSun\-PUA,宋体\-PUA:style=Regular
/usr/share/fonts/chinese/simsun.ttc: NSimSun,新宋体:style=Regular
/usr/share/fonts/chinese/simsun.ttf: SimSun,宋体:style=Regular
/usr/share/fonts/chinese/simsun.ttc: SimSun,宋体:style=Regular

4)重新测试生成文件