poi-object-mapper
poi-object-mapper copied to clipboard
millij
Object mapper for Office formats - Excel files, Spreadsheets, etc.
Example: - In the excel at the end there are few calculation like total amount in the amount column and jst before that column in the last row it is...
``` package org.example; import io.github.millij.poi.ss.model.annotations.Sheet; import io.github.millij.poi.ss.model.annotations.SheetColumn; import io.github.millij.poi.ss.writer.SpreadsheetWriter; import java.io.File; import java.io.IOException; import java.util.Arrays; public class App { public static void main( String[] args ) throws IOException { Employee...
Hi We have a use case where we are trying to read a question bank via Excel. It has following fields: ``` Description List options Int correctOption List tags ```...
I came across an issue when reading, issue is there are lots of blank cells in my excel file, and this should not be the show stopper in my case....
I have 2 columns in my excel with column name "Addr line1" (one for source and one for dest address). how should i read them?
How can we change the headerRow value to another value instead of "0", because in my case header in the spreadsheet is at 3rd row, from 4th content starts
Hi, millij. I have a pojo, and it have BigDecimal field. But, if this field in excel is empty, that got a Exception of : ``` org.apache.commons.beanutils.ConversionException: No value specified...
I have a Integer column in an excel sheet. Case 1 : If the column is not present in the sheet, then the value of the column returned by poi-object-mapper...
Currently parsing Enum datatypes is not supported and it throws conversion exception for parsing Enum datatypes. Hence such fields are parsed as String and then converted into Enum. Can we...