Automate Online Excel

[Puspender Tanwar]

Hi Ranchars,
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]

Check out https://coderanch.com/wiki/660373/Accessing-File-Formats for libraries which let you access excel files programatically

[Puspender Tanwar]

 

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?

[Knute Snortum]

POI is a really good library and should meet your needs.  I've used it several times and it always does the trick.

[Knute Snortum]

...Okay wait, Excel Online does not have a physical file locally, does it?

[Puspender Tanwar]

 

Knute Snortum wrote:...Okay wait, Excel Online does not have a physical file locally, does it?

No, it doesn't.  I Don't know what to call this exactly, but let me try -> Excel spreadsheet is hosted on sharepoint(office 365)

[Knute Snortum]

I don't think there is a Java solution to this.  All the development I see is with JavaScript or C# (SharePoint).

[Puspender Tanwar]

 

Knute Snortum wrote:I don't think there is a Java solution to this.  All the development I see is with JavaScript or C# (SharePoint).

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.

[Maneesh Godbole]

Maybe not. Looks like it supports JSON
https://graph.microsoft.io/en-us/docs/overview/call_api