report-master.zip

package com.anjiplus.template.gaea.business.modules.reportexcel.util; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import org.junit.Test; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.util.LinkedList; import java.util.List; /** * Created by raodeming on 2021/8/30. */ public class XlsSheetUtilTest { @Test public void test1(){ String str="[{\"row\":199,\"name\":\"Sheet1\",\"chart\":[],\"color\":\"\",\"index\":\"1\",\"order\":0,\"column\":70,\"config\":{\"merge\":{},\"rowlen\":{\"118\":19},\"colhidden\":{},\"columnlen\":{},\"customHeight\":{\"3\":1}},\"images\":{},\"status\":1,\"ch_width\":4748,\"rowsplit\":[],\"calcChain\":[],\"hyperlink\":{},\"rh_height\":1790,\"scrollTop\":0,\"scrollLeft\":0,\"visibledatarow\":[],\"dataVerification\":{},\"visibledatacolumn\":[],\"jfgird_select_save\":[{\"row\":[3,3],\"top\":60,\"left\":222,\"width\":73,\"column\":[3,3],\"height\":19,\"top_move\":60,\"left_move\":222,\"row_focus\":3,\"width_move\":73,\"height_move\":19,\"column_focus\":3}],\"jfgrid_selection_range\":{},\"luckysheet_alternateformat_save\":[],\"luckysheet_conditionformat_save\":[],\"id\":4852,\"block_id\":\"fblock\",\"list_id\":\"xc79500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3\",\"celldata\":[{\"c\":2,\"r\":2,\"v\":{\"m\":\"3\",\"v\":3,\"ct\":{\"t\":\"n\",\"fa\":\"General\"}}},{\"c\":1,\"r\":1,\"v\":{\"m\":\"2\",\"v\":2,\"ct\":{\"t\":\"n\",\"fa\":\"General\"}}},{\"c\":0,\"r\":0,\"v\":{\"m\":\"1\",\"v\":1,\"ct\":{\"t\":\"n\",\"fa\":\"General\"}}},{\"c\":2,\"r\":101,\"v\":{\"m\":\"1111\",\"v\":1111,\"ct\":{\"t\":\"n\",\"fa\":\"General\"}}}]},{\"row\":84,\"name\":\"Sheet2\",\"chart\":[],\"color\":\"\",\"index\":\"2\",\"order\":1,\"column\":60,\"config\":{},\"status\":0,\"ch_width\":4748,\"rowsplit\":[],\"rh_height\":1790,\"scrollTop\":0,\"scrollLeft\":0,\"visibledatarow\":[],\"visibledatacolumn\":[],\"jfgird_select_save\":[{\"row\":[1,1],\"top\":20,\"left\":74,\"width\":73,\"column\":[1,1],\"height\":19,\"top_move\":20,\"left_move\":74,\"row_focus\":1,\"width_move\":73,\"height_move\":19,\"column_focus\":1}],\"jfgrid_selection_range\":{},\"id\":4712,\"block_id\":\"fblock\",\"list_id\":\"xc79500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3\",\"celldata\":[{\"c\":1,\"r\":3,\"v\":{\"m\":\"qwe\",\"v\":\"qwe\",\"ct\":{\"t\":\"g\",\"fa\":\"General\"}}},{\"c\":1,\"r\":1,\"v\":{\"m\":\"qwe\",\"v\":\"qwe\",\"ct\":{\"t\":\"g\",\"fa\":\"General\"}}}]},{\"row\":84,\"name\":\"Sheet3\",\"chart\":[],\"color\":\"\",\"index\":\"3\",\"order\":2,\"column\":60,\"config\":{},\"status\":0,\"ch_width\":4748,\"rowsplit\":[],\"rh_height\":1790,\"scrollTop\":0,\"scrollLeft\":0,\"visibledatarow\":[],\"visibledatacolumn\":[],\"jfgird_select_save\":[{\"row\":[13,13],\"top\":260,\"left\":296,\"width\":73,\"column\":[4,4],\"height\":19,\"top_move\":260,\"left_move\":296,\"row_focus\":13,\"width_move\":73,\"height_move\":19,\"column_focus\":4}],\"jfgrid_selection_range\":{},\"id\":4713,\"block_id\":\"fblock\",\"list_id\":\"xc79500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3\",\"celldata\":[{\"c\":5,\"r\":2,\"v\":{\"m\":\"请问王企鹅全文\",\"v\":\"请问王企鹅全文\",\"bl\":1,\"ct\":{\"t\":\"g\",\"fa\":\"General\"}}},{\"c\":2,\"r\":8,\"v\":{\"m\":\"请问请问\",\"v\":\"请问请问\",\"ct\":{\"t\":\"g\",\"fa\":\"General\"},\"it\":1}}]}]"; str = "[{\"index\":\"Sheet_MeHeksAaWCLh_1630550132889\",\"status\":1,\"jfgird_select_save\":[],\"luckysheet_select_save\":[{\"left\":518,\"width\":73,\"top\":320,\"height\":19,\"left_move\":518,\"width_move\":73,\"top_move\":320,\"height_move\":19,\"row\":[16,16],\"column\":[7,7],\"row_focus\":16,\"column_focus\":7}],\"data\":[[{\"mc\":{\"r\":0,\"c\":0,\"rs\":2,\"cs\":2}},{\"mc\":{\"r\":0,\"c\":0}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[{\"mc\":{\"r\":0,\"c\":0}},{\"mc\":{\"r\":0,\"c\":0}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,{\"m\":\"哈哈\",\"ct\":{\"fa\":\"General\",\"t\":\"g\"},\"v\":\"哈哈\"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,{\"m\":\"哈哈\",\"ct\":{\"fa\":\"General\",\"t\":\"g\"},\"v\":\"哈哈\",\"ht\":\"0\"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,{\"m\":\"哈哈\",\"ct\":{\"fa\":\"General\",\"t\":\"g\"},\"v\":\"哈哈\",\"ht\":\"0\"},null,{\"m\":\"请求\",\"ct\":{\"fa\":\"General\",\"t\":\"g\"},\"v\":\"请求\"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,{\"m\":\"哈哈\",\"ct\":{\"fa\":\"General\",\"t\":\"g\"},\"v\":\"哈哈\",\"ht\":\"0\"},{\"v\":\"333\",\"ct\":{\"fa\":\"General\",\"t\":\"n\"},\"m\":\"333\"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,{\"m\":\"哈哈\",\"ct\":{\"fa\":\"General\",\"t\":\"g\"},\"v\":\"哈哈\"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,{\"m\":\"哈哈\",\"ct\":{\"fa\":\"General\",\"t\":\"g\"},\"v\":\"哈哈\",\"bl\":1,\"ht\":\"2\"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,