You can save XLS files as an HTML spread sheet which you can then make dynamic with Rails and it will load back into Excel like a champ. I have done this before.
On a related topic, does anyone know about saving to the new xlsx or xlsm formats used by Excel 2007? I heard that they were supposed to be open standards .