Stack Overflow
Stack Overflow

Questions tagged [js-xlsx]

JavaScript Spreadsheet Parser and Writer

Parser and writer for various spreadsheet formats. Pure-JS cleanroom implementation from official specifications, related documents, and test files. Emphasis on parsing and writing robustness, cross-format feature compatibility with a unified JS representation, and ES3/ES5 browser compatibility back to IE6.

Resources

137 questions
3
votes
2 answers

Node.js - save xlsx to disk

I am using Node.js and js-xlsx for generating new Excel files. When a new file is generated I want it to be saved to local disk. This code is used generating and downloading a new Excel file, how can it be stored to disk…
Nenson
  • 173
  • 2
  • 9
3
votes
0 answers

Apache POI vs JS XLS - What's the best for an Excel Sheet driven application?

I'm developing an Excel Sheet driven application. All the data must be retrieved from an specific and default Excel Sheet that will contain new rows and alterations in existing rows. I need to merge specific columns with the existing data, and…
Radec
  • 65
  • 9
2
votes
0 answers

Convert binary string to .xls file using nodejs

I have a 3rd party service which supposes to return me an .xls By calling their API, I get a response similar to this: Which I believe is a binary string (presented in Postman). The Content-Type is text/html; charset=utf-8 I need to convert it to…
Yuriy P.
  • 111
  • 8
2
votes
1 answer

Read excel file using js-xlsx in Vue with Vuetify file input component

I am trying to load a file into the browser and render it in a vue-excel-editor component. To do this I have a Vuetify v-file-input component into which the user can enter a .xlsx file. That works fine. I then listen to the change event on this…
wfgeo
  • 2,716
  • 4
  • 30
  • 51
2
votes
1 answer

Export to Excel with a hyperlink field

I am exporting some data to excel as follows :- import * as React from 'react'; import * as FileSaver from 'file-saver'; import * as XLSX from 'xlsx'; export const ExportCSV = ({csvData, fileName}) => { const fileType =…
JMon
  • 3,387
  • 16
  • 63
  • 102
2
votes
2 answers

Threads module giving error of channel closed

I am using the npm xlsx (lib/parserScripts/readExcel.js) and threads module to read a large excel file. This works fine for the first time but if I simultaneously upload another large file then I get an error Error: channel closed at…
art
  • 226
  • 3
  • 11
  • 30
2
votes
1 answer

xlsx file corrupted while downloading with the file-saver npm package

I am having a problem in downloading a xlsx file. My excel file is generated with js-xlsx. I have to add some authorization headers to verify the incoming requests on the server. For this reason, I can not just simply open the link in a new window…
Seeker
  • 1,877
  • 4
  • 32
  • 56
2
votes
0 answers

Cells are not formatting as per styling Xlsx-Styles Angular 4

I have to export an excel sheet through my angular app. So I am using js-xlsx and xlsx-style modules. I would like to format the cells as I required but am not able to. The below is the piece of code using for styling the cell. cell.s = {font: {…
thecrusader
  • 301
  • 6
  • 18
2
votes
1 answer

How to parse with column from excel to convert it to JSON

I have tried to display the json value from the table. But it creates the JSON from Excel (Which parse as an row) I would like to parse the excel data as an column wise. Please help on this. I am using angular to parse. Upload() { …
Idris
  • 381
  • 2
  • 7
  • 16
2
votes
1 answer

Excel data extraction using SheetJS/js-xlsx and its usage in AngularJS

I want to extract xlsx data and display onto my webpage. I have used SheetJS/js-xlsx for extraction of data from XL sheet. Data is successfully getting extraced but I am not sure how to get this data into AngularJS for further usage. /* set up…
Kshri
  • 414
  • 3
  • 16
2
votes
1 answer

Write a Date column with js-xlsx

Using js-xlsx I did several attempts to write a XLSX file with a Date column, such as the one below. Each time, the date is not rendered as I expect when I open the XLSX file with Excel 2010: it is rendered as the number of days from a certain…
Stéphane Laurent
  • 75,186
  • 15
  • 119
  • 225
1
vote
2 answers

How to send excel file with nodemailer

I'm trying to send an email with an excel file attached, but when I open it an error pops up saying that the file is damaged. It also downloads the file (which I actually don't want to) and I can open that with no problem. I'm using the js-xlsx…
Giuseppe Graziano
  • 21
  • 4
1
vote
0 answers

How to get n rows of a large excel sheet in Nodejs

I am getting excel data in buffer format to nodejs. I have to read this data and send the headers and first 1000 records back as a response. I have tried the below code This is my router file, where I am using multer const express =…
Sai sri
  • 515
  • 12
  • 25
1
vote
2 answers

How to create more than one XLSX sheet from HTML table in js-xlsx (sheetjs)?

I am using sheetjs to convert some of my table data into xlsx format (and download later). However, how can I add more than one sheet into the xlsx? The current code is: var elt = document.getElementById('table_instance'); var wb =…
AGamePlayer
  • 7,404
  • 19
  • 62
  • 119
1
vote
1 answer

How to export JSON-like data in spreadsheet column to json file?

I have a Google sheet with JSON-like data in a column and would like to export this column as a JSON file. I have tried using javascript along with xlsx package to convert the sheet to json file but it adds backslashes to the column and cannot be…
Maharshi
  • 106
  • 1
  • 9
1 2
3
…
9 10