summaryrefslogtreecommitdiffhomepage
path: root/examples/example.rb
AgeCommit message (Collapse)Author
2020-09-11Restructure examples folder (#47)Zsolt Kozaroczy
Split examples into separate markdown files, each containing a description, sample code, and a screenshot of the resulting xlsx document. The script `generate.rb` is provided to actually generate the example documents by executing the sample code contained in the markdown files.
2019-12-20Add option to protect against formula injection attacks (#34)Gabriel Morcote
Caxlsx used to treat cell values beginning with an equal sign as formula by default. This can be dangerous if the input data is user generated or coming from other untrusted sources (see https://www.owasp.org/index.php/CSV_Injection for details). This commit adds a new option `escape_formulas` that can be used with `#add_row` and on instances of `Cell`. If set to true, cell values beginning with an equal sign are treated as normal strings (and will be displayed literally by Excel and co.)
2018-02-22chore(examples): include examples for customized locking and single print ↵randym
area specification with defined names
2018-02-15chore(examples): update data validation example to show raw list validationrandym
2015-07-04Merge branch 'example' of https://github.com/shifakhan/axlsx into ↵Jonathan Tron
shifakhan-example
2015-07-04Add test, fix example with tab color generation and fix a but due to a typoJonathan Tron
2015-05-23Option to change tab colorshifakhan
2015-05-04Added example of conditional formatting to match text in cellsshifakhan
2015-03-14Merge pull request #367 from axelson/patch-1Jurriaan Pruis
Add usage information to row_column_style example
2014-12-23Add usage information to row_column_style exampleJason Axelson
2014-10-15Added an example of row heightRishi
An example for changing the row height was missing. I thought it would make sense to have this in example as well. I needed the option and I have to look at the code to how to do it. I think it would help others.
2014-03-01Implemented RichText (multiple text runs)Jurriaan Pruis
and added multiline autowidth for both RichText and normal strings
2013-09-30Fix image anchor swapping and update readme.Randy Morgan
2013-09-29Adds examples for hiding sheets and workbook viewRandy Morgan
These examples show using hidden and very hidden to manage worksheet visibility as well as using the active_tab attribute of a workbook#view in order to specify which tab should be showing when the sheet is opened.
2013-09-27Fix example.rbpatorash
2013-09-27smooth line for line chartpatorash
2013-09-26extended examples and smooth lines for line chartRandy Morgan
2013-09-13Fixes for anchor swapping when adding images. - Two -> One swap still pending.Randy Morgan
2013-09-13Page Breaks - round oneRandy Morgan
This sets up the basic col and row break creation and serialization. You can specify either a string reference like "C7" or provide an Axlsx::Cell instance to specify the break point. Serialization is working cleanly but excel does not automatically render those breaks yet. You need to switch to page preview mode.
2013-07-12WIP single/dual anchors for imagesRandy Morgan
2013-04-28Show whitespace preservation in basic worksheet example.Randy Morgan
2013-04-28Updated mbcs example to use Arial Unicode MSRandy Morgan
This font may not be avilalbe in all renderes.
2013-04-18Added colors to examples for chartsRandy Morgan
Colors are required by OpenOffice, and LibreOffice, and syntactically correct regardless so we should be putting them in.
2013-04-04Added support for specifying between/notBetween formula in an array.Noel Peden
2013-03-17Fixed LineChart and refactored chart axes managementRandy Morgan
2013-03-16First run at 'hidden' comments WIPRandy Morgan
The xml is genrated correcty, but the comment still shows until it is selected once in the excel ui - so I must be missing something.
2013-02-04Completed missing docs and pre-release prepRandy Morgan
2013-01-10update outline_level_rows and outline_level_columns example.Randy Morgan
2012-12-15Added methods to simplify outlining with specsRandy Morgan
worksheet#outline_rows worksheet#outline_columns
2012-12-14Added formula_values options and specs for sheet format pr.Randy Morgan
This lets cache formula values and specify the default row height so that iOS and Max OSX previews render properly
2012-11-28Added example of overriding data typesRandy Morgan
2012-11-25Cleaned up examples directoryRandy Morgan
2012-11-25Cleaned up gemspec and removed pdf export exampleRandy Morgan
2012-11-25Patched serilalized_element_attributes to properly update value from called ↵Randy Morgan
block
2012-11-23Adds an example of header/footers.Adam Mueller
Also, header and footer content is now escaped. So that the user doesn't have to worry about that. Change-Id: Ib35b2eca6755d9b2d9974be25887734873d6e64a
2012-11-16Added sensible defaults for color scaleRandy Morgan
You can now use Axlsx::ColorScale.three_tone or Axlsx::ColorScale.two_tone to create pretty conditional formatting.
2012-11-15Added color scale initializationRandy Morgan
This lets us pass hashes defiing cfvo and colors for color scale conditional formatting with out the bs of hacking up the existing defaults.
2012-11-08fixed cell text run validation for u and familyRandy Morgan
2012-11-05added example for surrounding borderRandy Morgan
2012-10-18Updated examples so I can conditionally execute specific features.Randy Morgan
Just comment out what you dont want to generate.
2012-10-04Added example for hacking on specific border partsRandy Morgan
2012-09-30Updated auto_filter example to show how you can apply a specific value filterRandy Morgan
2012-09-26pre-release readme updates and more work on auto_filter preset valuesRandy Morgan
2012-09-14Patch for 1.8.7 and update table style example to use custom nameRandy Morgan
2012-08-23show how to do border edges in the exempts and update docs in stylesheetRandy Morgan
2012-08-22update examples to show correct custom format/hyperlink examplesRandy Morgan
2012-08-12add in-workbook hyperlink exampleRandy Morgan
2012-08-11add hyperlinks for worksheets #118Randy Morgan
2012-08-02fun with travisRandy Morgan
2012-07-31Adding in proper defined names so we can repeat header rows for each printed ↵Randy Morgan
page.