I need to utilize a lot of data which is excel-list-based. Unfortunately within Forms the possibilities are limited. So I thought of doing an excel-list to sharepoint-list export with a workflow once a night to have the data sharepoint-list-based.
I tested it with an excel table with 10 colums x 500 rows.
Generally this is working:
Using Excel services to get data of first (second, third, etc) row, save it to a collection, loop through the collection, get data, create new item within sharepoint-list.
But workflow is quiet slow. The first item in the sharepoint-list is generated immediately, but the next rows need 1-2 minutes each. Is that because of the loop??
Taking this speed into acount, it is not possible to work with a lot of Excel data, right?!
@mai-kel .....Are you using while loop or for loop?
I haven't worked much with query excel service but based on what I know, how about the below approach?