View on GitHub

WriteXLSX

ruby gem for generating XLSX file.

Download this project as a .zip file Download this project as a tar.gz file

CONTENTS

a_simple

A simple demo of some of the features. Output from a_simple.rb

demo

A demo of some of the available features. Output from demo.rb

formats

All the available formatting on several worksheets. Output from formats.rb

regions

A simple example of multiple worksheets. Output from regions.rb

stats

Basic formulas and functions. Output from stats.rb

autofilter

Examples of worksheet autofilters. Output from autofilter.rb

array_formula

Examples of how to write array formulas. Output from array_formula.rb

chart_area

A demo of area style charts. Output from chart_area.rb

chart_bar

A demo of bar (vertical histogram) style charts. Output from chart_bar.rb

chart_column

A demo of column (histogram) style charts. Output from chart_column.rb

chart_line

A demo of line style charts. Output from chart_line.rb

chart_pie

A demo of pie style charts. Output from chart_pie.rb

chart_doughnut

A demo of doughnut style charts. Output from chart_doughnut.rb

chart_radar

A demo of radar style charts. Output from chart_radar.rb

chart_scatter

A demo of scatter style charts. Output from chart_scatter.rb

chart_secondary_axis

A demo of line chart with a secondary axis. Output from chart_secondary_axis.rb

chart_stock

A demo of stock style charts. Output from chart_stock.rb

chart_data_labels

A demo of an various Excel chart data label features. Output from chart_data_labels.rb

chart_data_table

A demo of a chart with a data table on the axis. Output from chart_data_table.rb

chart_data_tools

A demo of charts with data highlighting options. Output from chart_data_tools.rb

chart_clustered

A demo of charts with a clustered axis. Output from chart_clustered.rb

chart_styles

A demo of the available chart styles. Output from chart_styles.rb

colors

A demo of the color palette and named colors. Output from colors.rb

comments1

Add comments to worksheet cells. Output from comments1.rb

comments2

Add comments with advanced options. Output from comments2.rb

condirional_format

Add conditional formats to a range of cells. Output from conditional_format.rb

data_validate

An example of data validation and dropdown lists. Output from data_validate.rb

date_time

Write dates and times with write_date_time(). Output from date_time.rb

defined_name

Example of how to create defined names. Output from defined_name.rb

diag_border

A simple example of diagonal cell borders. Output from diag_border.rb

headers

Examples of worksheet headers and footers. Output from headers.rb

hide_row_col

Example of hiding rows and columns. Output from hide_row_col.rb

hide_sheet

Simple example of hiding a worksheet. Output from hide_sheet.rb

hyperlink1

Shows how to create web hyperlinks. Output from hyperlink1.rb

ignore_errors

An example of turning off worksheet cells errors/warnings. Output from ignore_errors.rb

indent

An example of cell indentation. Output from indent.rb

macros

An example of adding macros from an existing file. Output from macros.rb

merge1

A simple example of cell merging. Output from merge1.rb

merge2

A simple example of cell merging with formatting. Output from merge2.rb

merge3

Add hyperlinks to merged cells. Output from merge3.rb

merge4

An advanced example of cell merging with formatting. Output from merge4.rb

merge5

An advanced example of cell merging with formatting. Output from merge5.rb

merge6

An example of merging with Unicode strings. Output from merge6.rb

outline

An example of outlines and grouping. Output from outline.rb

outline_collapsed

An example of collapsed outlines. Output from outline_collapsed.rb

panes

An example of how to create panes. Output from panes.rb

properties

Add document properties to a workbook. Output from properties.rb

protection

Example of cell locking and formula hiding. Output from protection.rb

rich_strings

Example of strings with multiple formats. Output from rich_strings.rb

right_to_left

Change default sheet direction to right to left. Output from right_to_left.rb

sales

An example of a simple sales spreadsheet. Output from sales.rb

shape1

Insert shapes in worksheet. Output from shape1.rb

shape2

Insert shapes in worksheet. With properties. Output from shape2.rb

shape3

Insert shapes in worksheet. Scaled. Output from shape3.rb

shape4

Insert shapes in worksheet. With modification. Output from shape4.rb

shape5

Insert shapes in worksheet. With connections. Output from shape5.rb

shape6

Insert shapes in worksheet. With connections. Output from shape6.rb

shape7

Insert shapes in worksheet. One to many connections. Output from shape7.rb

shape8

Insert shapes in worksheet. One to many connections. Output from shape8.rb

shape_all

Demo of all the available shape and connector types. Output from shape_all.rb

sparklines1

Simple sparklines demo. Output from sparklines1.rb

sparklines2

Sparklines demo showing formatting options. Output from sparklines2.rb

stats_ext

Same as stats.rb with external references. Output from stats_ext.rb

stocks

Demonstrates conditional formatting. Output from stocks.rb

stocks

Example of how to set the background image for a worksheet. Output from background.rb

tab_colors

Example of how to set worksheet tab colors. Output from tab_colors.rb

tables

Add Excel tables to a worksheet. Output from tables.rb

update_range_format_with_params

update formatting of the cell keeping cell contents and formatting. Output from update_range_format_with_params.rb