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

Can't create worksheet in a loop

let workbook = new Excel.Workbook(); for (let i = 0; i < 3; i++){ workbook.addWorksheet('test', { properties: {tabColor: {argb: 'FF00FF00'}}, views: [ {ySplit: 5, activeCell: 'A1', showGridLines: false} ] }); } First…
So4ne
  • 1,124
  • 17
  • 38
0
votes
0 answers

Open Office JS Template in same Excel Sheet

I would like to open an standalone Excel JS Application as an action pane through my existing VBA Macro or VSTO Application Ribbon in same excel environment/file instead of new excel file/sheet. Trying to explain in different way: I already have…
PaOne
  • 13
  • 1
0
votes
1 answer

Data Driven Framework NodeJS Selenium

I'm using nodejs selenium for my automation testing and stuck with my code and was not able to print the value of A1 cell which is "admin" How could I print the value of my A1 cell? var XLSX = require('xlsx'); var workbook =…
Joshua
  • 11
  • 1
  • 1
0
votes
2 answers

Add a new record to an existing records contained excel file in excel js( already the excel contains some value now trying to insert a new record )

1 -I want to add a new record inside the excel which is already contains some value 2 - Is there any way to use excel as the database for our project so that client can use the excel effieciently //script file.js var Excel =…
dhanasekar
  • 3
  • 1
  • 8
0
votes
1 answer

ExcelJS: Process row by row

I am trying to process an excel sheet using exceljs but need to insert data into the database while processing each row and entering information into the database. At the end of processing each row I need to insert the value as success/failure and…
Prashanth Raghu
  • 169
  • 1
  • 2
  • 6
0
votes
1 answer

Excel Angular Web Add-In Error: Cannot match any routes. URL Segment: 'index.html'

In my Excel Angular Web Add-In I get the following error, when navigating to new routes: ERROR Error: Uncaught (in promise): Error: Cannot match any routes. URL Segment: 'index.html' However, the routes still work. How can I fix this?
Joshua Wright
  • 81
  • 9
0
votes
3 answers

Copy a range of cells or worksheet from using ExcelJS

Is it possible / is there a convenience function to copy a range of cells and/or a whole worksheet from one Excel sheet to another using ExcelJS?
Ritsaert Hornstra
  • 5,013
  • 1
  • 33
  • 51
0
votes
1 answer

Import CSV rows with 2000 records from node into SQL Server

I am using exceljs (https://www.npmjs.com/package/exceljs) node package to read excel file. I am looking for fast import csv with 2000 records into SQL Server. Table: User [Id PK] Role [UserId FK] Unit [UserId FK] Excel file: UserName Role Unit…
Furqan Misarwala
  • 1,743
  • 6
  • 26
  • 53
0
votes
1 answer

A loop within a loop in JavaScript

The solution to this may be simple but I cannot seem to think of an easier solution at present. I am using Excel.js and want to add values from an array to a specific set of cells. In this example E6:E25 The problem I face is that I cannot seem to…
Richlewis
  • 15,070
  • 37
  • 122
  • 283
0
votes
2 answers

Combining Two Arrays To One in NodeJS

I want to create Excel file that consist of 2 arrays of data with ExcelJS. I can create the Excel file: var Excel = require('exceljs'); var workbook = new Excel.Workbook(); var sheet = workbook.addWorksheet('My Sheet',…
ilvthsgm
  • 586
  • 1
  • 8
  • 26
0
votes
0 answers

Electron Package – How can I read and write files in packaged app?

I have an electron app which writes to an excel file: `var Excel = require('exceljs'); … function writeExcel(dataList){ //do some stuff here } ` This works fine in development. However, after packaging it with electron packager, I have the…
Ryan O'Reilly
  • 1
0
votes
1 answer

How make transfer stream in node.js?

I use JsZip and exceljs packages. ExcelJs can write excel doc to node.js stream, jszip can read file from stream and add it to archive. How I can make stream-transfer between it for convenient working with it? I make this solution, but I think its…
Mikhail Leliakin
  • 176
  • 1
  • 11
0
votes
1 answer

NodeJS Issue with huge data export

I have a scenario. In DB, I have a table with a huge amount of records (2 million) and I need to export them to xlsx or csv. So the basic approach that I used, is running a query against DB and put the data into an appropriate file to…
Gautam Kumar Samal
  • 758
  • 1
  • 7
  • 23
0
votes
1 answer

How to upload a excel file and parse it in server without saving the file locally in hapi.js

I am trying to parse excel file data in the server and it is working fine but the problem is that it is saving file which we upload in the local disk in upload folder and then it is reading data.Here is the code which is working fine but when…
willy
  • 3
  • 4
0
votes
2 answers

When I open the excel file its missing values in cells that weren't edited

I open a xlsx file that contains names and description of automation test. Then I place the value of 'pass' or 'fail' into the respective cell for a test. Then I write back to the xlsx file. When I open the file to look at the results I notice…
James
  • 129
  • 1
  • 7
1 2 3
…
33 34