4 ms·
Awesome. I'm a junior trader at a major investment bank and I have to deal with Excel all the time... it would be great to be able to programmatically generate
by ctkrohn 19y ago
Awesome. I'm a junior trader at a major investment bank and I have to deal with Excel all the time... it would be great to be able to programmatically generate well-formed Excel files without having to deal with VBA, COM automation, or anything else. Now someone just has to write a nice Haskell library...
- tlrobinson 19y agoI'd probably use the new Office Open XML (Office 2007+) formats rather than the old binary formats.
- henning 19y agoYou could always whip up scripts that emit XML + XSL stylesheets to convert them to Office XML, yeah.
- henning 19y agoVB.NET (which now has static metaprogramming and closures) + COM automation isn't too bad in my experience. You could also use Python for COM. (I've found that when you set the application to be visible and each command is carried out visually, it's very impressive to non-programmers, especially ones who don't use macros.) Other than that, http://poi.apache.org/ http://poi.apache.org/ and a marginal language that targets the JVM is probably your best bet for now.
- wallflower 19y agoPoi has worked well for our projects where we have to export customer data to XLS (a commonly-requested feature that is almost like a checklist item) I find the file system within a file (OLE2 compound document) fascinating. I wonder who at Microsoft came up with that idea (or was it really an idea by technical committee)