• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

GUI output to excel/access

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,

I am new to Java. I have taken a 8 wk class on Java where I learned to create a GUI where the info entered in the fields were written to a wordpad/notepad file. Does anyone have a guide on where the answers are collected in an excel or access database?

Thanks

Ross
 
Saloon Keeper
Posts: 10705
86
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows ChatGPT
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What "answers" are you referring to? Are you creating a ".txt" file that you later read with wordpad/notepad?

To read/write to excel you use the POI library. To read/write to an Access database you use JDBC.
 
Marshal
Posts: 79177
377
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to the Ranch

I am surprised you are using Access or Excel in an 8‑week course; those are usually advanced features which limit platform‑independence. There is a thing called POI which Apache make which allows Java® access to Microsoft Office® programs, however.
 
Ross Sutherland
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello

Can't be 100% sure as at work just now and can't test this but sure the below writes to a text file. And, I was wondering if it anyone had a guide(idiots) to write to an excel file for example.

you tube video even etc

Thanks

Ross

 
Saloon Keeper
Posts: 7585
176
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The POI web site has code examples and introductions. See the Quick Guide and the HOWTO pages at http://poi.apache.org/spreadsheet/index.html. Ready-made example code is in the SVN repository at https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic