Tamamlanmış

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

Beceriler: Excel, Java

Daha fazlasını gör: 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

İşveren Hakkında:
( 9 değerlendirme ) Groisy, France

Proje NO: #19039462

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
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

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(24 Değerlendirme)
3.7

Bu iş için 20 freelancer ortalamada $109 teklif veriyor

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 Daha Fazla

$111 USD in 3 gün içinde
(41 Değerlendirme)
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 gün içinde
(9 Değerlendirme)
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 Daha Fazla

$174 USD in 20 gün içinde
(2 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
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 Daha Fazla

$250 USD in 3 gün içinde
(2 Değerlendirme)
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 gün içinde
(19 Değerlendirme)
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 Daha Fazla

$122 USD in 4 gün içinde
(16 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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 Daha Fazla

$111 USD in 2 gün içinde
(3 Değerlendirme)
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 Daha Fazla

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
$155 USD in 3 gün içinde
(0 Değerlendirme)
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. Daha Fazla

$30 USD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$100 USD in 3 gün içinde
(1 Yorum)
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 gün içinde
(0 Değerlendirme)
0.0
$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
saeed0098

$35 USD

$35 USD in 4 gün içinde
(0 Değerlendirme)
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 > Daha Fazla

$35 USD in 3 gün içinde
(0 Değerlendirme)
0.0