Read Excel from a run rule

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

8.4

Is there a way to read from Excel in a Run rule without importing any external libraries into SailPoint?

Thanks in Advance!!

2

Hi @Sriindugula,

you can use apache POI library:
https://poi.apache.org/

1 Like
3

Hi Sri Veera,
for reading Excel there are some java libs out there which you could use, but unfortunately none of them is shipped with IIQ.
The best solution I see would be to write an IIQ plugin which includes one of the libraries mentioned here: https://www.baeldung.com/java-microsoft-excel plus some custom classes or BeanShell to parse the Excel.

If you really want to do it “out of the box” you might be lucky (depending on your Excelsheet), if you just unzip the “.xlsx” file and use the XML connector for importing files in this subdirectory: .xlsx\xl\worksheets*.xml.
There is one .xml for each sheet in the excel and it contains unformatted data. Have a look at the “sheetData” tags. Actually I would rather not go over that bridge…

You could of course always write everything in Java “from scratch”… which is a lot of effort compared to importing a .jar file.

Cheers
Steffen

2 Likes
4

Can the spreadsheet be converted to csv beforehand?

5

@paul_hilchey

No it can’t be converted from excel to csv before hand.

Thanks

6

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.