537 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
74
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 ...
0
votes
0
answers
110
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
180
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 ...
0
votes
0
answers
339
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 ...
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'. ...
0
votes
1
answer
180
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.
...
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 ...
0
votes
0
answers
140
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
45
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:...
0
votes
0
answers
86
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
vote
0
answers
49
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
206
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 ...
1
vote
0
answers
112
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 ...