Load Json Data Or Excel Data

[Ponvijaykumar]

How to load existing excel date or json data

[myliang]

new Spreadsheet("#x-spreadsheet-demo")
  .loadData({}) // load data (json data)
  .change(data => {
    // save data to db
  });

[Ponvijaykumar]

Possible to load existing cvs or excel file.

[dodumosu]

use a library to read in the CSV or Excel data.
Some suggestions:

• PapaParse (CSV only)
• Exceljs
• SheetJS Community Edition

[wangzhedong]

加载存在数据库里的数据，你把数据转成demo中的数据格式不就可以了嘛

[Leannechn]

加载存在数据库里的数据，你把数据转成demo中的数据格式不就可以了嘛

demo中的数据格式 中的 demo 在哪里

[SheetJSDev]

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]

Hello how can I add a custom button to the toolbar to import/export an excel file with
https://github.com/SheetJS/sheetjs