Stack Overflow
Stack Overflow

Questions tagged [excel4node]

40 questions
1
vote
0 answers

based on excel4node want to disable column unhide option of excel

Is there any option in excel4node package where we can disable option for unhide column? similar like below image https://cdn.ablebits.com/_img-blog/unhide-columns/excel-unhide-column-disabled.png Once I hide column from code user should not allowed…
Gautam Parmar
  • 686
  • 8
  • 18
1
vote
1 answer

Bold font to only one word from a cell

How to set bold font to only one word from a cell? The documentation shows how to set all cells to a font type. As an example, I'll add a tag to show which word will be in bold. ws.cell(index + 4, 2).string(p[i].dataValues.diameter + '\n' +…
user12916796
  • 191
  • 9
1
vote
0 answers

Why AWS lambda generates corrupt excel file using nodejs & excel4node

I am trying to create an nodejs app which exports(downloads) excel file to user, the same code is working perfectly on localhost when i hit the url(/download) and downloaded file is OK, But when i upload same code to lambda, it returns corrupt file.…
Shubham Sharma
  • 11
  • 4
1
vote
1 answer

Time format in Excel using excel4node

I am trying to print the number of hours in excel sheet using excel4node application. although the number of hours is getting printed in the excel, I am not able to get the sum or average while selecting that column. Its only counting the columns…
RanjithaBaskaran
  • 43
  • 4
1
vote
2 answers

excel4node:How to lock a cell

using excel4node Is there any methed set some cells locked or other cells is not locked using the package, excel4node; I found sheetProtection can lock the Workbook, but I want to lock one cell or some cells. I've tried to find a method. I think…
L.CH
  • 13
  • 5
1
vote
1 answer

How can i iterate over the row and print the objects value in excel in node js?

I have an array of objects as shown below: [ { "FirstName": "John", "LastName": "Parker", "Age": "23", "Cat": "23g", "SOP": "Active" }, { "FirstName": "Rose", "LastName": "Jackson", …
VIK6Galado
  • 650
  • 14
  • 32
1
vote
1 answer

excel4node with React , how to create the file without having to save it?

In excel4node I can create a file using write or I can write to buffer as follows: wb.writeToBuffer().then(function (buffer) { // Do something with buffer }); How I can take the buffer and then make React download a file to the Browser ?
Daniel Benedykt
  • 6,496
  • 12
  • 51
  • 73
0
votes
0 answers

How to combine column using excel4node with for loop

I'm trying using excel4node to covert my data to excel. here is data : [ 'AA', 'BB', 'CC' , 'DD'...] I want each string is in 2 column in 1 row like this: and now i'm stacking in the first row, i don't know how to combine the column. here is what…
user19304185
  • 17
  • 5
0
votes
0 answers

Formula Validation - How to provide a value which contains a comma

I am trying to create an Excel Workbook using excel4node in Node JS const workbook = new excel.Workbook(); const sheet = workbook.addWorksheet(); sheet.cell(1, 1).string("title"); sheet.cell(1, 2).string("description"); sheet.cell(1,…
j10
  • 2,009
  • 3
  • 27
  • 44
0
votes
0 answers

Downloading Files from an Electron app fails

I created an Electron app which generates an Excel file and I want to send it to the client. The file is generated properly and the dialog is shown to the client, but the file is not saved on the location selected by the user. Here is my code which…
sd_19x4
  • 17
  • 4
0
votes
0 answers

Node : Excel to buffer conversion loses styling

I have a scenario where Im using the 'excel4node' npm dependency to create a excel workbook with some custom styling in it (Like block lettered headers etc). I'm converting it to buffer using wb.writeToBuffer() in excel4node library, and writing it…
Sai Krishna
  • 593
  • 1
  • 8
  • 25
0
votes
1 answer

generate excel via nodeJS in Azure Functions

I have nodejs app with expressJS and excel4node library, which is running on local machine. I'm sending REST messages to this server and it returns me excel binary file. I want to move it Azure Functions, but facing with issue. Even simple app (took…
Igor Kochetkov
  • 5
  • 2
0
votes
1 answer

Cannot read property 'username' of undefined, excel4node cannot read property username

I have to print some data in excel format using excel4node. Within the data I have objects that contains information which I want to transfer to excel format. But for some reason it shows error: TypeError: Cannot read property 'username' of…
Adil
  • 55
  • 2
  • 7
0
votes
0 answers

excel4node fetch request with next.js api routes not triggering download

I am generating an excel file and want it to be downloaded for the client by triggering an API route using the Next.js framework. I am having trouble triggering the download by using fetch. The download can be triggered by window.open(//urlhere,…
Jack_Krebsbach
  • 1
  • 1
0
votes
2 answers

Downloading excel file on the frontend using excel4node in the backend

I'm aware that this has been asked before, but I'm not able to get it to work. The backend is sending the file using wb.write('filename.xlsx', res) but on the frontend, I just get an object response. How do I get the browser to download the .xlsx…
Joseph K.
  • 1,055
  • 3
  • 23
  • 46
1
2
3