Read Worksheet doesn't return last row value when I send the header flag = True

[walaa-akram]

Hello Dears,

I have the following Excel sheet:

and I try to read it using the header flag = true ${workSheet}= Read Worksheet ${sheetName} ${True} ${count}= Get Length ${workSheet} ${columnData}= Create List FOR ${index} IN RANGE 1 ${count}+1 ${cellValue} = Get Cell Value ${index} ${columnNo} Append To List ${columnData} ${cellValue} END When I logged the list I found it gets all column data except last row while I was expect to get all column data except first row. Why this happen? List length is 9 and it contains following items: 0: A 1: 1 2: 2 3: 3 4: 4 5: 5 6: 6 7: 7 8: 8

[raivolink]

Hi, It works as documented https://robocorp.com/docs-robot-framework/libraries/rpa-framework/rpa-excel-files/keywords#read-worksheet, returning list of dictionaries of the data. To get all cell values you have to consider that when looping header data becomes element, turning list length to 10 as you excel screenshot is showing.

[mikahanninen]

Yeah like @raivolink said the library works as expected. The difference with header=True to False is that header row is then excluded from the results as header row values are used as dictionary keys (thus it contains actually one row less). In False case the header row is in the results and the dictionary keys are Excel sheet column names A,B,C, etc.

The correct of looping ${worksheet} is this (works in both cases, header True/False

    FOR    ${row}    IN    @{worksheet}
        Log To Console    ${row}
    END