Thanks very much for that Alan, and I am delighted you made such rapid progress. I will try to take a look tonight but failing that I will definately look through the code over the weekend as I am not working - dry stone walling at Belvoir Castle, what am I missing? Would much rather be paddling across in a dodgy plastic canoe to grub out Dock plants from a shingle topped island, oh the glamour!
Yours Mark B AR Williamson wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/Adding-Deleting-a-Column-tp25982828p26012233.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
