Import Multiple sheets from xls

Started by bigyin, August 18, 2021, 11:52:41 AM

Previous topic - Next topic

bigyin

Want to load in default properties/metadata for selected elements and views from a .xlsx (allows no technical admin)

These arrays will contain the property names and default values for elements, so there will be a number of sheets.

Not being a developer, would be grateful for the best approach and libraries to use within Jarchi

Jean-Baptiste Sarrodie

Hi,

For this you'll need some javascript library to read XLSX files. One common lib for that is https://sheetjs.com.

I did test it some years ago and I was not able to use it with jArchi and thus switched to a lib able to only create XLSX (that was my use-case). But now that jArch comes with GraalVM, I think most compatibility issues should be solved and you should be able to use it now.

But, this obviously requires some javascript development skills to make it work :-(

Regards,

JB
If you value and use Archi, please consider making a donation!
Ask your ArchiMate related questions to the ArchiMate Community's Discussion Board.