Hi All, Is it possible to write a run rule in SailPoint IdentityIQ to extract data from an Excel file? If so, can you please anyone guide me on this Thanks, Ranjith M

Hi @Ranjith25 , see this topic: [image] Read Excel from a run rule IIQ Discussion and Questions 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 A…

Hi @Ranjith25 , As pointed out by other experts it is just about using the library and java beanshell code so more or less you can achieve everything that can be achieved via java. Let us know if you still need any specific help. Thanks

Hi @ashutosh08 I’m importing every package, but I’m still getting the error ‘class XSSFWorkbook not found in namespace.’ Can you please guide me on how to resolve this issue? import java.io.File; import java.io.FileInputStream; import java.util.Iterator; import org.apache.poi.ss.usermodel.Cell; …

Have you imported the library in lib folder?

Hi @Ranjith25 , Primarily you will need below jar as dependency and the same should be part of your WEB/INF/lib folder if you want to run it from Rule. Please add it and let us know if you still face issue. poi-3.12.jar poi-ooxml-3.12.jar poi-ooxml-schemas-3.12.jar Thanks

Hi @ashutosh08 Is it possible to convert an .xls file to .csv or reading the data from xls without adding new JAR files, as I do not want to include additional JAR files in my scenario Could you please guide me on this

Hi @Ranjith25 , Can you help with the use-case for which you want to read excel, So that accordingly we can suggest some workaround. Thanks

Hi @ashutosh08 I imported the following jar file in webInf.lib folder poi-3.12.jar poi-ooxml-3.12.jar poi-ooxml-schemas-3.12.jar and Then, I tried running this code: import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFShee…

Hi @Ranjith25 , There might be some dependency this jar have on other. My recommendation will be to add all this dependency jar in your project in your IDE and once you have concluded about jar then import it in your WEB-INF/lib folder. Thanks

Hi @Ranjith25 , Is it resolved? Thanks

better use the CSV file reader and upload the file as CSV despite of XLS , so that you don’t have to add any additional jar files and also you can use inbuild sailpoint class to read the required data .

Getting data from Excel file using run rule

IdentityIQ (IIQ) IIQ Discussion and Questions

enistriminsait (Emanuele Nistri) August 5, 2024, 1:36pm 2

Hi @Ranjith25,

see this topic:

Topic		Replies	Views
Read Excel from a run rule IIQ Discussion and Questions rules , identityiq	5	244	September 24, 2024
Plugin File Upload IIQ Discussion and Questions	6	1896	July 19, 2023
Run rule task take input from csv IIQ Discussion and Questions identityiq	2	422	December 31, 2023
Upload CSV to SharePoint from SailPoint IIQ IIQ Discussion and Questions identityiq	2	55	October 18, 2025
Import XML Object From Rule IIQ Discussion and Questions rules , identityiq , tasks	7	393	September 14, 2024

Getting data from Excel file using run rule

Related topics