On 2022-12-13 10:26 am, hmdne wrote:
If I can't read the Excel spreadsheet, then I can manually open it and write a csv You can use Roo to parse any common spreadsheet format: https://github.com/roo-rb/roo
In general, I agree with Roo as a recommendation because it has worked fine for us when using XLSX files. Just a couple of notes more: [1] If you find that reading/ writing an Excel file becomes too onerous and/ or slow, there are some options in the Java world that can be used from JRuby. I have a small post about connecting to a Java library from JRuby/ Ruby code. See: https://notepad.onghu.com/2021/jruby-using-apache-poi-to-generate-xlsx-files... [2] Also, Ruby works great using RubyInstaller2 natively on Windows. There is no real need to use WSL2 unless you prefer it for some reason :) If you explore that side, see: https://notepad.onghu.com/2022/ruby3.1-windows-day0-install-hello_world/ Good luck! Cheers, Mohit.