On a related thread, I had several email requests asking whether I knew how to read CSV files from multi-page worksheets and the like into Java. Nope, I didn't. Still don't. However, I was made aware yesterday of a tool, built on top of JNI, that allows COM programmers to integrate Java code with MS-style objects. It's called Jawin, it's open-source, and most important, free. Slaves to Microsoft(tm) Empire, rejoice! The most impressive thing to me, who will not code to the MS platform if I can help it, is the author's understanding of what the JNI (Java Native Interface) is and isn't good for. And I quote:
JNI is best when it is used to build a higher level marshalling layer that provides a transparent, or near transparent, mapping between Java objects and objects on a particular native platform.
Sage words indeed. By the way, if you are one of the very few that have emailed problematic source code to me with 'please fix' subject lines, please don't wait on a response. I understand frustration, not knowing what else to try, looming deadlines; they visit my hoouse too. I'm sympathetic, but trying to help as many people as I can by posting publicly.
Make visible what, without you, might perhaps never have been seen. - Robert Bresson