540 questions
0
votes
1
answer
72
views
Playwright Excel JS > ReferenceError: worksheet is not defined
currently learning playwright with ExcelJS I'm using excel JS to go into a spreadsheet find a specific row and column and replace 'apple' with the phone. My code matches the learning material but I ...
- 1,539
0
votes
0
answers
94
views
Is there a better way to generate an Excel FIle in a react-native expo app?
I'm building a react-native expo app, specifically for android. I have a feature, where the app shall generate an excel sheet and download it to the user's device. So I created a utils folder in my ...
3
votes
1
answer
176
views
Can I avoid exceljs date formatting
I'm having an issue where if I try to read a row that was originally a date, it gets converted to a number like : Last_Contact_Date: 45618 from the original 31/05/2024 in the file. Can this somehow be ...
- 438
0
votes
0
answers
325
views
How to interpret "numFmt" in ExcelJS to display cell values as HTML text?
I have read an Excel file using the ExcelJS library, but I am unable to interpret numFmt in a way that displays the cell value as it appears in Excel.
For example, I have different number formats ...
- 9
0
votes
1
answer
26
views
ExcelJs - Want to read values as text
import exceljs from "exceljs";
import { log } from "node:console";
const { Workbook } = exceljs;
const workbook = new Workbook();
const file = 'files/simpleNameValues.csv';
const ...
0
votes
1
answer
105
views
Why does 'exceljs' package delete the scripts in an excel file when the javascript program interacts with this excel file?
I have an excel file with a lot of scripts (office scripts). These scripts are linked with buttons inside the body of the excel file. I have written an Javascript app that I execute thought 'NodeJS'. ...
- 11
0
votes
1
answer
179
views
Problems with the scope a variable into playwright [closed]
I am trying to read data from an excel file using exceljs. I put the data from a cell in the excel file into a variable, then try to use this variable to fill a form of a webpage using Playwright.
...
- 11
0
votes
0
answers
75
views
ExcelJS - How to get the current values of a dropdown of a cell
I'm populating an existing Excel file using ExcelJS.
Setting the value directly, without re-adding the dataValidation wipes out the dropdown. It's necessary to re-add the validations again using the ...
- 219
0
votes
0
answers
139
views
Using exceljs in my React Native application causes the app to get stuck at the splash screen when initializing a hook from React Query
I need to create a a way for our Mobile Application made with React-Native to generate excel files and I already have a function that will let me generate a .xlsx file using the library of exceljs. ...
0
votes
0
answers
44
views
How to add a Defined Name with square brackets ([]) in ExcelJS?
I am using ExcelJS to create an Excel file and want to add a Defined Name that references a table column. However, when I try to add a name with square brackets ([]), it does not work.
Here is my code:...
- 21
0
votes
0
answers
82
views
Different row heights and column widths between ExcelJS import and export
I'm developing a component using Vue.js and ExcelJS to open and edit xlsx files. However, I've encountered the following issues:
Column width:
Array shows: 4.5
Source Excel file displays: 3.88
...
- 1
1
vote
0
answers
48
views
Memory Heap Problem loading large Excel Template in NodeJS
The problem is that I have a server in NodeJS that only get a template in Excel that is like 26mb~ and populate this template and send to the user to download(using react in front etc.)
but the ...
2
votes
0
answers
200
views
Issues with Applying AutoFilter in ExcelJS
I'm working with the ExcelJS library to manipulate an Excel file in my React application. I have a template Excel file that already contains some auto filters applied to the rows
After I edit the ...
- 21
1
vote
0
answers
110
views
ExcelJS: Image Misaligned when Column Resize - How to Fix Precise Image Placement?
I am using the ExcelJS library to generate an Excel file with an image inserted at a specific position. However, I am encountering an issue where the image placement does not align correctly when I ...
0
votes
0
answers
102
views
Check if excel sheet is protected or not when using WorkbookReader in exceljs
I am working on read excel file by using exceljs. I have limitation where I can use this package only and no any other third party packages. Since, I need to handle with big excel file also I need to ...
0
votes
0
answers
80
views
Auto Fill Row On Content Length
I've shifted to ExcelJs from Sheet JS as I didn't find the option to adjust row values in each column. I've managed to do it with ExcelJs but still there's one issue that I am trying to resolve. So ...
- 1,177
0
votes
0
answers
156
views
How to align image at center using ExcelJS
here the code, which is insert image at last column in excel
const img = new Image();
img.src = reportTemplate.logo ? reportTemplate.logo : defaultLogo;
const logoSize = 45;
...
0
votes
0
answers
85
views
Cannot find module './doc/workbook' in Exceljs
I am using ExcelJs to export some grid data. It worked fine on my local, but while deploying it using Jenkins I am getting Error: Cannot find module './doc/workbook'.
Any idea why is this is happening ...
0
votes
0
answers
98
views
exceljs filters on header disappears and date is not triggering change in other cells
\hello all.
I have an excel file with two pages, one has the summary of the records page(the second sheet), in the summary sheet there is the J1 cell, manually I can change the date from that cell ...
- 428
0
votes
0
answers
106
views
Is there a way to protect the workbook in exceljs/sheetjs or in any other node library?
Even if I pass the workbook which is password protected, it still removes the protection on the workbook.
I want the sheet to not remove the protection on the workbook.
It doesn't remove protection on ...
0
votes
0
answers
53
views
how to send excel file using nodemailer and exceljs
const sendEmail = async () => {
try {
for (const notification of emailNotification) {
const excelBuffer = await createExcelFile(notification?.task);
const fileName = '...
0
votes
1
answer
1k
views
Add newline using ExcelJS
I would like to add a newline in a cell using ExcelJS (using the newest version 4.4).
I have tested with \r\n, \r and \n and all of them gives me the same results: The newline is visible in the ...
- 183
1
vote
0
answers
191
views
How can I lock selective cells in an excel file using exceljs library in angular?
I am trying to lock specific cells(Row 1 & Column 1 cells) in the given code. The problem I am facing is that the whole sheet is getting locked instead of the specific cells. I have tried out ...
0
votes
0
answers
49
views
How do i deal with edition of Excel with no loss of styles, references in React?
I'm developing an application using React in FrontEnd and Kotlin in Backend, but the problem is that i have to provide for the users an Excel file with their Template, i only need to put data in his ...
0
votes
1
answer
217
views
How to Parse Large Excel Sheets in javascript
I need to parse large excel sheet of size upto 5GM but getting this error
Error parsing XLSX: RangeError: Invalid string length
at Array.join (<anonymous>)
at concat (C:\Users\Pie-Cyfer\Desktop\...
- 11
1
vote
0
answers
43
views
React Native - ExcelJS library export getting stuck
I'm building a data recollection application using React Native, in which said data is exported to an Excel file.
I'm running into an issue which is that whenever I attempt to export the data, the ...
1
vote
0
answers
139
views
How to Prevent exceljs from Adding @ to Formulas?
Stack Overflow community!
I'm using the exceljs library in Vue3 project to generate Excel files with formulas. However, I've noticed that exceljs automatically prepends an @ symbol to certain formulas,...
0
votes
1
answer
493
views
ExcelJs error Error: Cannot merge already merged cells
I am trying to generate an excel sheet using excelJs. Order has array order items (could be one or more). I want that some information in the order itself are not repeated while iterating over each ...
1
vote
0
answers
295
views
Get formatted value from worksheet cell in ExcelJS
Is there a way to get the formatted numerical value from a worksheet cell in ExcelJS? In the Excel workbook the cell formula results in value is 5.726027397260274, has a number format of "#,###....
- 8,215
0
votes
1
answer
431
views
Preserve cell/column formatting when adding rows in ExcelJs
I'm making a Next.js app but I've run into a problem.
The problem: I want to add some data into an Excel sheet which has a template. I'm currently using ExcelJs to do so. Adding data into the columns ...
0
votes
0
answers
88
views
Zip File corrupted - Using Excel JS on AWS Lambda
I'm using ExcelJS to read an Excel file ,the code is working fine in the local machine and even when I use the serverless invoke local command, but when deployed on lambda it is not working. The error ...
- 69
1
vote
0
answers
590
views
inflight vulnerability in exceljs
[email protected] => [email protected] => [email protected] => [email protected] => [email protected]
is there anyway for excel js to not use inflight, or is there any other library apart from exceljs ...
- 11
0
votes
1
answer
1k
views
How to style a XLSX file using exceljs and node.js streams?
Formatting and styling works in a typical situation
const workbook = new ExcelJS.Workbook();
const worksheet = workbook.addWorksheet('My Sheet');
// Add headers
worksheet.addRow(["Column ...
- 351
1
vote
0
answers
236
views
Merging of cells duplicates the data in other merged cell instead of showing text in one cell
I am facing an issue while merging the cells using ExcelJS, below is the code where I want to merge the cells from B1 to C1, instead of merging the cell it duplicates the value of B1 into C1. See the ...
0
votes
1
answer
683
views
Adding image to the center of the cell, while using addImage method of exceljs library
I am using addImage() method of exceljs library to add image to the cell of an excel file which is exported from my angular application. I am able to add image to cell of the exported file using ...
1
vote
0
answers
176
views
How to open, save and close a file in nodejs
I created a code that inputs data into an excel spreadsheet. For example: I have Sheet1 (which will receive data via code) and Sheet2 (which has dozens of formulas). For illustration, on Sheet2 there ...
2
votes
1
answer
619
views
Is there a way to load a 140mb+ Excel file in memory in streams in NodeJS?
I have Excel files, each can reach up to 150mb in size. I need to progressively load chunks of this file (batches of 1000 rows for example) so I can turn them into JSON and manipulate them.
I tried ...
- 21
0
votes
1
answer
55
views
Excelljs file not downloading properly
I'm using Exceljs to write over an xlsx template file in the server and return it to the front so that is saved as an excel file. But the file is saved with [Object object] as the value of the first ...
0
votes
1
answer
476
views
How do I make an array of objects from an excel sheet in js with empty cells?
I am trying to make an array of objects from an excel sheet. The property names would be the first row and then each object would be made from each row beneath as long as there is a value in the first ...
- 346
0
votes
1
answer
578
views
Iterate each cell with ExcelJS
I having trouble when I try to export an Excel with data al ready filled, this is the error message on console:
enter image description here
The total of results are 346880 with 28 headers that makes ...
- 105
0
votes
1
answer
904
views
Exceljs : 'We found a problem with some content in "file.xlsx"(...)'
I'm having some issue with an Exceljs generated xlsx file. I've created csv files in my project for a while without any problem. But now I'm creating an xlsx file and, while I can open it clean on my ...
- 89
0
votes
1
answer
2k
views
I have an issue with excel js property - protection{locked:true}
I am creating and downloading an excel sheet using excel.js. I have a task like making certain columns and rows uneditable. I searched for it, I got a way like giving protected{locked: true} should ...
0
votes
0
answers
220
views
ExcelJS incorrect column count returned
I have a excel workbook which contains multiple sheets. While parsing the xlsx file, only one the sheets returns an unexpected column count i.e expecteted count 10 actual count 16294
const workbook = ...
- 3,213
0
votes
0
answers
44
views
Can we extend the built-in Ribbon options using Office js manifests?
I'm writing an OfficeJs addin for Excel that provides an additional Copy action for cells. Ideally, I'd like to add a custom menu for it on the Home > Clipboard > Copy dropdown, below "Copy&...
- 41
-1
votes
1
answer
212
views
How to add a title over my columns headers?
I'm trying to create an XLS file with ExcelJs with two sheets. I want both sheets to have a "title" on the first line (the same title for both sheets) and then a bunch of columns with ...
- 89
0
votes
1
answer
160
views
How can I fix a "could not resolve dependency" error with firebase, exceljs and emailjs?
I am trying to run emailjs but have been receiving the following errors for a while. Can someone please tell me what I did wrong?
I installed exceljs with the force flag, as in the following statement
...
1
vote
0
answers
223
views
Excel date cells generate a random bug with ExcelJs
I'm encountering an issue while parsing an Excel file using ExcelJS in a Node.js environment. The Excel file contains cells representing dates, but it seems that some of these cells are being treated ...
- 182
0
votes
1
answer
494
views
Excel js: Get header key from the template excel file
I created an Excel file template with just a row with columns on it.
worksheet.columns = [
{ header: 'Id', key: 'id', width: 10 },
{ header: 'Name', key: 'name', width: 32 },
{ header: 'D.O.B.', ...
- 191
1
vote
1
answer
992
views
How to create a chart in pdf and excel using node js?
JavaScript function to create the line chart:
function TyLyReport() {
var lineChartData = {
labels : ["Jan","Feb","Mar"],
...
- 51
1
vote
1
answer
859
views
how to read data from .xlsx file with exceljs
I am sending a .xlsx file through body form-data with key=excel, type=file, and value=text.xlsx. I want to read the values obtained from the excel file.
async create(data, params) {
console....
- 83