How to make a particular row not editable using axlsx gem?

[dkumar431]

We are storing some internal information to a particular row of a excel. Those data are basically used for our validation when some one will upload the same excel back to our system and we do not want anyone to edit/update the content of that row.

I just want to disable that row, so that no one can edit the content.

[nsoseka]

In case anyone wants to do this, you can consider adding a list validation to the targeted cell and the only option can be the value of the rows you want. Its hackery but it should cut it