Stack Overflow
Stack Overflow

Questions tagged [exceljs]

Node package to read, manipulate and write spreadsheet data and styles to XLSX and JSON.

508 questions
0
votes
1 answer

How to call ajax from Excel JS API

I am new to Office.js API. I am trying to develop Web Add-In for Excel and I need to get data from WebAPI for this I am trying to use ajax but its not working Here is very simple Ajax code $.ajax({ url:…
user3881465
  • 239
  • 2
  • 5
  • 19
0
votes
2 answers

ExcelJS writeFile not working: Uncaught TypeError: fs.createWriteStream is not a function

I'm trying to export a formatted excel file using ExcelJS and the writeFile method simply isn't working. I get the following exception when I call the function: Uncaught TypeError: fs.createWriteStream is not a function My javascript is bundled…
John Riley
  • 468
  • 1
  • 6
  • 23
0
votes
0 answers

Add VBA macro to excel using javascript or python

Anyone here worked on adding a VBA macro to an existing excel sheet using python or Javascript?? I have an application build on top of HapiJs, and have a requirement to download an excel, which consists of a VBA macro We used exceljs library on…
Rahul Surabhi
  • 46
  • 2
0
votes
3 answers

TypeError: Cannot read property 'getRow' of undefined

Tried with cellValue= worksheet.getRow(1).getCell(1).value; and cellValue=console.log(worksheet.getCell('A1')) please find below my code : cellread2=function(){ var Excel; var filePath = path.resolve(__dirname,'E:/excel.xlsx'); …
Prashant P
  • 15
  • 1
  • 6
0
votes
0 answers

Having Trouble with mongodb Promisies

So i am trying to run multiple queries, all while creating rows to an excel sheet, and then after all that actually writing to an excel file The problem I keep stumbling over is that I end up writing to the excel file before I am done with my…
tyler16
  • 73
  • 6
0
votes
1 answer

Uploading output of ExcelJS to Azure Blob Storage in NodeJS

So I am using ExcelJS to create an Excel file. Currently I am saving the file to disk. The data I am adding to the file is coming in from an API call. let options = { filename: 'pathtofile', useStyles: true, useSharedStrings: true } let…
Kevin Lee
  • 1,104
  • 3
  • 13
  • 33
0
votes
1 answer

Writing values into excel in Protractor

I am capturing some values in runtime and would like to write them back into an existing excel file. Request your help in this aspect. thank you
suneel
  • 11
  • 1
  • 6
0
votes
1 answer

how to write all array elements to excel file using exceljs in nodejs

I have a problem.. I want to write all array elements to excel file using exceljs in nodejs.. For example; My array is like this array image and than I want to write excel file. For example excel image So how can I do this just like that.? Thanks…
Fatih Koçak
  • 1
  • 1
0
votes
0 answers

Trying to convert xlsx to csv using a node stream

I have a lambda script that retrieves an email from s3, parses it with MailParser (streaming), transforms attachments to csv if necessary, and stores them in a different bucket. The script handles csv files (no conversion) and zip files, but I can't…
JorgePinon
  • 345
  • 2
  • 9
0
votes
0 answers

Populate Excel sheet with table data

I've created a Excel task pane app with VS2015 (Excel Web Addin) and Office tools. On the basis of this article, I've also created an ms sql database, including the models and controllers. How can I populate the contents of the table Movie in…
user4804769
0
votes
1 answer

Passing values to excel file does not give the new calculated values by excel

I have an excel file which does some complex logic calculation on input of values into the cells. I wrote a javascript node app to pass the input values and read the output but it seems like the excel does not do the calculation and give the new…
Adnan Hussein
  • 261
  • 1
  • 4
  • 14
0
votes
2 answers

Send writable stream as an attachment node express

I am creating an xlsx workbook using the module exceljs and then I would like to send it as an attachment through my express middleware. I create and save my workbook in a stream using the following code as shown in documentation of the module …
cs04iz1
  • 1,737
  • 1
  • 17
  • 30
0
votes
1 answer

Error: Not implemented Trying to create a stream with ExcelJS

Using Node v 5.4.1 I'm trying to create a stream like so: const program = require('commander'), Excel = require('exceljs'), colors = require('colors/safe'), inquirer = require('inquirer'), async = require('async'), …
Datsik
  • 14,453
  • 14
  • 80
  • 121
0
votes
1 answer

How to get the data in a excel sheet to the javascript (jquery) array

I want jquery or javascript code to get the data from excel and add them to array in jquery. Example: In column "A" there are names, Kasun Nirmala Gemba John And I want to add then to Var names=['Kasun', 'Nirmala','Gemba','John'] This is what I…
KNB
  • 97
  • 3
  • 9
0
votes
1 answer

Javascript array contents disappear after leaving function context

I'm using the Node npm library "ExcelJS" to read in an Excel workbook's worksheet and populate an array with objects that represent the data found in the sheet's rows. I don't believe the issue is directly related to ExcelJS, rather probably due to…
Jake Shakesworth
  • 3,335
  • 4
  • 29
  • 43
1 2 3
…
33
34