I want to edit a wellformatted excel file with ruby <p>I have a wellformatted excel file with a lot of macros and styling in it that I want to keep. Then i have this information I want to enter in the file. And I want to do it with ruby.</p> <p>I've tried roo and spreadsheet but they don't seem able to actually edit the file, just create a new one and loosing all the formattin in the process.</p> <p>It feels it should be simple to just edit the cells I want and save the file again but obviously it's more complex that I originally though(or I'm completely blind)</p> <p>Any help is appreciated.</p> <p>I'm learning ruby at the moment so that's why I would prefer a solution in ruby. If you know there are better suited laguages for this feel free to point me in the right direction and I'll check it out.</p> <p>Thanks in advance</p>