How to set cell style using SimpleXlsx::Serializer

Rails
1

Hello,
I have used the SimpleXlsx::Serializer to create .xlsx file in
ruby.
There are 2 questions:

  1. How to set format and style of cell through SimpleXlsx?
  2. When i set the hyperlink in cell it shows normal text as
    =HYPERLINK(“http://google.com”,“click here”) instead of Hyperlink. but
    when i manually change the cell format to All then it works as per
    requirement.