Read Data from Excel AND pass to API Request in Java

I have a sample of Excel data that needs to be read and pass to API as XML format. Example:

I have tried to use Apache POI in reading data by row. But how do I get the columnName and the value from the column & pass that data into API request:

API Request Sample:

RequestBody body = RequestBody.create(mediaType, "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\r\n<ns2:Fields xmlns:ns2=\"csng\" xmlns:ns1=\"http://www.w3.org/1999/xlink\">\r\n\t<ns2:Field name=\"**Project**\">**customerCloud**</ns2:Field>\r\n\t<ns2:Field name=\"**Product**\">**customerPortal**</ns2:Field>\r\n\t<ns2:Field name=\"**Component**\">**cloudPlatform**</ns2:Field></ns2:Fields>");

Java code:

File file = new File("testdata.xlsx"); 
    
    FileInputStream inputStream = null;
    
    try {
        inputStream = new FileInputStream(file);
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    }
    
    workbook = null;
    try {
        workbook = new XSSFWorkbook(inputStream);
        
        rows = workbook.getSheetAt(0).getPhysicalNumberOfRows();
        
        System.out.println("No Of Rows in ExcelSheet---"+rows);
        
        XSSFSheet sheet = workbook.getSheetAt(0);     //creating a Sheet object to retrieve object  
        Iterator<Row> itr = sheet.iterator();    //iterating over excel file  
        
        int i = 0;
        while (itr.hasNext())                 
        {  
            Row rowdata = itr.next();  
            
            Iterator<Cell> cellIterator = rowdata.cellIterator();   //iterating over each column  
            int j=0;
            while (cellIterator.hasNext())   
            {  
                Cell celldata = cellIterator.next();  
                
                System.out.print(celldata.getStringCellValue() + "\n");  
                
                j++;
            
            }
            System.out.println("");  
            i++;
        }
        
    } catch (IOException e) {
        e.printStackTrace();
    }   

With above code I am getting output as follow:

Project
Product
Componant

customerCloud
customerPortal
cloudPlatform

Any help would be appreciated. Thanks

The simplest way would be to use a library which maps tables in excel sheets to java objects. For example: Reflective Excel

You would need to create a class representing the table rows as follows:

public class ExcelRow {

    @ExcelColumn("Project")
    private String project;

    @ExcelColumn("Product")
    private String product;

    @ExcelColumn("Componant")
    private String component;
}

Then you can read the rows and retrieve the values for each column:

List<ExcelRow> excelRows = new ReflectiveExcelReader(yourFile).readRows(ExcelRow.class);