Is there a tool that will allow you to interact with a spreadsheet from a
shell? I am thinking of something where I can evaluate cells interactively,
set
values, drill into dependencies, etc. I am thinking of something like this:
shell> open c:/some/excel/file.xls
shell> get 'sheet1'!$B$12
value: 12.0
shell> set 'sheet1'!$B$12 15.0
value: 15.0
shell> evaluate 'sheet1'!$B15
evaluates to: 30.0
shell> expose 'sheet'!$B$15
cell: 30.0 = B12*2
I am sure there are other things that could be done. We have something like
this now, a tool we wrote, that will allow us to drill into a cell and follow
it's dependencies - the goal being to find places where POI's evaluation
differs
from Excel so we can fix the spreadsheet (because I am certain I trust POI more
than Excel). This tool is only a read-only tool, so I can't set values, I can
only drill into the dependency tree.
Has anyone seen anything like this?
Thanks,
Jon
