Extract from Excel workbook (xls & xlsx) sheets range of cells as list of arrays (examples enclosed) using apache poi
$30-250 USD
Paid on delivery
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
Project ID: #19039462
About the project
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
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
13 freelancers are bidding on average $99 for this job
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
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
Hello, I read your requirements and understand very-well and ready to start work from now. Thank you
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
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
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
