JavaScript
<!-- index.html -->
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<script src="https://cdn.mescius.io/spreadjs/19.0.6/gc.spread.sheets.all.19.0.6.min.js"></script>
<script src="https://cdn.mescius.io/spreadjs/19.0.6/plugins/gc.spread.sheets.shapes.19.0.6.min.js"></script>
<script src="https://cdn.mescius.io/spreadjs/19.0.6/plugins/gc.spread.sheets.charts.19.0.6.min.js"></script>
<link rel="stylesheet" href="https://cdn.mescius.io/spreadjs/19.0.6/css/gc.spread.sheets.excel2013white.19.0.6.css">
<style>
#spreadContainer { width: 100%; height: 600px; }
</style>
</head>
<body>
<div id="spreadContainer"></div>
<script>
document.addEventListener('DOMContentLoaded', () => {
const spread = new GC.Spread.Sheets.Workbook(
document.getElementById('spreadContainer')
);
const sheet = spread.getActiveSheet();
// 샘플 데이터 입력
sheet.setValue(0, 0, 'Category'); sheet.setValue(0, 1, 'Q1'); sheet.setValue(0, 2, 'Q2'); sheet.setValue(0, 3, 'Q3');
sheet.setValue(1, 0, 'Product A'); sheet.setValue(1, 1, 10); sheet.setValue(1, 2, 20); sheet.setValue(1, 3, 30);
sheet.setValue(2, 0, 'Product B'); sheet.setValue(2, 1, 15); sheet.setValue(2, 2, 25); sheet.setValue(2, 3, 35);
sheet.setValue(3, 0, 'Product C'); sheet.setValue(3, 1, 5); sheet.setValue(3, 2, 12); sheet.setValue(3, 3, 18);
const chart = sheet.charts.add(
'Chart1',
GC.Spread.Sheets.Charts.ChartType.columnClustered,
250, // x
20, // y
600, // width
400, // height
'A1:D4', // dataRange (문자열 수식)
GC.Spread.Sheets.Charts.RowCol.rows // dataOrientation
);
});
</script>
</body>
</html>