How to copy data from HTML table to excel sheet in Openspan Studio?
I think I need to copy the data from HTML table to lookup and from there to excel sheet using import(). But not getting how to implement it. Could you please help me with this issue and try to explain with a small project on how to copy data from html table to excel sheet?
***Edited by Moderator Marissa to update platform capability tags****
Accepted Solution
Infosys
IN
https://collaborate.pega.com/question/looping-html-table
Check the looping image screenshot for reference.
Avoid lookup table. If you really need it then first create lookup table structure based on your html table data and then get table data from html table and use replace table of lookup table to copy the data from html table to lookup table. Now, use lookup table get table method (as a datatable) then pass this to excel importdata method.
Pegasystems Inc.
CA
Can you please elaborate your requirement? From your question, I don't understand how Pega is even involved in what you are trying to do.
Accepted Solution
Infosys
IN
https://collaborate.pega.com/question/looping-html-table
Check the looping image screenshot for reference.
Avoid lookup table. If you really need it then first create lookup table structure based on your html table data and then get table data from html table and use replace table of lookup table to copy the data from html table to lookup table. Now, use lookup table get table method (as a datatable) then pass this to excel importdata method.