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
0
votes
2 answers

ElectronJS Event Listener Loads All Files Instead of Latest Selected

I'm creating an app that will solely run on local except for mail sending operations.I've wrote necessary codes that will get recipients' mail adresses from excel file and send mail one by one. My problem is; if I select additional excel files after…
MKD
  • 1
  • 2
0
votes
1 answer

merged column only display as first row

I have this excel format then will be import and display into html table. The participants will always have same Trainer so i just merged the trainer column but the problem is when console.log it, it count as one row only. Here's the code const…
Strywyr
  • 242
  • 15
0
votes
0 answers

How do I solve this SheetJS and xlsx-js-style styling question?

after trying to purchase the pro version contact with the people from https://sheetjs.com/pro/ (this would be the easiest option, but never receive our quote) I have been trying with xlsx-js-style (https://gitbrent.github.io/xlsx-js-style/) which…
JayVee
  • 1
  • 1
0
votes
0 answers

Weak Encryption in js-xlsx

Fortify scan check is showing weak encryption js-xlsx file. It is showing that RC4 is a vulnerable and weak encryption method. It is recommended to use strong encryption instead of RC4. Below is the code for rc4 encryption. function…
Nikita
  • 33
  • 1
  • 6
0
votes
1 answer

for-loop in node.js (xlsx sheet create) doesn´t work

i need support! My loop doensn´t work and i don´t know why :/ I want only one xlsx (ProductList.xlsx), but for each product a sheet. I tried it with for-loop but it doesn´t work. const product = []; //fill out product for (let i = 0; i <…
Hannes Z
  • 1
  • 2
0
votes
1 answer

Javascript - SheetJS XLSX - Need help on cell value right alignment

I have a code like below (using XLSX javascript ) where I need Cell numeric value have right alignment, magnitude commas and 2 decimals. Its working for magnitude commas and 2 decimals, but I am facing issue for cell value right alignment, Can any…
K.Krishna Raju
  • 3
  • 4
0
votes
1 answer

How to return "Double quoted" JSON from xlsx module? (Node.js)

I am using the xlsx module in node.js. But apparently the xlsx.utils.sheet_to_json returns JSON that is not double quoted; It's either single quoted or not quoted at all. The returned JSON looks like this: [ { student_Id: 1, phone_number:…
b_a9f
  • 9
  • 2
0
votes
0 answers

Save a workbook created with xlsx R package in AWS S3 is not working

I created a workbook, named workbook_1, using the xlsx R package, like this: workbook_1 = xlsx::createWorkbook() It has the next class: I need to upload this file to a bucket path in AWS, S3. I tried with this code that worked for me previously…
Valeria Arango
  • 287
  • 1
  • 2
  • 8
0
votes
0 answers

Error: "Uncaught SyntaxError: Cannot use import statement outside a module (at index.js:1:1)" when importing xlsx module

I am trying to make a my index.js file read Excel file (.xlsx) and get data from it which I want to show on my website. It is not a server based though I am using some node modules. I have started learning JavaScript recently and wanted to make this…
Nischal Jogani
  • 1
  • 1
0
votes
2 answers

Get headers row REACT XLSX

I'm currently working with an excel document, but I need to get only the table headers name. So far my code looks like this if(file){ let fileReader = new FileReader(); fileReader.readAsBinaryString(file); fileReader.onload = (event)…
Jose A.
  • 483
  • 2
  • 7
  • 15
0
votes
1 answer

How can I convert .xls to .xlsx using a nodejs library?

I'm having trouble reading a .xls file using the ExcelJS library. No problems reading .xlsx files. I used to use only the xlsx js library and did not have any issues reading .xls files. I was under the impression ExcelJS included xlsx library so my…
sychordCoder
  • 230
  • 3
  • 14
0
votes
1 answer

Converting xls files to json with xlsx.js - issue with hyperlink

I use the xlsx.js library for converting excel-files to json and it works, but I have a problem when I add a hyperlink into a cell of the table as it's illustrated in the image below: The code I use for parsing: function readExcel(url) { …
corsaro
  • 731
  • 1
  • 9
  • 24
0
votes
2 answers

Why display table centers item with px but not with vw vh?

Hi i need to center span inside a div. I tried to center it with display table everything worked when parrent height and wigth were using px unit. But when i switched from px to vh, vw it jumped to the right. I also tried to use text-align: center…
Vlad
  • 419
  • 1
  • 10
  • 21
0
votes
0 answers

Convert unicode to "readable" string

I'm parsing a CSV text file containing some data (with labels, numbers, symbols, ...) using XLSX. At some point, my data are parsed and one of the cell content is '\x80', which is the unicode code of the euro symbol. const s = "\x80" console.log({ s…
Bogy
  • 944
  • 14
  • 30
0
votes
0 answers

How can I read a protected XLSX with JavaScript in the serve?

How can I read a protected XLSX with JavaScript in the serve? I am using a sheets library, the xlsx-populate library doesn't works in the serve.
User1738
  • 18
  • 7
1 2 3
…
9 10