const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'));
const sheet = spread.getActiveSheet();
spread.options.tabStripVisible = false;
const cols = ['환자', '3/19', '3/20', '3/21', '3/22', '3/23', '3/24', '3/25', '7일 추이'];
cols.forEach((h, c) => {
sheet.setValue(0, c, h);
sheet.getCell(0, c).backColor('#37474F').foreColor('#fff').font('bold 11px sans-serif');
sheet.setColumnWidth(c, c === 0 ? 120 : c === 8 ? 130 : 58);
});
sheet.setRowHeight(0, 32);
// 혈당 데이터 (mg/dL)
const glucoseRow = ['혈당 (mg/dL)', 182, 175, 168, 190, 155, 162, 148];
glucoseRow.forEach((v, c) => sheet.setValue(1, c, v));
sheet.getCell(1, 0).backColor('#E3F2FD').font('11px sans-serif');
// 수축기 혈압 데이터 (mmHg)
const bpRow = ['혈압 수축기 (mmHg)', 148, 142, 150, 138, 135, 140, 132];
bpRow.forEach((v, c) => sheet.setValue(2, c, v));
sheet.getCell(2, 0).backColor('#F3E5F5').font('11px sans-serif');
[1, 2].forEach(r => sheet.setRowHeight(r, 52));
// 혈당 Line 스파크라인
const gSetting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
gSetting.options.showMarkers = true;
gSetting.options.lineWeight = 2;
gSetting.options.showHigh = true;
gSetting.options.showLow = true;
gSetting.options.seriesColor = '#1565C0';
gSetting.options.highMarkerColor = '#C62828';
gSetting.options.lowMarkerColor = '#2E7D32';
sheet.setSparkline(
1, 8,
new GC.Spread.Sheets.Range(1, 1, 1, 7),
GC.Spread.Sheets.Sparklines.DataOrientation.horizontal,
GC.Spread.Sheets.Sparklines.SparklineType.line,
gSetting
);
// 혈압 Line 스파크라인
const bSetting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
bSetting.options.showMarkers = true;
bSetting.options.lineWeight = 2;
bSetting.options.seriesColor = '#7B1FA2';
bSetting.options.highMarkerColor = '#C62828';
bSetting.options.lowMarkerColor = '#1565C0';
sheet.setSparkline(
2, 8,
new GC.Spread.Sheets.Range(2, 1, 1, 7),
GC.Spread.Sheets.Sparklines.DataOrientation.horizontal,
GC.Spread.Sheets.Sparklines.SparklineType.line,
bSetting
);