java excel转为svg

   我这里的需求是，使用excel将系统统计结果导出，设置样式、格式后，转换为矢量图svg。使用到 Free-Spire-XLS 。

一、引入maven依赖：

<dependencies> 
   <dependency>
       <groupId>e-iceblue</groupId>
       <artifactId>spire.xls.free</artifactId>
       <version>2.2.0</version>
   </dependency>
</dependencies>
<repositories>
    <repository>
         <id>com.e-iceblue</id>
         <name>e-iceblue</name>
         <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>

二、转换工具类

import com.spire.xls.Worksheet;
import org.apache.poi.ss.usermodel.Workbook;
import sun.misc.BASE64Encoder;

import javax.imageio.ImageIO;
import javax.imageio.stream.ImageInputStream;
import javax.servlet.http.HttpServletResponse;
import java.awt.image.BufferedImage;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;


/**
 * Excel转换处理工具类：转为图片、svg文件等
 *
 * @author yangfeng
 * @date 2019-12-26
 */
public class ExcelTransformUtil {

    /**
     * workbook 转为输入流
     *
     * @param workbook
     * @return
     * @throws Exception
     */
    public static InputStream convert2Stream(Workbook workbook) throws Exception {
        ByteArrayOutputStream bos = new ByteArrayOutputStream();
        workbook.write(bos);
        byte[] barray = bos.toByteArray();
        return new ByteArrayInputStream(barray);
    }

    /**
     * excel 转为图片
     *
     * @param inputStream
     */
    public static void excel2Img(InputStream inputStream) {
        com.spire.xls.Workbook book;
        try {
            book = new com.spire.xls.Workbook();
            book.loadFromStream(inputStream);
            Worksheet sheet = book.getWorksheets().get(0);
            sheet.saveToImage("d://toImg.png");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * excel 转为SVG
     *
     * @param inputStream
     */
    public static void excel2SVG(InputStream inputStream, HttpServletResponse response) {
        com.spire.xls.Workbook book;
        try {
            book = new com.spire.xls.Workbook();
            book.loadFromStream(inputStream);
            Worksheet sheet = book.getWorksheets().get(0);
            sheet.toSVGStream(response.getOutputStream(), sheet.getFirstRow(), sheet.getFirstColumn(),
                    sheet.getLastRow(), sheet.getLastColumn());
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

三、生成svg服务

 public void generateSVG(ReportRequest request, HttpServletResponse response) throws Exception {
        ServiceResult<List<OperationReportVO>> result = getOperationReport(request);
        if (result != null && result.isSucceed() && !CollectionUtils.isEmpty(result.getData())) {
            //转为map
            List<Map<String, Object>> list = MapBeanUtil.objectsToMaps(result.getData());
            Workbook workbook = ReportExportUtil.generateExcelReport("运行情况统计表",
                    getDateAndWeek(request.getPlanDate()), list, OperationReportVO.class);
            ExcelTransformUtil.excel2SVG(ExcelTransformUtil.convert2Stream(workbook), response);
        }
    }

    此处的Workbook引自包：org.apache.poi.ss.usermodel.Workbook 。生成excel的workbook。然后将workbook转为输入流，com.spire.xls.Workbook读取输入流，转成svg。