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

Imekamilika Ilichapishwa Miaka 5 iliyopita Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

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

gui:

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

Environment:

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

Excel Java

Kitambulisho cha Mradi: #19039462

Kuhusu mradi

13 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

mudassirhasa

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 Zaidi

$30 USD kwa siku 3
(Maoni 0)
0.0
VnNorthStar

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 kwa siku 3
(Maoni 45)
4.7

13 wafanyakazi huru wanazabuni wastani wa $99 kwa kazi hii

RobustTechServ

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 Zaidi

$174 USD kwa siku 20
(Maoni 16)
7.2
RRajeshR

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 Zaidi

$111 USD kwa siku 3
(Maoni 47)
6.3
ashokdzpxq

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 Zaidi

$111 USD kwa siku 2
(Maoni 21)
5.6
sodiqa32

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 Zaidi

$30 USD kwa siku 1
(Maoni 23)
5.3
dynamitewebsol

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

$150 USD kwa siku 3
(Maoni 13)
5.3
indrakumar8768

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 Zaidi

$155 USD kwa siku 3
(Maoni 0)
0.0
ranastkmba

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. Zaidi

$30 USD kwa siku 3
(Maoni 0)
0.0
mahabub1400

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 > Zaidi

$35 USD kwa siku 3
(Maoni 0)
0.0