Wanted to extract the items from the excel sheet.
only items (starting from col 13) and when yellow cell is present the category of items
given starting and ending row from user, iterate over column. put each row an object. during row processing: case 1: box in yellow is the category for rows ahead until the next yellow box. case 2: if no yellow box appears, needless to categorize, just put range of rows in object oriented format with the fields.
using apachi poi 3.15
So I can fit the excel in command line and load the input stream. From the input stream I can get the required sheet by name of index. Then set the iterator index to 13 and proceed next by next.
14 freelanceria on tarjonnut keskimäärin 33 $ tähän työhön
Hi, I am Java expert. I can use POI to extract data. Please contact me Relevant Skills and Experience Java, POI Proposed Milestones $25 USD - milestone
Hi i am interesting towok with u in this project i have exp in java and dealing with excel using apache poi Relevant Skills and Experience I have five years experience in java
I have worked on personal projects in Java to extract data from Excel, XML, JSON files Relevant Skills and Experience Java Proposed Milestones $35 USD - Extract data