本帖最后由 雨中过客 于 2021-11-22 19:19 编辑
window.onload = function () {
// host the workbook control in a DIV element with id "ss"
var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), {
sheetCount: 1
});
/*
* retrieve the spread workbook object from the host element using findControl static method.
* var spread = GC.Spread.Sheets.findControl(document.getElementById('ss'));
*/
initSpread(spread);
};
function initSpread(spread) {
const { SheetArea } = GC.Spread.Sheets;
var sheet = spread.getActiveSheet();
sheet.setRowCount(2, SheetArea.colHeader);
sheet.addSpan(0, 0, 2, 1, SheetArea.colHeader);
sheet.setValue(0, 0, 'df', SheetArea.colHeader);
sheet.addSpan(0, 1, 2, 1, SheetArea.colHeader);
sheet.setValue(0, 1, 'df', SheetArea.colHeader);
sheet.addSpan(0, 2, 1, 2, SheetArea.colHeader);
sheet.setValue(0, 2, 'f', SheetArea.colHeader);
sheet.setValue(1, 2, 'df', SheetArea.colHeader);
sheet.setValue(1, 3, 'df', SheetArea.colHeader);
sheet.addSpan(0, 4, 2, 1, SheetArea.colHeader);
sheet.setValue(0, 4, 'df', SheetArea.colHeader);
sheet.addSpan(0, 5, 2, 1, SheetArea.colHeader);
sheet.setValue(0, 5, 'df', SheetArea.colHeader);
sheet.addSpan(0, 6, 2, 1, SheetArea.colHeader);
sheet.setValue(0, 6, 'df', SheetArea.colHeader);
sheet.addSpan(0, 7, 2, 1, SheetArea.colHeader);
sheet.setValue(0, 7, 'df', SheetArea.colHeader);
sheet.addSpan(0, 8, 2, 1, SheetArea.colHeader);
sheet.setValue(0, 8, 'df', SheetArea.colHeader);
sheet.addSpan(0, 9, 1, 15, SheetArea.colHeader);
sheet.setValue(0, 9, '合并', SheetArea.colHeader);
sheet.setValue(1, 9, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 10, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 11, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 12, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 13, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 14, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 15, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 16, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 17, 'FGE', SheetArea.colHeader);
sheet.setValue(1, 18, 'FGE11', SheetArea.colHeader);
sheet.setValue(1, 19, 'FGE22', SheetArea.colHeader);
sheet.setValue(1, 20, 'FGE33', SheetArea.colHeader);
sheet.setValue(1, 21, 'FGE44', SheetArea.colHeader);
sheet.setColumnCount(30, SheetArea.colHeader);
}
超过20列,头设置value无效,从FGE33从没有了
|