• Post Reply Bookmark Topic Watch Topic
  • New Topic

GUI output to excel/access  RSS feed

 
Ross Sutherland
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • 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
 
Carey Brown
Bartender
Posts: 3009
46
Eclipse IDE Firefox Browser Java MySQL Database VI Editor Windows
  • Mark post as helpful
  • send pies
  • 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.
 
Campbell Ritchie
Marshal
Posts: 55772
163
  • Mark post as helpful
  • send pies
  • 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
  • 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

 
Tim Moores
Saloon Keeper
Posts: 3893
91
  • Mark post as helpful
  • send pies
  • 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/.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!