Færdiggjort

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

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

Evner: Excel, Java

Se mere: 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

Om arbejdsgiveren:
( 9 bedømmelser ) Groisy, France

Projekt ID: #19039462

Tildelt til:

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 Flere

$30 USD in 3 dage
(0 bedømmelser)
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 in 3 dage
(24 bedømmelser)
3.7

20 freelancere byder i gennemsnit $109 på dette job

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 Flere

$111 USD in 3 dage
(41 bedømmelser)
6.0
dynamitewebsol

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

$150 USD in 3 dage
(9 bedømmelser)
5.2
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 Flere

$174 USD in 20 dage
(2 bedømmelser)
5.2
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 Flere

$30 USD på 1 dag
(8 bedømmelser)
4.3
ChaoHan2018

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 Flere

$250 USD in 3 dage
(2 bedømmelser)
4.0
webanis

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 dage
(19 bedømmelser)
4.0
Hada36

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 Flere

$122 USD in 4 dage
(16 bedømmelser)
3.8
zhaohm7

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 på 1 dag
(5 bedømmelser)
3.4
arunpallayil

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 på 1 dag
(1 bedømmelse)
2.0
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 Flere

$111 USD in 2 dage
(3 bedømmelser)
2.0
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 Flere

$155 USD in 3 dage
(0 bedømmelser)
0.0
$155 USD in 3 dage
(0 bedømmelser)
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. Flere

$30 USD in 3 dage
(0 bedømmelser)
0.0
js72c

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 Flere

$100 USD in 3 dage
(1 bedømmelse)
0.0
smkhadem

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 dage
(0 bedømmelser)
0.0
$155 USD in 3 dage
(0 bedømmelser)
0.0
saeed0098

$35 USD

$35 USD in 4 dage
(0 bedømmelser)
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 > Flere

$35 USD in 3 dage
(0 bedømmelser)
0.0