Reading data from Micrsoft excel and writing to notepad
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:
Reading data from Oracle and save it in excel and send it to like attachment to mail.
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