Hello everyone,
Any one have an idea about how to check the size of a cell in excel file.
Thanks in advance.
Regards,
Morad
Hello everyone,
Any one have an idea about how to check the size of a cell in excel file.
Thanks in advance.
Regards,
Morad
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}