| 
| 
本文将介绍通过使用spire.xls for java 将excel工作簿按分页符转换为svg。
import com.spire.xls.*;
import java.io.fileoutputstream;
import java.util.list;
import java.util.map;
public class exceltosvg {
public static void main(string[] args) throws exception {
//加载示例文档
workbook workbook = new workbook();
workbook.loadfromfile("sample.xlsx");
int count = 1;
//获取分页信息
list> pageinfolist = workbook.getsplitpageinfo();
for (int i = 0; i < workbook.getworksheets().getcount(); i ) {
fileoutputstream stream;
worksheet sheet = workbook.getworksheets().get(i);
map integerpagecolrowmap = pageinfolist.get(i);
for (map.entry entry : integerpagecolrowmap.entryset()) {
pagecolrow colrow = entry.getvalue();
stream=new fileoutputstream("output/out" (count ) ".svg");
//保存至svg
sheet.tosvgstream(stream, colrow.startrow, colrow.startcol, colrow.endrow, colrow.endcol);
stream.flush();
stream.close();
}
}
}
} 效果图：
