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

Answers

.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.

Christophe M.
Christophe M.

Christophe M.

Level
3
3212 / 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...)