xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going to load on your client's machine.
MIT License
2.62k
stars
695
forks
source link
change the data type when changing the value of a cell #634
What I do is create a row with data nil new_row = [nil, nil, nil]
to then change its value for another, I do it in the following way: sheet.rows ["line"]. cells ["column"]. value = X
the value "X" can be string, int, etc but it always enters it as a string