Wrox Programmer Forums
|
Java Databases Discussion specific to working with Java Databases. For other Java topics, please see related Java forums. For database discussions not specific to Java, please see the Database category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Java Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 27th, 2003, 08:43 PM
Registered User
 
Join Date: Oct 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Java to Excel

I need to direct the output of my java program to an excel/notepad file.
I have the current o/p as follows..

No of visits to location ( 1,1) >> [0, 2, 4, 28, 2]
No of visits to location ( 1,2) >> [0, 4, 8, 9]
No of visits to location ( 1,3) >> [0, 82, 2]
No of visits to location ( 1,4) >> [0, 7, 10]
No of visits to location ( 1,5) >> [0, 17]
 and this goes on till location (10,10)

I want to save them in such a way that each value in particular location should be saved in each row. ...like:
( 1,1) ( 1,2) ....so on till (10,10)
0 0
2 4
4 8
28 9
2

can you help me get this done in java.
thanks.

 
Old March 16th, 2004, 06:39 AM
Registered User
 
Join Date: Sep 2003
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to yasir_lahham
Default

You can use POI (Poor Obfuscation Implementation), available from Apache, http://www.apache.org/dyn/closer.cgi/jakarta/poi
The POI project consists of APIs for manipulating various file formats based upon
Microsoft's OLE 2 Compound Document format using pure Java. In short, you can read and write MS Excel files using Java.

MHD Yasir Al-lahham





Similar Threads
Thread Thread Starter Forum Replies Last Post
Java should get Excel data when change in cell vipuldshah77 Pro JSP 1 August 29th, 2006 09:23 AM
reading excel file in java uttam.mca Pro JSP 1 July 14th, 2006 07:29 PM
POI EXCEL Y JAVA nespreyes J2EE 0 January 5th, 2006 11:22 AM
How to use Ms-Excel document in java kumar_kumar Java GUI 6 February 8th, 2005 05:21 PM
Parsing special characters from java to excel dracuella J2EE 0 May 19th, 2004 05:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.