Archi Forum

Discussion Boards => jArchi => Topic started by: bigyin on August 18, 2021, 10:52:41 AM

Title: Import Multiple sheets from xls
Post by: bigyin on August 18, 2021, 10:52:41 AM
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
Title: Re: Import Multiple sheets from xls
Post by: Jean-Baptiste Sarrodie on August 18, 2021, 14:21:39 PM
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