How to set cell style using SimpleXlsx::Serializer

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.