Tuesday, July 2, 2019

How to Turn a Manual Excel Workflow Into an Automated Web App Using the Java Client API

Automating Time-Expensive Tasks

My coworker in HR is doing a lot of interesting tasks that require both people skills and mental sharpness. Payroll is not one of those. It’s a boring, soul-crushing job of reading a spreadsheet row by row, copying and pasting the value to a payroll template, followed by a long time at the printer.

On top of that, there are a few people working on that spreadsheet, which increase the chances of missing a revision or using an outdated copy. Being a friendly neighborhood IT staff, I’ve offered to make a better workflow for this process. It could be done locally with some heavy-duty scripting, but there are a few people who need direct access to the sheet. On top of that, I didn’t want to sink too much time in this side-task. Not every data-processing tool needs to be a 6-week development job with a list of dependencies long as the arm.



from DZone.com Feed https://ift.tt/2NvNQAX

No comments:

Post a Comment