将excel转为图片

最新推荐文章于 2024-08-29 10:15:06 发布

前方太黑暗

最新推荐文章于 2024-08-29 10:15:06 发布

阅读量594

点赞数 1

分类专栏： poi 文章标签： excel转为图片

本文链接：https://blog.csdn.net/xcc_2269861428/article/details/98871050

版权

poi 专栏收录该内容

23 篇文章 3 订阅

订阅专栏

pom引入

<!-- poi 绘制图片 -->
    <dependency>
	    <groupId>org.jfree</groupId>
	    <artifactId>jcommon</artifactId>
	    <version>1.0.21</version>
	</dependency>
	<dependency>
	    <groupId>org.jfree</groupId>
	    <artifactId>jfreechart</artifactId>
	    <version>1.0.17</version>
	</dependency>
	<dependency>
	    <groupId>jfree</groupId>
	    <artifactId>jfreechart-experimental</artifactId>
	    <version>1.0.9</version>
	</dependency>

excel内容

代码

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;

public class TestImage {
    
	public static void ConvertToImage (String filepath ,String picpath){

        Workbook book = null;
        try {
            book = new Workbook(filepath);
            Worksheet sheet = book.getWorksheets().get(0);

            ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
            imgOptions.setImageFormat(ImageFormat.getJpeg());
            imgOptions.setCellAutoFit(false);
            imgOptions.setOnePagePerSheet(true);
            SheetRender render = new SheetRender(sheet, imgOptions);
            render.toImage(0, picpath);
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
	
	public static void main(String[] args) {
		String filepath = "E:/pic_test/text.xlsx";
		String picpath = "E:/pic_test/1.png"; // jpg
		TestImage.ConvertToImage(filepath, picpath);
	}
}