All the existing sheets you want to populate should contain jxls markup in the template.
This is a restriction of the current jxls version.
Soon a new product will be released which will be much more flexible and powerful than the current jxls version.
--
Leo
Monday, April 9, 2012, 7:23:43 PM, you wrote:
| Hello, I am new to jxls. I have been playing around with it. Initially I needed to create sheets with charts and tried to use your code on the site, it created new sheets, but was unable to clone the template sheet which has a chart object. I discovered that this is a limitation due to Apache POI, it cannot copy charts. With another api, I create a workbook with multiple-sheets and each sheet has a chart object. Now I need the jxls to populate ranges in each sheet. My question is: ***************** How do I populate a workbook with existing sheets? *********************** I looked at the method : Transformer, but my understanding is the parameter "sheetNames" will create new sheets. How does one pass existing worksheets? transformer.transformMultipleSheetsList(inputStream, maps, sheetNames, "map", new HashMap(), 0); Hope someone can help me. Really appreciate the help. Paul |
------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________ jXLS-user mailing list jXLS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jxls-user
