Statistics

Keyword Documentation

📊 RobotFramework TableLibrary

🔍 Key Features

Exception: Excel File Handling

Installation

pip install robotframework-tablelibrary

Example

File Format - CSV

# Reading CSV file with header column${content} =    Tables.Read Table    ${CURDIR}${/}testdata${/}example_01.csv${result} =    BuiltIn.Evaluate    "${content}[0][0]" == "index"BuiltIn.Should Be True    ${result}

# Reading CSV file without header columnTables.Configure Ignore Header    True${content} =    Tables.Read Table    ${CURDIR}${/}testdata${/}example_01.csv${result} =    BuiltIn.Evaluate    "index" not in "${content}"BuiltIn.Should Be True    ${result}

File Format - Parquet

${content} =    Tables.Read Table    ${CURDIR}${/}testdata${/}example_05.parquet${result} =    BuiltIn.Evaluate    "${content}[0][0]" == "_time"BuiltIn.Should Be True    ${result}

Create new empty table - don't save to file system

# Create some data which should be inserted into the new tableVAR    @{headers} =    name    ageVAR    @{person1} =    Michael    34VAR    @{person2} =    John    19# Create empty table object - internally in cache${uuid} =    Tables.Create Table    headers=${headers}# Append some rowsTables.Append Row    ${person1}Tables.Append Row    ${person2}Count Table    ${uuid}    Rows    equal    ${3}# Append a columnVAR    @{column1} =    city    MG    ERLTables.Append Column    ${column1}Count Table    ${uuid}    Columns    equal    ${3}# Optional: Set new table cell valueGet Table Cell    1    1    equals    34Tables.Set Table Cell    25    0    1Get Table Cell    1    1    equals    25# Insert a new row into the existing table objectVAR    @{insert_row} =    Lu    26    HamburgInsert Row    ${insert_row}    0Get Table Cell    1    0    equals    LuCount Table    ${uuid}    Rows    equal    ${4}

Create new empty table - save to file system

# Generate new headers which should be used in the tableVAR    @{headers} =    name    age# Create new table object${uuid} =    Create Table    ${headers}# Generate some random data & append as rows to new tableFOR    ${_}    IN RANGE    ${100}    ${a} =    Generate Random String    ${b} =    Generate Random String    VAR    @{data}    ${a}    ${b}    Tables.Append Row    ${data}END# Ensure that data got written into internal table objectCount Table    ${uuid}    Rows    equals    ${101}# Write table to specific file path -> write from cache into persistant fileWrite Table    ${uuid}    ${CURDIR}/results/test_writer_new_table.csv# Check table content again, but now read table from file path!Count Table    ${CURDIR}/results/test_writer_new_table.csv    Rows    equals    ${101}

Contribution & Development

License