Question

read excel table

  • 8 March 2022
  • 1 reply
  • 39 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

Userlevel 4
Badge +7

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

Reply