Author Topic: Import Multiple sheets from xls  (Read 152 times)

bigyin

  • Active Member
  • ***
  • Posts: 30
Import Multiple sheets from xls
« on: August 18, 2021, 11: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

Jean-Baptiste Sarrodie

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 729
  • Archi Evangelist and Contributor. Visionary.
    • About me...
Re: Import Multiple sheets from xls
« Reply #1 on: August 18, 2021, 15: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
If you value and use Archi please consider making a donation! https://www.archimatetool.com/donate