const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
const headers = ['SKU', '품목명', 'D-6', 'D-5', 'D-4', 'D-3', 'D-2', '어제', '오늘', '7일 출고 추이'];
headers.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#1565C0').foreColor('#ffffff').font('bold 11px sans-serif');
sheet.setColumnWidth(c, c === 0 ? 60 : c === 1 ? 110 : c === 9 ? 130 : 39);
});
sheet.setRowHeight(0, 34);
// 품목별 7일 출고 수량 데이터 (D-6 ~ 오늘)
const items = [
['SKU-001', '리튬배터리팩', 42, 38, 55, 61, 48, 70, 65],
['SKU-002', '전원어댑터', 28, 32, 29, 35, 18, 40, 44],
['SKU-003', '방열패드', 15, 12, 18, 22, 10, 8, 5],
['SKU-004', 'USB-C 케이블', 90, 85, 92,110, 88, 95,120],
['SKU-005', '보호필름', 5, 8, 12, 6, 4, 15, 20],
];
const SparklineType = GC.Spread.Sheets.Sparklines.SparklineType;
const DataOrientation = GC.Spread.Sheets.Sparklines.DataOrientation;
items.forEach((row, r) => {
row.forEach((val, c) => sheet.setValue(r + 1, c, val));
sheet.setRowHeight(r + 1, 48);
// 해당 행의 D-6~오늘 열(인덱스 2~8, 7열)을 수평 참조
const dataRange = new GC.Spread.Sheets.Range(r + 1, 2, 1, 7);
const setting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
setting.options.showMarkers = true;
setting.options.lineWeight = 2;
setting.options.seriesColor = '#1565C0';
setting.options.markersColor = '#E65100';
setting.options.showHigh = true;
setting.options.highMarkerColor = '#2E7D32';
setting.options.showLow = true;
setting.options.lowMarkerColor = '#C62828';
sheet.setSparkline(r + 1, 9, dataRange, DataOrientation.horizontal, SparklineType.line, setting);
});