
Excel
Reading Excel in Ruby With Roo and Caxlsx for Writing
Read xlsx files in Ruby with Roo, including headers, typed cells, dates and streaming, and write workbooks with Caxlsx, with notes for Rails uploads.
7 min read
Tag
4 posts

Read xlsx files in Ruby with Roo, including headers, typed cells, dates and streaming, and write workbooks with Caxlsx, with notes for Rails uploads.

JSON.parse in Ruby 3.4 with json 2.9.1: symbolized keys, big numbers, NaN, comments that parse by default, max_nesting 100, create_additions and errors.

Parse XML in Ruby with Nokogiri: xpath and at_xpath, BigDecimal for money, namespaces, strict versus lenient parsing, the noent option and Reader streaming.

Parse CSV in Ruby 3.4 with the csv gem: the Gemfile LoadError, a numeric converter that read 02134 as 1116, nil versus empty strings, and timings.