how to import excel sheet data in any type of file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vikassawant
    New Member
    • Mar 2009
    • 27

    how to import excel sheet data in any type of file

    hi,
    It's very crazy problem.I want to import excel sheet data in to JTable but I can't find any solution.

    Actually what I want,suppose there are 7 rows and 5 columns in a table.If I select only 2 rows today and want to select remaining rows afterwords.For that need to save that table data. Now I am storing as a excel file but can't import that file when want to select remaining rows.

    Please tell if you have any other idea which perform same task.

    Heartily Thanks, In advance.

    Regards,
    Vikas Sawant.
  • elToro
    New Member
    • Mar 2009
    • 3

    #2
    I would recommend to store your excel file as a comma separated values file (.csv).

    This sort of text files can be easily parsed, as the values are delimited by commas.

    Comment

    • JosAH
      Recognized Expert MVP
      • Mar 2007
      • 11453

      #3
      ... or have a look at the Apache POI project.

      kind regards,

      Jos

      Comment

      Working...