Symbols '//' are used as default meta-characters for older _expression_ syntax.
You can set different meta-characters in the Configuration object like for example
Configuration config = new Configuration();
config.setMetaInfoToken("\\\\");
XLSTransformer transformer = new XLSTransformer( config );
...
The above code sets as meta-character symbols '\\'.
--
Leo
Friday, July 27, 2012, 10:50:34 PM, you wrote:
| Hello, I am trying to create an Excel table that contains entries of the form foo//bar. The text is getting truncated at the // , i.e., foo//bar shows up only as foo in the generated excel file. This happens only in 2-level loops, as shown in the program below. I have attached the input and generated xls files. The text after the // is missing in the second row of the generated file. Please tell me if there is some error in my code below, or if this looks like a bug in jxls? Thank you, Dilip import net.sf.jxls.transformer.XLSTransformer; import java.io.*; import java.util.*; public class TestJxls { public static void main(String[] args) { String templateFileName = "test.xls"; /* Input data is of the form: params = {"data" : [ ["aa1//bb1", "aa2//bb2"], ["cc1//dd1", "cc2//dd2"] ] } */ HashMap<String, ArrayList<ArrayList<String>>> params = new HashMap<String, ArrayList<ArrayList<String>>>(); ArrayList<ArrayList<String>> data = "" ArrayList<ArrayList<String>>(); params.put("data", data); ArrayList<String> row; row = new ArrayList<String>(); data.add(row); row.add("aa1//bb1"); row.add("aa2//bb2"); row = new ArrayList<String>(); data.add(row); row.add("cc1//dd1"); row.add("cc2//dd2"); try { XLSTransformer transformer = new XLSTransformer(); transformer.transformXLS(templateFileName, params, "test_generated.xls"); } catch (Exception e) { e.printStackTrace(); } } } I am using the following jar versions: jxls-reader-1.0-RC-1.jar jxls-core-1.0-RC-1.jar poi-3.7-20101029.jar poi-ooxml-3.7-20101029.jar jxls-reader-1.0-RC-1.jar commons-jexl-2.0.1.jar commons-digester-2.1.jar commons-beanutils-1.8.3.jar commons-collections-3.2.1.jar xmlbeans-2.3.0.jar poi-ooxml-schemas-3.7-20101029.jar ooxml-lib/dom4j-1.6.1.jar -- _________________________________________ Dilip Antony Joseph http://csgrad.blogspot.com http://www.marydilip.info |
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ jXLS-user mailing list jXLS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jxls-user
