Extract from Excel workbook (xls & xlsx) sheets range of cells as list of arrays (examples enclosed) using apache poi

Example of excel workbook attached.

for each workbook sheet:

Extraction algorithm:

loop on all 1st column cells

- subsequent empty cells or cells starting with "#" are managed as range of cell separator

- when a cell is not empty:

. the first line is managed as title row

. subsequent rows as data rows

. until reaching the next empty/"#" cell (end of current range of cells)

Then reiterate with the next rangeMax number of rows per sheet: 64000

Range of cells content are saved in a: List<String[rows][columns]>

where rows is the number of rows in an extracted range of cells, and columns number of colums

In attached example range of cells to extract are identified by the same cell color background


simple trivial window with a "load" button to select the excel file to open and an editbox to display read ranges


eclipse/maven 3/java 8 (application migrated later to 11)/apache poi

Skills: Excel, Java

See more: excel workbook software, visual basic code extract excel data, convert excel workbook windows application, reading excel file in java tutorial, apache poi excel, how to read excel file in java using poi xssf, apache poi read excel, reading excel file in java without poi, how to write data in excel sheet using java poi, how to read cell value in excel using java poi, write excel file in java using poi example, convert excel workbook, convert excel workbook stand alone application, convert excel workbook standalone, extract statisticss multiple xls files, data excel workbook master workbook using vba, extract worksheet names excel workbook, extract worksheet name excel workbook, export data range excel workbook, excel, xls, xlsx, russian, spreadsheet

About the Employer:
( 9 reviews ) Groisy, France

Project ID: #19039462

Awarded to:


I have recently implemented similar type of project wherein I developed a Rest service for reading Excel file read using Apache poi JAR file and storing the the extracted Excel data in SQL Server database. So bidding More

$30 USD in 3 days
(0 Reviews)

Hi I’m ready for this project I’m an expert in Java I read your file and I’m sure I can do it perfectly Please give me a chance to work for you

$30 USD in 3 days
(24 Reviews)

20 freelancers are bidding on average $109 for this job


Hi, I am interested to work on your project. I can read the excel and apply the logic as per your requirement. I would like to know the exact output format of the process. Please provide me the sample output you are e More

$111 USD in 3 days
(41 Reviews)

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$150 USD in 3 days
(9 Reviews)

Hi there! My name is Orestes and I am a Software Engineer with specialty in Java/Spring. I represent a team of Software Engineers (so our 'technology' stack is actually quite big: Java, C#, Javascript, Python among ot More

$174 USD in 20 days
(2 Reviews)

I have gone through your project details "excel workbook "Looking for a candidate that is extremely familiar with the responsibilities associated with the role and can perform them confidently? Experience in the full More

$30 USD in 1 day
(8 Reviews)

Dear Recruiter, I have 6+ years highly skilled dedicated in-house team knowledgeable in: Graphic & Web-Design| Bootstrap| Responsive HTML5| PHP| Larevel| Angular |Wordpress: wooCommerce| OpenCart| Prestashop. I wil More

$250 USD in 3 days
(2 Reviews)

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

$72 USD in 3 days
(19 Reviews)

Hello, Thank you very much post your project. I am very much interested on your [login to view URL] my Experience and Expertise I believe and very confident that I will be able to handle your project efficiently and effect More

$122 USD in 4 days
(16 Reviews)

Hello Thanks for your posting. I've rich experiences in developing the java applications. Using poi jar I've developed the meta input system last time. Please let me discuss with more details through chat. Thanks.

$200 USD in 1 day
(5 Reviews)

Hi there, Thanks for the detailed explanation. I can finish this in 1 day. I have more than 18 years of experience in Java and more than 6 years as an architect. Thanks. -- Arun

$120 USD in 1 day
(1 Review)

Greeting! I am full time freelancer, I have 12 years of IT experience in development with skills - Java, Spring,Springboot,Documentum,Alfresco,JSF2 Primefaces,hibernate,Spring Security,JPA,Rest/SOAP,Spring AOP,Dock More

$111 USD in 2 days
(3 Reviews)

I have a wide experience of around 3 years in the data entry field. I am aware of the reputation of your company in the industry and am interested to join your team. It would be my privilege to join and serve your comp More

$155 USD in 3 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)

I am very much expert in data processing job and able to do any kind of data processing job efficiently and effectively. I am also an expert in typing related job. My typing speed is about 40 to 50 words per minute. More

$30 USD in 3 days
(0 Reviews)

Hello. I am very pleasure the opportunity to discuss this job with you. I am good expert of java field. I am a full time freelancer with skills and experience on PHP and PHP frameworks, JavaScript and JS frameworks More

$100 USD in 3 days
(1 Review)

i can work with office software such as PowerPoint and data processing and work with excel and word and PDF and change types of each data based on your need

$111 USD in 3 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)

$35 USD

$35 USD in 4 days
(0 Reviews)

My main purpose is to make my client happy.I am available for any kind or related work. I always finish my work immediately with 99% accuracy.I have excellent command in this section. >> Data Entry >> Excel > More

$35 USD in 3 days
(0 Reviews)