JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
spread.options.tabStripVisible = true;
const warehouses = [
{ name: '인천창고', color: '#1565C0' },
{ name: '부산창고', color: '#2E7D32' },
{ name: '대구창고', color: '#E65100' },
];
const headers = ['SKU', '품목명', '단위', '현재고', '안전재고', '입고예정'];
warehouses.forEach((wh, idx) => {
let sheet;
if (idx === 0) {
sheet = spread.getActiveSheet();
sheet.name(wh.name);
} else {
sheet = new GC.Spread.Sheets.Worksheet(wh.name);
spread.addSheet(idx, sheet);
}
spread.suspendPaint();
sheet.options.sheetTabColor = wh.color;
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor(wh.color).foreColor('#ffffff').font('bold 12px sans-serif');
sheet.setColumnWidth(c, c === 1 ? 140 : 90);
});
sheet.setRowHeight(0, 36);
const skuData = [
['SKU-001', '리튬배터리팩', 'EA', 320, 100, 200],
['SKU-002', '전원어댑터', 'EA', 45, 80, 150],
['SKU-003', '방열패드', 'SET', 88, 50, 0],
['SKU-004', 'USB-C 케이블', 'M', 560, 200, 300],
['SKU-005', '보호필름', 'EA', 12, 100, 500],
['SKU-006', '충전거치대', 'EA', 210, 80, 0],
['SKU-007', '전선결속대', 'BOX', 34, 30, 100],
['SKU-008', '냉각팬 모듈', 'EA', 76, 50, 80],
];
skuData.forEach((row, r) => {
row.forEach((val, c) => sheet.setValue(r + 1, c, val));
const stock = row[3], safety = row[4];
const bg = stock < safety ? '#FFEBEE' : stock < safety * 1.5 ? '#FFF8E1' : '#E8F5E9';
for (let c = 0; c < 6; c++) sheet.getCell(r + 1, c).backColor(bg);
});
spread.resumePaint();
});
spread.setActiveSheetIndex(0);