This week's book giveaway is in the Beginning Java forum.
We're giving away four copies of Getting started with Java programming language and have Ashish Sarin & J Sharma on-line!
See this thread for details.
Win a copy of Getting started with Java programming language this week in the Beginning Java forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Automate Online Excel  RSS feed

 
Puspender Tanwar
Ranch Hand
Posts: 416
2
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.



onlinexal.JPG
[Thumbnail for onlinexal.JPG]
 
Maneesh Godbole
Bartender
Posts: 11445
18
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out https://coderanch.com/wiki/660373/Accessing-File-Formats for libraries which let you access excel files programatically
 
Puspender Tanwar
Ranch Hand
Posts: 416
2
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 3446
85
Chrome Eclipse IDE Java Postgres Database VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 3446
85
Chrome Eclipse IDE Java Postgres Database VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
...Okay wait, Excel Online does not have a physical file locally, does it?
 
Puspender Tanwar
Ranch Hand
Posts: 416
2
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)

url.JPG
[Thumbnail for url.JPG]
 
Knute Snortum
Sheriff
Posts: 3446
85
Chrome Eclipse IDE Java Postgres Database VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think there is a Java solution to this.  All the development I see is with JavaScript or C# (SharePoint).
 
Puspender Tanwar
Ranch Hand
Posts: 416
2
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 11445
18
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!