In Ruby version 3.x (Ribbon interface) this is accessed from Home | Send to | Excel
If you have thousands of tables to export, use this method. It is as fast as current technology will allow, which is to say, many times faster than the HTML method to MS Office. Charts without axes nesting are also supported.
This module is written in C# (not C++, as is Ruby.exe) so it remains a stand-alone executable. You can run it in its own right as RubyRubyToExcel.exe.
In the beginning there was the Table (by cell) method.
This was accurate for most table formatting details, but woefully slow on large tables.
Then there was the HTML method. This is much faster, but I could never solve the issue of redundant grid lines in multi-part cells.
And, worse, things like 3 A export as 3:00 AM
Finally, at least once I have seen Excel mess up a large table, which was legal HTML (because the same table opened in Internet Explorer correctly).
The new approach (currently a stand-alone executable which talks to Ruby) addresses these issues, and additionally runs many times faster than the HTML method.
If you want to try it out, send an email to email@example.com.
This is tables only. I am currently working on charts to Excel, then I’ll do PowerPoint, and then Word. It’s going to take a while…