Stack Overflow
Stack Overflow

Questions tagged [excel4node]

40 questions
0
votes
1 answer

Does anyone know how to set a path in excel4node's wb.write() function?

Below function is creating the excel file and saving it on my source folder.However i want to set a specific path where the file will only be saved on that specific path wb.write(${filename}.xlsx)
GetSome _
  • 59
  • 8
0
votes
2 answers

An error occurs if the number field is empty

I get an error when the field with the number is an empty value. Value sent to Number function of cells ["F3"] was not a number, it has type of object and value of null Can this be fixed somehow? An example of how I fill a table with numerical…
user12214130
  • 148
  • 1
  • 2
  • 7
0
votes
1 answer

How to add multiple records from a loop in Excel?

Need to add multiple records from a loop in Excel. According to the given parameters, it adds to the first column and to the first row. What needs to be replaced by worksheet.cell(1, 1) to add entries to the first column and to all subsequent…
user12094588
  • 311
  • 1
  • 2
  • 6
0
votes
1 answer

How to save Excel file when using Heroku?

I'm working on Node.js / Express project which includes route to get Excel file. I have been using excel4node xlsx generation library and it works perfectly when running app on local machine. But when the app is used on Heroku, I receive error 400…
Ville
  • 43
  • 4
0
votes
1 answer

How to avoid overwriting the previous data using excel4node?

I have some data and I am storing it in excel csv, using npm package excel4node. But as I run the script a new instance of workbook is created. If I am running the script multiple times I want to keep on appending the new data in the sheet rather…
SANJU SANGAL
  • 17
  • 2
0
votes
2 answers

How to check file is writable (resource is not busy nor locked)

excel4node's write to file function catches error and does not propagate to a caller. Therefore, my app cannot determine whether write to file is successful or not. My current workaround is like below: let fs = require('fs') try { let filePath =…
Jeon
  • 4,000
  • 4
  • 28
  • 73
0
votes
0 answers

excel4node:how to achieved add DataValidation"indriect"

Is there any method to add DataValidation to the cell using the package, excel4node? it can achieved in excel2013 to add DataValidation "=INDIRECT(AA9)" I find Methods Worksheet data validations ws.addDataValidation(); can add DataValidation, but…
L.CH
  • 13
  • 5
0
votes
1 answer

AWS Lambda- Send Worbook 'excel4node' object using AWS SES

I have developed a function on Lambda which results into a list of json objects i.e. a JSON array. Also the JSON array is traversed and converted to an Excel sheet using Node.JS library 'excel4node' I have also configured SES for the current Lambda…
Matey Johnson
  • 223
  • 1
  • 2
  • 12
0
votes
1 answer

Using Node: I would like to have an "adaptive" cell

So, the problem is this: I'm using excel4node to create and write on excel. My question is this: Let's say cell (1,1) and (1,2) are two numbers. I would like to programmatically create a third cell that is the sum of both numbers. Example: if cell…
user171208371
  • 1
  • 1
-1
votes
2 answers

How to print json array in excel4node

I have to print an excel with 10000 rows. There is any way to bulk print a json array using excel4node?. e.g.: Mongodb insertMany operation
Gudari
  • 287
  • 1
  • 16
1 2
3