Results 1 to 5 of 5
- 10-16-2007, 01:48 PM #1
Member
- Join Date
- Jul 2007
- Posts
- 5
- Rep Power
- 0
Reading data from Micrsoft excel and writing to notepad
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
- 10-17-2007, 03:21 AM #2
Member
- Join Date
- Jul 2007
- Posts
- 6
- Rep Power
- 0
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
- 06-18-2008, 01:24 PM #3
Member
- Join Date
- Jun 2008
- Posts
- 1
- Rep Power
- 0
Using POI
# 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
- 12-09-2008, 02:07 PM #4
Member
- Join Date
- Dec 2008
- Posts
- 1
- Rep Power
- 0
need code
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
- 01-29-2009, 09:12 AM #5
Member
- Join Date
- Jan 2009
- Posts
- 1
- Rep Power
- 0
Reading data from Oracle and save it in excel and send it to like attachment to mail.
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.
Similar Threads
-
writing to a excel file from java program
By priyankabhar in forum New To JavaReplies: 15Last Post: 01-17-2014, 01:39 PM -
Reading from EXCEL sheets
By javaplus in forum Advanced JavaReplies: 5Last Post: 07-13-2012, 05:46 AM -
Reading data form Excel using Jdbc (example)
By Java Tip in forum Java TipReplies: 0Last Post: 02-13-2008, 12:23 PM -
Reading excel worksheet
By Java Tip in forum Java TipReplies: 0Last Post: 02-13-2008, 12:19 PM -
Help with File reading and writing
By baltimore in forum New To JavaReplies: 1Last Post: 07-31-2007, 07:47 PM
Bookmarks