Results 1 to 5 of 5
  1. #1
    abhishek.jain is offline Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    0

    Default 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

  2. #2
    liqdok is offline Member
    Join Date
    Jul 2007
    Posts
    6
    Rep Power
    0

    Default

    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

  3. #3
    abhiinreach is offline Member
    Join Date
    Jun 2008
    Posts
    1
    Rep Power
    0

    Default 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
    Attached Files Attached Files

  4. #4
    anshu9352 is offline Member
    Join Date
    Dec 2008
    Posts
    1
    Rep Power
    0

    Default 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

  5. #5
    Arumugam is offline Member
    Join Date
    Jan 2009
    Posts
    1
    Rep Power
    0

    Default 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

  1. writing to a excel file from java program
    By priyankabhar in forum New To Java
    Replies: 15
    Last Post: 01-17-2014, 01:39 PM
  2. Reading from EXCEL sheets
    By javaplus in forum Advanced Java
    Replies: 5
    Last Post: 07-13-2012, 05:46 AM
  3. Reading data form Excel using Jdbc (example)
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-13-2008, 12:23 PM
  4. Reading excel worksheet
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-13-2008, 12:19 PM
  5. Help with File reading and writing
    By baltimore in forum New To Java
    Replies: 1
    Last Post: 07-31-2007, 07:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •