Check cell size in excel file

Hello everyone,
Any one have an idea about how to check the size of a cell in excel file.
Thanks in advance.

Regards,
Morad

Hi @Morad_Elkhaily

I use/have used the library robotframework-excellibrary-xwfintech, you could do the below to check the size of a value in a cell (provided by the size you meant the value within the cell, and not the cell width or height):

${cell_value}=   Read Cell Data By Coordinates    ${sheet_name}      ${col_index}      ${row_index}
${length}=    Get Length    ${cell_value}
Should Be Equal As Integers    ${length}    20

I’ve never had the need to check the length of a value within a cell in fairness, also you want to open the file before the above is ran:

Open Excel ${excel_file_path}

1 Like