Excel merge with charts

2014-06-18 Thread Kadiyala, Srinivasa (US - Newton)
Good evening! We have need to merge MS xls and XLSX files having charts graphs in work sheets. When we have tried we could not do it. I would like to seek inputs from users of their experience in developing solution using POI for this kind of need. Thanks in advance. Naga Sent from my iPhone

How to use SXSSFWorkbook to write to existing template with cell formatting applied

2014-06-18 Thread leena808
I am using poi-3.10-FINAL-20140208.jar and trying to do the following: //Template.xlsx has no data but some cells are formatted to have Date, decimal format, certain fonts, etc Workbook workbook = new SXSSFWorkbook(new XSSFWorkbook(new FileInputStream("Template.xlsx"))); Sheet sheet = workbook.ge

What does CFHeader needRecalc flag do?(related to conditional formatting)

2014-06-18 Thread adamparore
Hello, I have a xlsx file in which Condition Formatting is implemented. When i open the xlsx the condition formatting rules are applied, but when i open the same xlsx using POI apis the condition formatting rules are not applied to the cells. Upon searching the internet i found that there is a fl