Hi,
Please try the new fix.
Aspose.Cells for Java v7.0.3.2We have added some new APIs for user custom parsers (a
bit different from what we have discussed but more flexible):
1. ICustomParser
This interface allows users to add their custom value parser for parsing
string values to other proper cell value object. Its methods:
1. java.lang.Object parseObject(java.lang.String
value)
Parses given string to proper value object.
2. java.lang.String getFormat()
Gets the formatting pattern for last invocation of
parseObject(java.lang.String).
2. TxtLoadOptions
public void
setPreferredParsers(com.aspose.cells.ICustomParser[]
parsers)
For the parameter “parsers”, just as we have discussed, parsers[0] is the
parser will be used for the first column in text template file, parsers[1] is
the parser will be used for the second column, ...etc. The last
one(parsers[parsers.length-1]) will be used for all other columns start from
parsers.length-1.
With those new APIs, it is simple for you to implement your own value
parser. Here is the example:
class MyParser0 implements ICustomParser
{
private java.text.Format[] formats;
private String[] patterns;
private java.text.ParsePosition parsePos = new
java.text.ParsePosition(0);
private int index;
public MyParser(java.text.Format[] formats, String[]
patterns)
{
this.formats = formats;
this.patterns = patterns;
}
public Object parseObject(String value)
{
index = -1;
final int pos = value.length();
for(int i=0; i<formats.length;
i++)
{
parsePos.setIndex(0);
Object v = formats[i].parseObject(value,
parsePos);
if(parsePos.getIndex() == pos)
{
index = i;
return v;
}
}
return null; //return null to let Cells component try
other built-in parsers to parse this value. To keep given value as string for
the cell, here can return the value itself
}
public String getFormat()
{
if(index > -1 && patterns != null &&
index < patterns.length)
{
return patterns[index];
}
return null;
}
}