使用spreadjs做的样式
获取json后使用gcexcel转成excel样式不对,gcexcel是2.1.3的版本
json内容:
{"version":"14.2.2","allowUserDragDrop":false,"tabStripVisible":false,"allowExtendPasteRange":true,"copyPasteHeaderOptions":0,"customList":[],"sheets":{"5":{"name":"5","isSelected":true,"rowCount":10,"columnCount":10,"activeRow":4,"zoomFactor":0.9,"frozenTrailingRowStickToEdge":true,"frozenTrailingColumnStickToEdge":true,"theme":"Office","data":{"dataTable":{"0":{"0":{"style":{"font":"normal normal normal 12px Calibri"}}}},"rowDataArray":[null,null,null,null,{"style":{"backColor":"#ffbb6d"}}],"defaultDataNode":{"style":{"font":"12px 宋体","themeFont":"Body","locked":false}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"leftCellIndex":0,"topCellIndex":0,"selections":{"0":{"row":4,"rowCount":1,"col":-1,"colCount":10},"length":1},"defaults":{"colHeaderRowHeight":20,"colWidth":62,"rowHeaderColWidth":40,"rowHeight":"14","_isExcelDefaultColumnWidth":false},"rowOutlines":{"items":[]},"columnOutlines":{"items":[]},"cellStates":{},"states":{},"outlineColumnOptions":{},"autoMergeRangeInfos":[],"printInfo":{"paperSize":{"width":850,"height":1100,"kind":1}},"allowCellOverflow":false,"index":0}}}
|