Skip to main content
F
ftrujillob
Navigator | Tier 3
March 8, 2022
Question

read excel table

  • March 8, 2022
  • 1 reply
  • 88 views

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
    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 & ConditionsAccessibility statement