Stack Overflow
Stack Overflow

Questions tagged [xlsx-populate]

Excel XLSX parser/generator written in JavaScript with Node.js and browser support,

Excel XLSX parser/generator written in JavaScript with Node.js and browser support, jQuery/d3-style method chaining, encryption, and a focus on keeping existing workbook features and styles in tact.

RESOURCES

16 questions
2
votes
0 answers

Error: Corrupted zip : can't find end of central directory - XLSX Populate

I have a code that read an excel file that was input and post the data into a mysql database. The problem is that sometimes, not always, when I post the method, i receiv the following error: Error: Corrupted zip : can't find end of central…
polonio
  • 333
  • 3
  • 11
1
vote
1 answer

xlsx-populate - wrong parsing - getting for each sheet the data of the one sheet after it

I parse a lot of files with xlsx-populate library and all works well. Now, I have one file that I get wrong data from parsing, seems I get for each sheet the data of the one sheet after it. E.g. for sheet1.cell('A1').value() I get the data that…
ESI
  • 1,657
  • 8
  • 18
1
vote
0 answers

How to store formula with calculated value using xlsx-populate

I want to set formula of a cell then store the calculated value in the same cell as we do in Excel but when I call cell.formula('A1*10') will set formula on cell, but the result is not calculated until I open and save the sheet using Excel. I need…
Ali Ag
  • 27
  • 3
1
vote
2 answers

Add password in xlsx using secure-spreadsheet

im try to put password in my excel file def excel_file test = Axlsx::Package.new do |p| p.workbook.add_worksheet(:name => "Pie Chart") do |sheet| sheet.add_row ["Simple Pie Chart"] %w(first second third).each { |label|…
wiwit
  • 73
  • 1
  • 7
  • 26
1
vote
1 answer

npm xlsx library Error : unsupported format |#,###.0000000| - Excel custom number format parsing error

I am trying to parse an xlsx file with numbers of the format "7242.1661445". On inspecting in Microsoft excel, I found that the cell is of custom number format "#,###.0000000". I am parsing this file using xlsx library…
Piyush Upadhyay
  • 177
  • 1
  • 12
1
vote
2 answers

scope issue in javascript between two Functions

i have try to get the excel sheet using xlsx-populate so i am trying to get the values from mailEvents collections so i can add or pass the value in the init Collection function.if i have solved this issue then my problem regarding excel is also…
Amar
  • 55
  • 1
  • 8
0
votes
1 answer

Using defined names with xlsx-populate

I'm currently trying to create defined names in excel using the node package xlsx-populate, and I'm using the docs here: https://github.com/dtjohnson/xlsx-populate#defined-names I'm trying to give it a value which refers to a formula, like below,…
gb992
  • 91
  • 9
0
votes
1 answer

Hot to skip hidden rows while parsing an excel file with xlsx-populate

I'm reading one sheet with the range and I want to skip hidden rows. Is there a way to do this? This code reading all rows: const values = workbook.sheet("Sheet20").range("D15:G577").value(); Thanks!
chupawac
  • 11
  • 2
0
votes
1 answer

Writing special characters to excel file using xlsx-populate

I am using xlsx-populate to write to excel files. Whenever the text contains special characters such as smart quotes or bullets points, it gets printed as weird character like ’. However if replace them with their Unicode value (Right Single…
LoneWolf
  • 86
  • 8
0
votes
1 answer

JS xlsx-populate parse password protected excel file data

How to get the data from the columns? So far I am able to get an object as a whole workbook: I also believe that the column data (cells) should be accessed in that "_rows" property (not sure about that). Below is the code, I am using xlsx-populate…
marco_van_cerbex
  • 53
  • 7
0
votes
1 answer

How to convert the auth response into array of objects?

I am trying to get the response of the users using auth function and i have to create an excel sheet using the xlsx-populate library and i am able to convert that into an array of objects as the limit is 1000 so there are multiple arrays of objects.…
xanderUtin
  • 25
  • 5
0
votes
1 answer

Could I parse to `json/[object] using xlsx-populate

I want to parse an array of objects into xlsx-populate so it can give me the excel file. const xlsxPopulate = require('xlsx-populate'); const worksheet = await xlsxPopulate.fromBlankAsync(); const sheet1 =…
amarjeet singh
  • 79
  • 1
  • 9
0
votes
1 answer

Node.js Express: Weird Characters in response to download XLSX Attachment

I am using xlsx-populate module with node.js. I am sending the workbook as a buffer, as mentioned on their site. I am using postman to hit the API and get the xlsx file as attachment. But the response I am getting has weird characters as shown…
Parth Jaggi
  • 3
  • 3
0
votes
0 answers

Delete file only after download window.location

I have a route on a node server that generates a excel file and is downloaded. This is the part of the route that creates the xlsx file and responds. workbook.toFileAsync("./public/" + empresa2 + ".xlsx").then(() => { res.download( __dirname +…
Ingolf Krauss
  • 161
  • 1
  • 2
  • 23
-1
votes
1 answer

Cant make a variable be seen outside of a function in Node js?

I need to make the index_to_write variable to be seen outside of the function. How can I make this possible? const XlsxPopulate = require('xlsx-populate'); let found = false; let i = 1; let index_to_write =…
Ariadne R.
  • 452
  • 11
  • 24
1
2