Load Json Data Or Excel Data
Ponvijaykumar opened this issue · 8 comments
Ponvijaykumar commented
How to load existing excel date or json data
myliang commented
new Spreadsheet("#x-spreadsheet-demo")
.loadData({}) // load data (json data)
.change(data => {
// save data to db
});
Ponvijaykumar commented
Possible to load existing cvs or excel file.
dodumosu commented
use a library to read in the CSV or Excel data.
Some suggestions:
wangzhedong commented
加载存在数据库里的数据,你把数据转成demo中的数据格式不就可以了嘛
Leannechn commented
加载存在数据库里的数据,你把数据转成demo中的数据格式不就可以了嘛
demo中的数据格式 中的 demo 在哪里
SheetJSDev commented
https://docs.sheetjs.com/docs/demos/grid#x-spreadsheet discusses in more detail
Hosted script https://cdn.sheetjs.com/xspreadsheet/xlsxspread.min.js
Script exposes a function stox
. Usage:
// var grid = x_spreadsheet(...);
var wb = XLSX.read(ab);
var new_data = stox(wb); // generate x-spreadsheet data
grid.loadData(new_data); // load data into x-spreadsheet
The SheetJS documentation includes examples for how to get the ab
data. For example, data can be downloaded using fetch:
// const grid = x_spreadsheet(...);
(async() => {
const url = "https://sheetjs.com/pres.numbers";
const ab = await (await fetch(url)).arrayBuffer();
grid.loadData(stox(XLSX.read(ab)));
})();
nbao commented
Hello how can I add a custom button to the toolbar to import/export an excel file with
https://github.com/SheetJS/sheetjs