loci.poi.hssf.dev

Class FormulaViewer

java.lang.Object

loci.poi.hssf.dev.FormulaViewer

public class FormulaViewer
extends Object

FormulaViewer - finds formulas in a BIFF8 file and attempts to read them/display data from them. Only works if Formulas are enabled in "RecordFactory"

Author:

andy, Avik

Field Summary

Fields

Modifier and Type	Field and Description
private String	file
private boolean	list

Constructor Summary

Constructors

Constructor and Description
FormulaViewer() Creates new FormulaViewer

Method Summary

Methods

Modifier and Type	Method and Description
private String	composeFormula(FormulaRecord record)
private String	formulaString(FormulaRecord record)
private void	listFormula(FormulaRecord record)
static void	main(String[] args) Method main pass me a filename and I'll try and parse the formulas from it
void	parseFormulaRecord(FormulaRecord record) Method parseFormulaRecord
void	run() Method run
void	setFile(String file) Method setFile
void	setList(boolean list)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

file

private String file

list

private boolean list

Constructor Detail

FormulaViewer

public FormulaViewer()

Creates new FormulaViewer

Method Detail

run

public void run()
         throws Exception

Method run

Throws:

Exception

listFormula

private void listFormula(FormulaRecord record)

parseFormulaRecord

public void parseFormulaRecord(FormulaRecord record)

Method parseFormulaRecord

Parameters:

record -

formulaString

private String formulaString(FormulaRecord record)

composeFormula

private String composeFormula(FormulaRecord record)

setFile

public void setFile(String file)

Method setFile

Parameters:

file -

setList

public void setList(boolean list)

main

public static void main(String[] args)

Method main pass me a filename and I'll try and parse the formulas from it

Parameters:

args - pass one argument with the filename or --help