Skip to main content
Question

read excel table

  • March 8, 2022
  • 1 reply
  • 49 views
F

I have an excel table initially without information which I read with a "loop", I execute some processes and I store information in the table.

 

To reread the table with the updated information I need to create another "loop" or it can be done in another way

    1 reply

    Ashwin A.K
    Forum|alt.badge.img+10
    • Ashwin A.K
    • Navigator | Tier 3
    • March 8, 2022

    Hi @Fernando Trujillo Bustos​ ,

     

    Here is an idea, after updating the values, you could try writing it to csv using the DataTable: Write to File Action and use the CSV/TXT Actions or the Loop: For each row in CSV/TXT to read it again.

     

    Or if you want to get particular values from the newly created CSV, you can connect to it like it were a database and then use a WHERE clause to retrieve the information you are interested in.

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Terms & ConditionsCookie settingsAccessibility statement