summaryrefslogtreecommitdiffhomepage
path: root/examples
AgeCommit message (Collapse)Author
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-08-17add uppercase file for image file checking testsRandy Morgan
2013-07-12WIP single/dual anchors for imagesRandy Morgan
2013-06-23added sparse array transposition with blocks for rows/cols switching and ↵Randy Morgan
some docs updates for release prep
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-28Refactored and renamed space preservationRandy Morgan
preserve_spaces has been moved to the workbook and renamed xml_space as that provides a good reference for people trying to figure out what it does, and let's the author specify space preservation for serializations using the shared strings table as well as the default inline serialization in cells.
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-12-04Created ios preview exampleRandy Morgan
This shows that shared_strings are required. Formula parsing is still outstanding. https://github.com/randym/axlsx/issues/149
2012-11-28Added example of overriding data typesRandy Morgan
2012-11-27Merge pull request #148 from alexrothenberg/pivot_tableRandy Morgan (@morgan_randy)
Create a simple Pivot Table
2012-11-27Merge pull request #147 from raiis/masterRandy Morgan (@morgan_randy)
Different left/right border style
2012-11-28Better way hot to override borders style.raiis
2012-11-27Can configure a pivot table when creating itAlex Rothenberg
see examples/pivot_table.rb wb.add_worksheet(:name => "Data Sheet") do |sheet| sheet.add_row ['Month', 'Year', 'Type', 'Sales', 'Region'] 30.times { sheet.add_row [month, year, type, sales, region] } sheet.add_pivot_table 'G4:L17', "A1:E31" do |pivot_table| pivot_table.rows = ['Month', 'Year'] pivot_table.columns = ['Type'] pivot_table.data = ['Sales'] pivot_table.pages = ['Region'] end end
2012-11-27Create a simple Pivot TableAlex Rothenberg
* an example can be run with `ruby examples/pivot_table.rb` * right now you cannot set options on the pivot table to make it useful (coming soon...)
2012-11-26Added individual border override options.raiis
2012-11-25moved sheet view example into examples.rbRandy 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-14Adding in a examples for conditionally formatted hyperlink color and a ↵Randy Morgan
financial report
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-09-14erm...Randy Morgan
2012-09-14example for date stylingRandy Morgan
2012-09-08examples for sprk2012Randy Morgan
2012-09-02update page_setup example with note regarding paper_sizeRandy Morgan
2012-09-02implement paper_size as at least some version of office ignore the paper ↵Randy Morgan
width and paper height page setup attributes. See PageSetup#paper_size for a list of sizes supported in the specification.
2012-08-31add example of removing tick labelsRandy Morgan
2012-08-30add none option for cat axis tick label positionRandy Morgan