Reading data from Micrsoft excel and writing to notepad

[abhishek.jain]

Hi all,

I am writing a program to read data from excel and write data to notepad.
I am using POI Api

1.My first problem is that it is not reading the date properly.In cell, date is entered like this oct-07.When i click on a particular cell, function text box in Excel file shows the date as 10/23/2007. I want to copy this dd/mm/yyyy format to notepad but dont know how.

2. My second problem is that when i copy data to notepad , exponential sign(E) comes in the notepad due to large calculations in the excel file . I want the exact calculated value to bo copied in notepad and not the exponential sign.I dont know how to solve this problem?

Regards
Abhishek

[liqdok]

The POI does not have the caculation function,it can only read and write excel file.
This one maybe can help you,it can caculate excel functions and also can read,write excel file.

JAVA Excel Designner

[abhiinreach]

# Read an excel file from the local file system
# Process the file to create database script
# Log files created on every events of the file processing
# Using Apache POI api
# Full source code
# Support on I18N