Results 1 to 3 of 3
  1. #1
    litlmike is offline Member
    Join Date
    May 2016
    Posts
    6
    Rep Power
    0

    Default Read a spreadsheet to Array, in Excel

    I am new to Apache POI and JAVA. Can someone help me by giving me an example of how I would read an Excel sheet and store it as a multi-dimensional array?

    Thanks!

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    13,541
    Rep Power
    26

    Default Re: Read a spreadsheet to Array, in Excel

    What is it you are actually trying to achieve?
    You'd end up with an array of (potentially) different types stored in there, which is rarely a Good Thing.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  3. #3
    SurfMan's Avatar
    SurfMan is offline Godlike
    Join Date
    Nov 2012
    Location
    The Netherlands
    Posts
    1,989
    Rep Power
    8

    Default Re: Read a spreadsheet to Array, in Excel

    Go over these examples, they contain everything you need: https://poi.apache.org/spreadsheet/quick-guide.html
    "It's not fixed until you stop calling the problem weird and you understand what was wrong." - gimbal2 2013

Similar Threads

  1. Write a java program to fill an excel spreadsheet
    By tomflaherty in forum New To Java
    Replies: 3
    Last Post: 07-15-2014, 11:19 AM
  2. Replies: 0
    Last Post: 02-21-2014, 11:04 AM
  3. Array Spreadsheet error
    By dokunbam in forum New To Java
    Replies: 2
    Last Post: 10-09-2013, 04:19 PM
  4. generate excel spreadsheet
    By BigBear in forum Advanced Java
    Replies: 5
    Last Post: 04-27-2010, 02:44 PM
  5. Recovering data from Excel spreadsheet
    By Anubis in forum SWT / JFace
    Replies: 0
    Last Post: 12-17-2008, 08:28 PM

Tags for this Thread

Posting Permissions

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