Re: XSSF for XLS

2016-11-13 Thread Dominik Stadler
Hi, If you use HSSF to write to a file named ".xlsx" you likely actually write it in .xls binary format, but Excel automatically detects this and opens it anyway. Try unzipping the .xlsx to see if it is actually a zipped-xml-format. You can use the base interfaces from the "org.apache.poi.ss.user

XSSF for XLS usinh multimap

2016-11-13 Thread Tripathi, Shiv Deepak
Hi All, I have a multimap: {Deepak=F1, F4, Ajinkya=F2, F5} In this F1,F4 are nothing but cell Adress. I want to write These values in given cell number like: F1 and F4 should have Deepak as value. Can you please let me know how can I write it. I am using XSSF. Thanks in ad

Re: XSSF for XLS usinh multimap

2016-11-13 Thread Javen O'Neal
Is this a question about how to iterate over a multimap or how to set a cell value in POI? Read the javadocs for the multimap implementation you are using. For example, org.apache.commons.collections4.MultiValuedMap is here: https://commons.apache.org/proper/commons-collections/apidocs/org/apache/