I’ve been learning as I go but i’m struggling on this one and wanted to see if there is a simple process that isn’t as crazy as what I’ve thought up before I try to do what I cam up with on my own.
My use case is read an excel file and each row gets entered into a web site as a record set. Think add user with LOTS of fields. And a few thousand users.
I want to be able to update the file as the process is running. Ideally we would update a ‘Status’ column in the file when a record is new, processing, completed, or failed.
So, How do I…
Open the excel file
Read the rows until we get the first ‘Status’ = ‘New’ row
Update the row’s status to 'Processing’
Do the web site actions
If completed (based on checks) set status to 'Completed’
If interrupted or error set status to 'Failed’
Do next row
Please keep in mind there are thousands of rows with nearly one hundred columns.
And I really like being able to reference column names. Example: row(“email”).ToString
From what I’ve been able to read so far I am thinking I may need to use SQL, but want to see if there is a reasonable excel solution.
Thanks for your time and suggestions!