Win a copy of Transfer Learning for Natural Language Processing (MEAP) this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Paul Clapham
  • Devaka Cooray
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Knute Snortum
  • Liutauras Vilda
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Piet Souris
Bartenders:
  • salvin francis
  • Carey Brown
  • Frits Walraven

From excel with love....

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have an excel sheet with a hell of alot of vb code...
I made this a couple of years ago to score different darts games based on the rules of each game.
I would like to "port" this sheet from Microsoft dependant system to something a wee bit more universal. Feom what i can gater java is the obvious choice.
Now my question, would any of you guru type masters be willing to talk me (a complete lamen) through the proses? I now next to nothing about java.
I could upload or ahare the original excel if requested or required.
Please take pity on me...

Best regards
Joe.
 
Marshal
Posts: 25436
65
Eclipse IDE Firefox Browser MySQL Database
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your proposed solution looks to me like this:

1. Learn Java.

2. Write a Java application to score darts games.

3. Transfer your data from the spreadsheet to your new application.

Of course those three steps would overlap, but that's what you're looking at. And your Java learning would be led by the idea of writing that application, naturally. It looks like a reasonable project. And it doesn't necessarily matter whether the result is high quality or not because you're the one who is going to use the application -- am I right?

However the idea that you can learn Java via forum posts isn't a good idea. Online tutoring exists but not here. Most of our beginner questions here are like "I wrote this code and it doesn't work", followed by prompts to explain the problem and discussions on what to do. But if you don't have any code because you can't write it yet, then it's really hard to start a conversation. So I'd propose that you take a couple of months to try to learn basic Java. Then at least you might know the questions to ask.
 
Paul Clapham
Marshal
Posts: 25436
65
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And, welcome to the Ranch!
 
Bartender
Posts: 7065
65
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Paul Clapham wrote: So I'd propose that you take a couple of months to try to learn basic Java. Then at least you might know the questions to ask.


Many beginners are using the book "Head First Java". It is an older book but for leaning basic syntax and structure it is still applicable.
 
Saloon Keeper
Posts: 6377
158
Android Mac OS X Firefox Browser VI Editor Tomcat Server Safari
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Instead of an all-Java solution, you could also go with a hybrid solution: keep the data in the spreadsheet, and use a Java app to handle calculations and any possible changes based on those. That way you can replace VBS code with Java code, making it platform independent. You would use a spreadsheet app (like Libreoffice) to view and otherwise handle the data. That way, you wouldn't need to learn to write GUI code in Java as well as the basic language.

Alternatively, just convert the VBS code to whatever macro language Libreoffice has. That way you're no longer tied to MS Office.
 
Saloon Keeper
Posts: 21960
149
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Tim Moores wrote:Alternatively, just convert the VBS code to whatever macro language Libreoffice has. That way you're no longer tied to MS Office.



Actually, I'm pretty sure that LibreOffice can invoke Java if the user's system is setup properly. They did have a challenge replacing Visual Basic with something more open-source friendly.

Speaking of friendly open-source "Visual Basic", that's what Python has become. And I think there's a Python API for LibreOffice.
 
Sheriff
Posts: 7051
184
Eclipse IDE Postgres Database VI Editor Chrome Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are also the Oracle tutorials:

https://docs.oracle.com/javase/tutorial/

"Getting Started" is a good track to begin with.
 
Get me the mayor's office! I need to tell her about this tiny ad:
Two software engineers solve most of the world's problems in one K&R sized book
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic