[]
以下表格描述了 GcExcel 支持的 SpreadJS 功能,包括其 API、JSON 输入/输出、.sjs 输入/输出以及 PDF 导出功能。
Scope | SpreadJS Features | .sjs I/O | JSON I/O | GcExcel API | PDF Export |
---|---|---|---|---|---|
Workbook | allowAutoCreateHyperlink | Yes | Yes | No | N/A |
allowAutoExtendFilterRange | Yes | Yes | No | N/A | |
allowContextMenu | Yes | Yes | No | N/A | |
allowCopyPasteExcelStyle | Yes | Yes | No | N/A | |
allowDynamicArray | Yes | Yes | No | N/A | |
allowExtendPasteRange | Yes | Yes | No | N/A | |
allowInvalidFormula | Yes | Yes | No | N/A | |
allowSheetReorder | Yes | Yes | Yes | N/A | |
allowUndo | Yes | Yes | No | N/A | |
allowUserDeselect | Yes | Yes | No | N/A | |
allowUserDragDrop | Yes | Yes | No | N/A | |
allowUserDragFill | Yes | Yes | No | N/A | |
allowUserDragMerge | Yes | Yes | No | N/A | |
allowUserEditFormula | Yes | Yes | No | N/A | |
allowUserResize | Yes | Yes | No | N/A | |
allowUserZoom | Yes | Yes | No | N/A | |
allSheetsListVisible | Yes | Yes | No | N/A | |
autoFitType | Yes | Yes | No | N/A | |
backColor | Yes | Yes | Yes | Yes | |
backgroundImage | Yes | Yes | Yes | Yes | |
backgroundImageLayout | Yes | Yes | Yes | Yes | |
calcOnDemand | Yes | Yes | No | N/A | |
calculationMaximumChange | Yes | Yes | Yes | N/A | |
columnResizeMode | Yes | Yes | No | N/A | |
copyPasteHeaderOptions | Yes | Yes | No | N/A | |
customList | Yes | Yes | No | N/A | |
cutCopyIndicatorBorderColor | Yes | Yes | No | N/A | |
cutCopyIndicatorVisible | Yes | Yes | No | N/A | |
dataManager | Yes | Yes | No | N/A | |
defaultDragFillType | Yes | Yes | No | N/A | |
dynamicReferences | Yes | Yes | No | N/A | |
enableFormulaTextbox | Yes | Yes | No | N/A | |
externalReference | Yes | Yes | Yes | N/A | |
grayAreaBackColor | Yes | Yes | Yes | N/A | |
hideSelection | Yes | Yes | No | N/A | |
highlightInvalidData | Yes | Yes | No | Yes | |
iterativeCalculation | Yes | Yes | Yes | N/A | |
iterativeCalculationMaximumIterations | Yes | Yes | Yes | N/A | |
newTabVisible | Yes | Yes | Yes | N/A | |
numbersFitMode | Yes | Yes | Yes | Yes | |
pasteSkipInvisibleRange | Yes | Yes | No | N/A | |
referenceStyle | No | No | No | N/A | |
resizeZeroIndicator | Yes | Yes | No | N/A | |
rowResizeMode | Yes | Yes | No | N/A | |
saveChangesForSheet | Yes | Yes | No | N/A | |
scrollbarAppearance | Yes | Yes | No | N/A | |
scrollbarMaxAlign | Yes | Yes | No | N/A | |
scrollbarShowMax | Yes | Yes | No | N/A | |
scrollByPixel | Yes | Yes | No | N/A | |
scrollIgnoreHidden | Yes | Yes | No | N/A | |
scrollPixel | Yes | Yes | No | N/A | |
showDragDropTip | Yes | Yes | No | N/A | |
showDragFillSmartTag | Yes | Yes | No | N/A | |
showDragFillTip | Yes | Yes | No | N/A | |
showHorizontalScrollbar | Yes | Yes | Yes | N/A | |
showResizeTip | Yes | Yes | No | N/A | |
showScrollTip | Yes | Yes | No | N/A | |
showVerticalScrollbar | Yes | Yes | Yes | N/A | |
tabEditable | Yes | Yes | Yes | N/A | |
tabNavigationVisible | Yes | Yes | Yes | N/A | |
tabStripPosition | Yes | Yes | Yes | N/A | |
tabStripRatio | Yes | Yes | Yes | N/A | |
tabStripVisible | Yes | Yes | Yes | N/A | |
tabStripWidth | Yes | Yes | Yes | N/A | |
useTouchLayout | Yes | Yes | No | N/A | |
incremental calculation | Yes | Yes | No | N/A | |
built-in file icons | Yes | Yes | No | N/A | |
Formula saved as r1c1 | Read-only | Read-only | No | N/A | |
Reorder rows or columns by drag-drop | Yes | Yes | No | N/A | |
autoGenerateColumns | Yes | Yes | Yes | N/A | |
Document Properties | docProps.json | Yes | Yes | Yes | N/A |
appProps.json | Yes | Yes | Yes | N/A | |
customProps.json | Yes | Yes | Yes | N/A | |
TableSheet | - | Yes | Yes | No | N/A |
GanttSheet | - | Yes | Yes | No | N/A |
ReportSheet | - | Yes | Yes | No | N/A |
Worksheet | colHeaderAutoText | Yes | Yes | No | N/A |
colHeaderData | Yes | Yes | No | N/A | |
colHeaderRowCount | Yes | Yes | No | N/A | |
columnCount | Yes | Yes | Yes | N/A | |
frozenlineColor | Yes | Yes | Yes | No | |
frozenTrailingColCount | Yes | Yes | Yes | N/A | |
frozenTrailingColumnStickToEdge | Yes | Yes | No | N/A | |
frozenTrailingRowCount | Yes | Yes | Yes | N/A | |
frozenTrailingRowStickToEdge | Yes | Yes | No | N/A | |
outlineColumnOptions | Yes | Yes | Yes | N/A | |
rowCount | Yes | Yes | Yes | N/A | |
rowHeaderAutoText | Yes | Yes | No | N/A | |
rowHeaderColCount | Yes | Yes | No | N/A | |
rowHeaderData | Yes | Yes | No | N/A | |
showColumnOutline | Yes | Yes | Yes | Yes | |
showRowOutline | Yes | Yes | Yes | Yes | |
tag | Yes | Yes | Yes | N/A | |
Attachments | Yes | Yes | No | No | |
SheetView.RightToLeft | Yes | Yes | No | No | |
autoMergeRangeInfos | Yes | Yes | No | N/A | |
Table | autoGenerateColumns | Yes | Yes | Yes | N/A |
bindingPath | Yes | Yes | Yes | N/A | |
expandBoundRows | Yes | Yes | Yes | N/A | |
Data label value of cell | Yes | Yes | No | No | |
allowAutoExpand | Yes | Yes | No | N/A | |
Cell | RowColumnStates | Yes | Yes | Yes | N/A |
tag | Yes | Yes | Yes | N/A | |
bindingPath | Yes | Yes | Yes | N/A | |
fileGUID | Yes | Yes | No | N/A | |
Rich text bullet list | Yes | Yes | No | No | |
altText | Yes | Yes | No | N/A | |
defaultValue | Yes | Yes | Yes | Yes | |
Sparkline | column | Yes | Yes | Yes | Yes |
cascade | Yes | Yes | Yes | Yes | |
columnstacked100 | Yes | Yes | Yes | Yes | |
line | Yes | Yes | Yes | Yes | |
SparklineEx | column | Yes | Yes | Yes | Yes |
cascade | Yes | Yes | Yes | Yes | |
line | Yes | Yes | Yes | Yes | |
winloss | Yes | Yes | Yes | Yes | |
Style | buttonBackColor | Yes | Yes | Yes | Yes |
hoverBackColor | Yes | Yes | No | N/A | |
watermark | Yes | Yes | Yes | Yes | |
Ellipsis | Yes | Yes | Yes | Yes | |
Cell Buttons | Yes | Yes | Yes | Yes | |
Dropdowns | Yes | Yes | Yes | Yes | |
Cell Padding | Yes | Yes | Yes | Yes | |
Label | Yes | Yes | Yes | Yes | |
Protection.Hidden | Yes | Yes | Yes | N/A | |
Table header/data/total styles | Yes | Yes | No | Partial | |
Mask | Yes | Yes | No | No | |
Cell Types | Button Cell Type | Yes | Yes | Yes | Yes |
CheckBoxCell Type | Yes | Yes | Yes | Yes | |
Check Box List Cell Type | Yes | Yes | Yes | Yes | |
Radio Button List Cell Type | Yes | Yes | Yes | Yes | |
Button List Cell Type | Yes | Yes | No | Yes | |
Range Template Cell Type | Yes | Yes | Yes | Yes | |
Combo Box Cell Type | Yes | Yes | Yes | Yes | |
File upload | Yes | Yes | No | No | |
Hyper Link Cell Type | Yes | Yes | Yes | Yes | |
Print Setting | showColumnHeader | Yes | Yes | No | No |
showRowHeader | Yes | Yes | No | No | |
Page Margins | bestFitRows | Yes | Yes | Yes | Yes |
bestFitColumns | Yes | Yes | Yes | Yes | |
showBorder | Yes | Yes | No | N/A | |
useMax | Yes | Yes | No | N/A | |
pageRange | Yes | Yes | Yes | Yes | |
qualityFactor | Yes | Yes | No | No | |
DataValidation | highlightStyle | Yes | Yes | Yes | Yes |
Shapes | allowResize | Yes | Yes | Yes | No |