In Ruby versions 3.x (Ribbon interface) and later, this is accessed from Home | Send to | Excel

 

 

 

 

 

 

 

 

 

If you have thousands of tables to export, it is much quicker to 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 \Ruby\RubyToExcel.exe, located in the Ruby directory.

———————————————————————————————————-

In the beginning, Ruby used the Table (by cell) method.

 

 

 

 

 

 

This was accurate for most table formatting details, but proved to be slow on large tables.

Then there was the HTML method. This was much faster, but I could never solve the issue of redundant grid lines in multi-part cells.

 

 

 

 

 

 

 

 

 

And, worse, data such as “3 A” exports to Excel as 3:00 AM – Ugh!!!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Finally, I have seen Excel mess up a large table, at least once, which was legal HTML (because the same table opened in Internet Explorer correctly).

 

Tags:

Comments are closed