Node package to read, manipulate and write spreadsheet data and styles to XLSX and JSON.
Questions tagged [exceljs]
508 questions
0
votes
1 answer
Convert standart excel date to date in javascript
I have this code to make conversion :
var date = new Date(1900, 0, 0, 0, 0, 0);
date.setDate(date.getDate() + row.values[1]);
var heure =…
momolechat
- 155
- 11
-1
votes
1 answer
How to Get the DataType of excel cell value using nodejs version16.14.2 and Vue js
I need to get the DataType value of each cell record of an Excel sheet using Node.js version 16.14.2 and Vue js. Can you please help me out how can I get the value of the DataType of each cell in the excel sheet? I am using Visual Studio Code…
GDeep-09
- 29
- 3
-1
votes
1 answer
How to read .xls with ExcelJS?
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
-1
votes
1 answer
Loading excel files in observablehq
Observable has a built-in method for loading excel files. The docs say it's based on exceljs.
However, since it appears to be a cut-down version, I wanted to use exceljs directly.
I created this notebook.
Strangely, the loading seems to work - I see…
John
- 6,693
- 3
- 51
- 90
-1
votes
1 answer
Express.js send() will not prompt download through email client
I have an api that I'm testing at the moment. I'm using ngrok to make my local server that has the api code visible to the internet. If, for example, I have a link like http://something.ngrok.io/api/spreadsheet?param1=123¶m2=001,002, what…
thesofaking
- 45
- 1
- 7
-1
votes
1 answer
How to give path while using exceljs writefile?
I don't want to create that excel in my main directory, i have an another folder for these excels but how can i path it? I cant see anything about pathing in docsenter image description here
-1
votes
1 answer
React hooks, not re-rendering
I am new to React and hooks and i can't figure out why i can't get the list of files in my app to refresh after i click convert. It will only show the correct file if i refresh the page.
Here is the React part. I upload a file in csv format, then…
Adrian Sultu
- 330
- 5
- 16
-1
votes
1 answer
How to Append Existing Excel File in NodeJS using ExcelJS
How can I append to the last open row of an already existing Excel file in NodeJS using ExcelJS?.
Tackten
- 47
- 1
- 9
-1
votes
1 answer
Not able to download excel file on browser
I am using exceljs in my route to create an excel file and trying to download the same file on my browser. But the corrupted file is getting downloaded.
Also, the file is getting downloaded as expected when I tried hitting the endpoint using…
Sujeet
- 1
- 3
-1
votes
1 answer
Excel Data Not Coming In An Array
I have a simple array, as shown in the image below
I want to get the office codes in an array. I am using the node exceljs module to achieve this
As per the example from the github page, I have this piece of code
let array_is =[];
let workbook…
demouser123
- 4,108
- 9
- 50
- 82
-1
votes
1 answer
How to protect the excel selected cell using nodejs
Hi i have create and download the excel file at run time by using "exceljs"
https://www.npmjs.com/package/exceljs
now I want to protect the excel cell at run time is it possible to protect excel file. can anyone tell me.
Vinoth
- 972
- 1
- 16
- 47
-2
votes
1 answer
How to set values to 2d array and access the values using arr[i][j] or arr[i,j] in javascript
I need to copy few cells from one excel to another excel using node js.
Suppose i need to copy 3 cell values from 2 rows and assign to an array as below
First row
array[0,0] = A1 value
array[0,1] = B1 value
array[0,2] = C1 value
Second…
Nalu
- 195
- 2
- 13
-4
votes
3 answers
How to Auto resize row in excelJs?
How to set excelsheet row height to auto so that the content can autofit in the cell using exceljs
ISHITA PRAMANICK
- 99
- 1
- 7