aspose file tools*
The moose likes I/O and Streams and the fly likes Reading and Writing from Excel Spreadsheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "Reading and Writing from Excel Spreadsheet" Watch "Reading and Writing from Excel Spreadsheet" New topic
Author

Reading and Writing from Excel Spreadsheet

Kedarnath Bhagwat
Greenhorn

Joined: Oct 27, 2009
Posts: 20
Does somebody have a code to read from and write to Excel spreadsheet , the multiple columns of data .
I don't want to use any APIs .


kmbhagwat , SCJP 6
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19755
    
  20

Kedarnath Bhagwat wrote:I don't want to use any APIs .

Good luck reinventing the wheel then. Excel files are not easy to decipher, so I would be all too happy to use a third party library like Apache POI or JExcelAPI.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Kedarnath Bhagwat
Greenhorn

Joined: Oct 27, 2009
Posts: 20
I agree but I can't download or copy any code on my office machines .

Through JDBC connection I was even able to read and write the data .
But while writing , it was writing only one column.

So I thought of checking it in I/O section if there is a way .
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19755
    
  20

Kedarnath Bhagwat wrote:I agree but I can't download or copy any code on my office machines .

Why not? Is your system administrator so strict, or is there any other cause? Because like I said, using one of the existing libraries is going to help you out hundreds of times quicker.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading and Writing from Excel Spreadsheet