Stack Overflow
Stack Overflow

Questions tagged [sheetjs]

A pure JavaScript library to read, parse, edit, and write spreadsheets, or to convert them to different formats like JSON.

You can find more information at

277 questions
0
votes
1 answer

SheetJS and FileSaver (vuejs project): running out of memory

I am working on the following problem: I want to download an .xlsx file (on click) using SheetJS to create the workbook and FileSaver to save the file. The problem I encounter is, that when exceeding about 100k rows, the file cannot be written. Code…
Shushiro
  • 577
  • 1
  • 9
  • 32
0
votes
1 answer

How to fix "XLSX.utils.json_to_sheet is not a function" error?

I did a js script to transform a JSON object to an excel file. The script works when I execute it in command line with a mock JSON object, but when I call it from the node "file function" of node-red, I get the error: "TypeError:…
user11367369
  • 3
  • 1
  • 4
0
votes
1 answer

```XLSX.writeFile``` does not download the workbook in my file system

I am trying to download a json as xlsx using Sheetjs. I am successfully able to create worksheet and workbook but the ẁriteFile function does not seem to do anything with the workbook. Any help would be appreciated. Below is my code:
Salman
  • 393
  • 1
  • 7
  • 23
0
votes
1 answer

Angular 6 generate excel file with sheetJs but removing some keys?

I have this JSON: [{"name":"peter", "surname":"cage", "nickname": "peterbob", "city":{"id":130, "name":"GreatCity"} }, {"name":"james", "surname":"parot", "nickname": "mrj", "city":{"id":142, "name":"OtherCity"} }, ...] I want to generate an…
matQ
  • 597
  • 2
  • 13
  • 27
0
votes
1 answer

How to delete a column from sheetjs with some condition using angular 4?

var ws = XLSX.utils.json_to_sheet(data); ws.set_column('Y1', None, None, {'hidden': True}); /* add to workbook */ var wb = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, ws, 'content'); /* generate an XLSX file */ XLSX.writeFile(wb,…
Irrfan23
  • 362
  • 5
  • 17
0
votes
1 answer

Angular-5 : hide gridlines of excel file using sheetJS and apply cell style

I am trying to export customize excel file using sheetJS in Angular-5, but facing two problems can anybody help me to resolve these issues. Thanks how to hide/remove gridlines in workbook sheets cell style not applying like font size, color…
Nazir Ahmed
  • 615
  • 4
  • 14
  • 29
0
votes
1 answer

Sheetjs reads only first 1000 rows

I use sheetjs to import excel-files into a database. Everything works fine, but it just imports the first 1000 rows. Here's my code: When the user loads a file in the input field, it creates a worker to do the reading and when done sends it with…
ckay
  • 66
  • 1
  • 12
0
votes
0 answers

How to return something in a function .onload added

I'm trying to import an excel file using SheetJS js-xlsx and I don't know how to return the variable workbook. Thanks! var rABS = true; // true: readAsBinaryString ; false: readAsArrayBuffer function handleFile(e) { var files = e.target.files,…
S Bogdan
  • 19
  • 2
0
votes
1 answer

Custom function on table column reordering --> change underlying table model

I use SheetJS to upload an excel sheet to a ui.table. While uploading I add a technical ID to my column names, which I will need later on in my project. This is how I am adding the technical ID: getColumnNames: function(worksheet, aData) { …
sonja
  • 924
  • 1
  • 21
  • 52
0
votes
1 answer

How can you import a large xlsx file front end? Out of memory issue

Face memory out of bounds issue. I am currently using https://github.com/SheetJS/js-xlsx library to upload a sheet on my front end. I keep getting an out of memory issue exceeding 36k+ rows. "parse before potential out-of-memory crash. Is there a…
Ed Diaz
  • 97
  • 1
  • 11
0
votes
2 answers

How to export Excel file from Angular Material 5 Mat-Table (Angular Material Table)?

I am new to Angular and using Angular material 5 mat-table and trying to export the table in a excel file. I have use SheetJS XLSX package. Below is my code: Table.component.html: