| Methods Summary |
|---|
| private java.lang.String | composeFormula(org.apache.poi.hssf.record.FormulaRecord record)
return org.apache.poi.hssf.model.FormulaParser.toFormulaString((Workbook)null,record.getParsedExpression());
|
| private java.lang.String | formulaString(org.apache.poi.hssf.record.FormulaRecord record)
StringBuffer formula = new StringBuffer("=");
int numptgs = record.getNumberOfExpressionTokens();
List tokens = record.getParsedExpression();
Ptg token;
StringBuffer buf = new StringBuffer();
for (int i=0;i<numptgs;i++) {
token = (Ptg) tokens.get(i);
buf.append( token.toFormulaString((Workbook)null));
switch (token.getPtgClass()) {
case Ptg.CLASS_REF :
buf.append("(R)");
break;
case Ptg.CLASS_VALUE :
buf.append("(V)");
break;
case Ptg.CLASS_ARRAY :
buf.append("(A)");
break;
}
buf.append(' ");
}
return buf.toString();
|
| private void | listFormula(org.apache.poi.hssf.record.FormulaRecord record)
String sep="~";
List tokens= record.getParsedExpression();
int numptgs = record.getNumberOfExpressionTokens();
Ptg token = null;
String name,numArg;
if (tokens != null) {
token = (Ptg) tokens.get(numptgs-1);
if (token instanceof FuncPtg) {
numArg = String.valueOf(numptgs-1);
} else { numArg = String.valueOf(-1);}
StringBuffer buf = new StringBuffer();
if (token instanceof ExpPtg) return;
buf.append(name=((OperationPtg) token).toFormulaString((Workbook)null));
buf.append(sep);
switch (token.getPtgClass()) {
case Ptg.CLASS_REF :
buf.append("REF");
break;
case Ptg.CLASS_VALUE :
buf.append("VALUE");
break;
case Ptg.CLASS_ARRAY :
buf.append("ARRAY");
break;
}
buf.append(sep);
if (numptgs>1) {
token = (Ptg) tokens.get(numptgs-2);
switch (token.getPtgClass()) {
case Ptg.CLASS_REF :
buf.append("REF");
break;
case Ptg.CLASS_VALUE :
buf.append("VALUE");
break;
case Ptg.CLASS_ARRAY :
buf.append("ARRAY");
break;
}
}else {
buf.append("VALUE");
}
buf.append(sep);
buf.append(numArg);
System.out.println(buf.toString());
} else {
System.out.println("#NAME");
}
|
| public static void | main(java.lang.String[] args)Method main
pass me a filename and I'll try and parse the formulas from it
if ((args == null) || (args.length >2 )
|| args[ 0 ].equals("--help"))
{
System.out.println(
"FormulaViewer .8 proof that the devil lies in the details (or just in BIFF8 files in general)");
System.out.println("usage: Give me a big fat file name");
} else if (args[0].equals("--listFunctions")) { // undocumented attribute to research functions!~
try {
FormulaViewer viewer = new FormulaViewer();
viewer.setFile(args[1]);
viewer.setList(true);
viewer.run();
}
catch (Exception e) {
System.out.println("Whoops!");
e.printStackTrace();
}
}
else
{
try
{
FormulaViewer viewer = new FormulaViewer();
viewer.setFile(args[ 0 ]);
viewer.run();
}
catch (Exception e)
{
System.out.println("Whoops!");
e.printStackTrace();
}
}
|
| public void | parseFormulaRecord(org.apache.poi.hssf.record.FormulaRecord record)Method parseFormulaRecord
System.out.println("==============================");
System.out.print("row = " + record.getRow());
System.out.println(", col = " + record.getColumn());
System.out.println("value = " + record.getValue());
System.out.print("xf = " + record.getXFIndex());
System.out.print(", number of ptgs = "
+ record.getNumberOfExpressionTokens());
System.out.println(", options = " + record.getOptions());
System.out.println("RPN List = "+formulaString(record));
System.out.println("Formula text = "+ composeFormula(record));
|
| public void | run()Method run
POIFSFileSystem fs =
new POIFSFileSystem(new FileInputStream(file));
List records =
RecordFactory
.createRecords(fs.createDocumentInputStream("Workbook"));
for (int k = 0; k < records.size(); k++)
{
Record record = ( Record ) records.get(k);
if (record.getSid() == FormulaRecord.sid)
{
if (list) {
listFormula((FormulaRecord) record);
}else {
parseFormulaRecord(( FormulaRecord ) record);
}
}
}
|
| public void | setFile(java.lang.String file)Method setFile
this.file = file;
|
| public void | setList(boolean list)
this.list=list;
|
