Mark (and all),
Here is my first pass at the deleting of a column in a utility class:
http://pastebin.com/ff806298
I didn't want to go using functions that were not part of the Sheet/Row
interfaces, hence allowing me to straddle both formats.
I have ran it against a number of XLS files and it's doing what it
should without too much fuss.
A number of issues need to resolve; which isn't so much a programmatic
problem, more of a business-rule:
+ What to do with the formula in the moved columns?
+ Column breaks
+ Merged regions
I think by'n'large this will satisfy the vast majority of use cases,
were by you simply want to drop a column. After all, POI isn't meant to
replace the functionality of Excel, merely support the file format.
Any input etc always appreciated.
thanks
alan
http://alan.blog-city.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
