How to read datas from multiple tabs in excel sheet

How to get data of multiple sheets from an excel sheet in Robot framework

Aug 19 '20 Comments: 1 Answers: 0

${file} Normalised Path _downloads {Filename} get file name important file xlsx true

Open Excel Document ${file}/${filename} importantfile

${Sheet1} Get Sheet review

${Exceldata} create list

For ${row} IN @{sheetvalues} Continue for loop if ${row}[0]=='date'

Append to list ${exceldata} ${row}

END

This is giving value for only one sheet. How can I…