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.