Migrate an Excel Binary Worksheet into an Azure APP/Function
Budget: $30 – $250 AUD
I Want to Migrate an Excel Binary Worksheet into an Azure APP/Function
We have an Excel Sheet that macros that runs code to do the following items.
1. Log into our UPS Shipping website.
2. Scrape all data and add it into a sharepoint list.
3. Update Information on the SharePoint list with any new Shipping information that is missing.
4. Scrape Additional information such as current status and delivery information
5. Add in filters and tasks.
a. Filter by - delivered (Not marked Complete), In Transit, No Movement, and out for delivery
b. Ability to manually fill in, Internal Ticket Number, Shipping added to ticket and Reason it was shipped in And then be able to mark it complete so that we can use that for historical information only and not clog up the rest of our screen with old information.
Currently the excel sheet needs to be opened in order to run these tasks.
We want to automate these tasks and then just view the data when we need it. Either in Excel or Some web based version of this such as PowerBI
We have an Excel Sheet that macros that runs code to do the following items.
1. Log into our UPS Shipping website.
2. Scrape all data and add it into a sharepoint list.
3. Update Information on the SharePoint list with any new Shipping information that is missing.
4. Scrape Additional information such as current status and delivery information
5. Add in filters and tasks.
a. Filter by - delivered (Not marked Complete), In Transit, No Movement, and out for delivery
b. Ability to manually fill in, Internal Ticket Number, Shipping added to ticket and Reason it was shipped in And then be able to mark it complete so that we can use that for historical information only and not clog up the rest of our screen with old information.
Currently the excel sheet needs to be opened in order to run these tasks.
We want to automate these tasks and then just view the data when we need it. Either in Excel or Some web based version of this such as PowerBI