Neotys.com

Unanswered question

using javascript, How to edit .xlsx file and do search and replace in all sheets.

Please provide a javascript that can edit .xlsx file and do search and replace in all sheets and save it.

venkata S.
venkata S.

venkata S.

Level
0
39 / 100
points
Answer count
2 answers
Category
General
Author name
venkata S.
Date
February 20, 2015
about 10 years ago
Hits
viewed 1382 times
question
q

Answers

Nouredine A.
Nouredine A.

Nouredine A.

Level
4
5000 / 5000
points
Team

.xlsx files are binary  files. The only way to modify them is to open them through the appropriate software. Even if you can call such program through a Javascript you won't be able to modify your file.

Author name
Nouredine A.
Date
answer
a
christophe M.

christophe M.

Level
4
5000 / 5000
points
Team

The Apache POI project (http://poi.apache.org/) provides a Java API that allows you to manipulate MS Office documents.
You can call Java APIs from Javascript (see "Executing Java Code" http://www.neotys.com/documents/doc/neoload/latest/en/htm...)

Author name
christophe M.
Date
answer
a