Stack Overflow
Stack Overflow

Questions tagged [jexceljs]

10 questions
1
vote
0 answers

How to initialize jexcel cell value

I entered the formula in a specific cell. And I wrote a code to change the formula expression to setValue according to the value of the select box outside of jexcel. However, what was fast in the first formula was changed and it became slow. …
limsrs
  • 121
  • 1
  • 3
  • 10
1
vote
0 answers

Jexcel - Need to add on change of dropdown in place of last col dropdown

Working with jexcel javascript 3rd party library - On second last dropdown is selected as attachment then Need to change last dropdown column of that row to input file. $('#mytable').jexcel({ minDimensions: [1, 1], …
Manoj Dharkar
  • 31
  • 3
1
vote
1 answer

JExcel 7 pro - European currency format not working (use comma as decimal separator)

I'm trying to display numeric values using the European currency format but it's not working properly. The displayed values are different than the expected due to a format issue. I'm using the following column configuration: { type: 'number',…
dares91
  • 11
  • 1
1
vote
1 answer

How to export Jexcel table to .csv and .xls?

I am using Angular 8 in the application and Jexcel 3.9 plugin for the table, am new to jexcel plugin & looking to export jexcel table to .csv and .xls I am getting materials for import into the application but couldn't found on how to export jexcel…
Pooja
  • 11
  • 6
1
vote
1 answer

Change dropdown values based on a selection of another dropdown using Jexcel

I'm using Jexcel spreadsheet to catalog some data from a survey. In a column I have a dropdown with vehicle manufacturers as options (Toyota, Honda ...). In another column I have another dropdown with vehicle models. How do I filter the models only…
Wagner Silveira
  • 21
  • 3
1
vote
1 answer

Moving external library from Class-based to Functional Component in React

I'm using the JExcel javascript library with React. The documentation outlines the approach with Components, but makes use of ReactDOM.findDOMNode() which I believe has been deprecated. I've tried moving it to a functional component, but whilst it…
Dycey
  • 4,767
  • 5
  • 47
  • 86
0
votes
1 answer

exceljs npm package is not working suddenly in node js

We have implemented xlsx download code in my node js, We have used exceljs npm package for generate the xlsx file, It was worked as expected in node js 13.x recently we upgrade the node version to v16.13.2 after upgrade the exceljs package is not…
Koperumsozhan VR
  • 55
  • 7
0
votes
1 answer

Select2 and Jexcel add new option to dropdown

I have this code of Jexel with Select2 where I load the default values for each jexcel row from an array and use select2 for the dropdown: https://jsfiddle.net/ktumw528/ However I wish to know how can I populate the options from select2 with the…
bkstudio3311
  • 21
  • 3
0
votes
2 answers

Using conditional formulas in JExcel

I'm using the javascript library JExcel.js in version 4. I need to insert conditional formulas just like this: =IF(A1<>0,'ZERO','NOT ZERO') But it's giving an error. Is Jexcel able to do that?
Gustavo Menezes
  • 137
  • 9
-1
votes
1 answer

How do I know which cell is highlighted in jexcell javascript library?

I want to merge the cells marked with jexcel. I don't know how to do that. More specifically, I want to merge cells into a dynamic state and write them into merged cells in MySQL. How to do it