Modify specific cell value using Axlsx gem given the column number and row numer

Question

I am trying to use asxlx gem to write an excel sheet but I have failed miserably trying to access individual cell values..

For example for do I get the value of the cell 2 in column 2

How do I change the value of cell 10 in column 19 ??

Answer 1

You should be able to access the value of any given cell via standard index references.

A trivial example:

p = Axlsx::Package.new
ws = p.workbook.add_worksheet
ws.add_row [1, 2, 3, 4]

ws.rows[0].cells[1].value = 5

would set the value of the second cell in the first row to 5

Please note, however that axlsx is a sparse generator. You cannot arbitrarily set the value for a cell that has not been added to the sheet via add_row.