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?:confused:

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

[anshu9352]

hi can i have the code for the same "reading data from excel and writing to notepad". actually i have tried a lot diff approaches but its not working. i would really appreciate if u could do that

[Arumugam]

Hi All,

I am doing 1 java mail attachment program, using back end Oracle which is working fine.My problem is we have to take the data from Oracle and save it in seprate excel and send it to the mail.So everytime we have to do like that automatically.

Is there any java code. I would appreciate if you help me

Regards
Arumugam.