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
697
forks
source link
ScatterSeries :xData not honored in the excel #594
My code simply inserts a chart into an excel, but I noticed it inputs the :xData field as a string rather than an int, and it doesn't appear on the chart correctly because of that. The :yData seems fine, so I don't know why my :xData is {"100","1000"} rather than {100,1000}.
My code simply inserts a chart into an excel, but I noticed it inputs the :xData field as a string rather than an int, and it doesn't appear on the chart correctly because of that. The :yData seems fine, so I don't know why my :xData is {"100","1000"} rather than {100,1000}.
I've attached a screenshot to make it clearer.
@randym
Code snippet: @dbChart[index2].add_series :xData => [100,1000], :yData => [100,300], :title => "Faker" + index.to_s, :smooth => false
Thanks!