Hi,
I am doing upload from Excel to af:table and then commiting to DB.
I have followed this blog . Import data from XLS and XLSX (Excel) to ADF Table Using Apache POI – Ashish Awasthi's Blog (Jdev/ADF)
If all the cell values in the excel are not null then there is no problem in loading the data.
When I encounter a null value then as per the code in the method readNProcessExcelx of the blog
else if (Index == 1) {
row.setAttribute("FirstName", MytempCell.getStringCellValue());
it is erroring out and not going to the next index cell value. And the data that is uploaded into different attributes does not match with the excel data.
how can we set a null value to an attribute whose cell value in excel is null ?
Thanks,
Vinay.