At my work I have a to keep records of all the supports I have provided to the clients of our company in an Online Excel sheet. Now being a java developer I find this very boring task and it also consumes my time as same data I have to copy paste 2-3 places. Can someone please tell how can I automate this using java.
Attached is the snapshot of my online excel sheet., we call it support tracker.
Under Support_Tracker we have to maintain all the supports we have provided to every project.
Then right to that(SalesForce_issue_tracer, Servicenow_issue_tracker) are the products for which we provide support. Now to these products sheet, I have to copy paste the data from Support_Tracker. I want to automate all this stuuf.
Please tell how can I achieve this.
Maneesh Godbole wrote:Check out https://coderanch.com/wiki/660373/Accessing-File-Formats for libraries which let you access excel files programatically
Hello Maneesh, as you can see I want to do all these stuff on Excel Online. Do Apache POI fulfil my need?
I guess Microsoft graph API is used for such stuffs. But the languages it support doesn't have java. I think it's time to learn python.