548 questions
0
votes
1
answer
52
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
114
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
61
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 ...
- 209
0
votes
0
answers
71
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
14
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:...
- 11
0
votes
0
answers
43
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
39
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 ...
0
votes
0
answers
67
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 ...
- 11
0
votes
0
answers
30
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
60
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
75
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,167
0
votes
0
answers
86
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
55
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
70
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 ...
- 398
0
votes
0
answers
173
views
How to read Excel file in Typescript
I have been having trouble finding a great package to read an Excel file in Typescript. The best package that I have found through my research the exceljs package. However, it does not seem to work. ...
- 461