How to get the Part objects which are within Importable Spreadsheet in custom ImportFormProcessor?
I am writing a custom FormProcessor that extends OOTB ImportFormProcessor and overrides postTransactionProcess() method. This Custom FormProcessor gets called when we click on Import on Import from Spreadsheet wizard
The Spreadsheet is a excel file so you need an API to read the file.
I usually use following API to work with the excel files.
org.apache.poi.xssf.usermodel.XSSFWorkbook // general object to work with excel file XLSx (for old xls exists similar api)
XSSFSheet sheet = workbook.getSheetAt(0); // open sheet from excel
XSSFRow processRow = sheet.getRow(row); // get row from sheet
XSSFCell cell = processRow.getCell(0); // get cell from the row