기타 export 문의 드립니다.
페이지 정보
작성자 네임스 작성일 2023-11-02 00:25 조회 119회 댓글 0건본문
관련링크
하단에는 소스가 있습니다.
saveAs(blob, fileName); <= Incorrect file format.
오류가 발생 합니다.
답변 부탁 드립니다.
-------------------------------------
<!DOCTYPE html>
<html>
<head>
<title>SpreadJS Export Example</title>
<link rel="styleSheet" href="../../App_Themes/JavaScript/SpreadJS/css/gc.spread.sheets.16.1.3.css"/>
<script src="../../App_Themes/JavaScript/SpreadJS/scripts/gc.spread.sheets.all.16.1.3.min.js"></script>
<script src="../../App_Themes/JavaScript/SpreadJS/scripts/plugins/gc.spread.sheets.io.16.1.3.min.js"></script>
<script src="../../App_Themes/JavaScript/SpreadJS/scripts/interop/gc.spread.excelio.16.1.3.min.js"></script>
<script src="../../App_Themes/JavaScript/SpreadJS/scripts/resources/ko/gc.spread.sheets.resources.ko.16.1.3.min.js"></script>
</head>
<body>
<div id="spreadjs" style="width: 400%; height: 400px;"></div>
<button id="exportButton">Export to XLSX</button>
<script>
var spread ;
var activeSheet;
var excelIo;
// Initialize the SpreadJS component
GC.Spread.Sheets.LicenseKey = "10.200.24.167,E276248484542413#B1gNMO9k7ZCh5bTB5KJh4LVp5cHlzQaVjbBRkbCJXW7NTUF54RjNzRyJEU6gGNY54dONjVnNnQ5FDRzZmVmxEcll4VaVDRXNmQCZVWHJ6NopFUvQjcwczQykHNzZnRDRzKkhUZ9l4cYJWMJtWMkxke8cXUwFnNvpHULZ7coJ4Svp4dN9EaEBjdjVDUnJUTyQ7U6g6cyYle5ATQPJTY8UFT6RjU72Eczw4LL5mMT5WZLFDe9FDeWd4YVBVQZZmSpFmVrwEN8MET9A5UV5mcLJmc6IUUlZUUwkGRyonb4gHV4cVSEhEc0dFSvdmMYBTeYVGWZtSNHB7VTNDbRZkZwE7L5YGd7xkI0IyUiwiIxMkRwUENDRjI0ICSiwCMyAjM4UzN5AjM0IicfJye#4Xfd5nIXR5QaJiOiMkIsIiNx8idgMlSgQWYlJHcTJiOi8kI1tlOiQmcQJCLiUDMzQzNwASMzATMzIDMyIiOiQncDJCLiAzMxEzMyAjMiojIwhXRiwiI7YTMuQjMuADMy8CMxIiOiMXbEJCLigritTIltzohsjKlsHqhtLiOiEmTDJCLlVnc4pjIsZXRiwiIzEDNyQTN4gDN8QjM6cjMiojIklkIs4XXiUGbiFGV43mdpBlIbpjInxmZiwSZzxWYmpjIyNHZisnOiwmbBJye0ICRiwiI34zZR5UcoZkdWRTWj3WWkdWajpUbzVjNmtUNQplYjF7LnhnSsZHW9hDRT3yRNVEbVB7VnlENWBTUB3CT5JTZEZ4UsZXZW9ETtBnd9YEaBpUMuFuQ";
spread = new GC.Spread.Sheets.Workbook(document.getElementById("spreadjs"));
activeSheet = spread.getActiveSheet();
// Populate the spreadsheet with some sample data
activeSheet.setValue(0, 0, "Name");
activeSheet.setValue(0, 1, "Age");
activeSheet.setValue(1, 0, "John");
activeSheet.setValue(1, 1, 30);
activeSheet.setValue(2, 0, "Alice");
activeSheet.setValue(2, 1, 25);
// Create a function to export the spreadsheet data to XLSX
function exportToXLSX() {
excelIo = new GC.Spread.Excel.IO();
var fileName = 'xxx.xlsx';
var json = JSON.stringify(spread.toJSON());
excelIo.save(json, function (blob) {
saveAs(blob, fileName);
}, function (e) {
console.log(e);
});
}
// Add a click event handler to the export button
document.getElementById("exportButton").addEventListener("click", exportToXLSX);
</script>
</body>
</html>
댓글목록
등록된 댓글이 없습니다.