Path to json2excel libraries

Tessioner · March 3, 2023, 11:37am

We are exporting spreadsheets to Excel and need to load json2excel library locally. Path for worker.js can be set with exportModulePath option but library also needs lib.wasm. Path for it could be set with wasmPath option of postMessage function. That would require modification of Spreadsheet source code so can you add option to Spreadsheet object to set path also for lib.wasm?

sematik · April 6, 2023, 1:06pm

The compiled xlsx_import_bg.wasm is included in the json2excel package:

and can be defined in the worker.js:

github.com

DHTMLX/json2excel/blob/master/js/worker.js#L25


      
                  const blob = new Blob([result], {
                      type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,"
                  });
          
          
        postMessage({
                      uid: config.uid || (new Date()).valueOf(),
                      type: "ready",
                      blob
                  });
              } else {
                  const path = config.wasmPath || "https://cdn.dhtmlx.com/libs/json2excel/1.0/lib.wasm";
          
          
        wasm_bindgen(path).then(() => {
                      import_to_xlsx = wasm_bindgen.import_to_xlsx;
                      doConvert(config);
                  }).catch(e => console.log(e));
              }
          }

or in the compiled index.js file.

We’ll try to extend the possibility to define the wasmPath in the spreadsheet export config in the future updates.
I’ll inform you about the progress on this issue.