CONTENTS
- DESCRIPTION
- SYNOPSIS
- EXAMPLES
- WORKBOOK METHOD
- WORKSHEET METHOD
- PAGE SET-UP METHOD
- CELL FORMATTING
- FORMAT METHODS
- COLORS IN EXCEL
- DATES AND TIME IN EXCEL
- OUTLINES AND GROUPING IN EXCEL
- DATA VALIDATION IN EXCEL
- CONDITIONAL FORMATTING IN EXCEL
- SPARKLINES IN EXCEL
- TABLES IN EXCEL
- FORMURAS AND FUNCTIONS IN EXCEL
- CHART METHODS
- CHART FONTS
- CHART LAYOUT
- SHAPE
- COMPATIBILITY WITH WRITEEXCEL
a_simple
A simple demo of some of the features.
demo
A demo of some of the available features.
formats
All the available formatting on several worksheets.
regions
A simple example of multiple worksheets.
stats
Basic formulas and functions.
autofilter
Examples of worksheet autofilters.
array_formula
Examples of how to write array formulas.
chart_area
A demo of area style charts.
chart_bar
A demo of bar (vertical histogram) style charts.
chart_column
A demo of column (histogram) style charts.
chart_line
A demo of line style charts.
chart_pie
A demo of pie style charts.
chart_doughnut
A demo of doughnut style charts.
chart_radar
A demo of radar style charts.
chart_scatter
A demo of scatter style charts.
chart_secondary_axis
A demo of line chart with a secondary axis.
chart_stock
A demo of stock style charts.
chart_data_labels
A demo of an various Excel chart data label features.
chart_data_table
A demo of a chart with a data table on the axis.
chart_data_tools
A demo of charts with data highlighting options.
chart_clustered
A demo of charts with a clustered axis.
chart_styles
A demo of the available chart styles.
colors
A demo of the color palette and named colors.
comments1
Add comments to worksheet cells.
comments2
Add comments with advanced options.
condirional_format
Add conditional formats to a range of cells.
data_validate
An example of data validation and dropdown lists.
date_time
Write dates and times with write_date_time().
defined_name
Example of how to create defined names.
diag_border
A simple example of diagonal cell borders.
headers
Examples of worksheet headers and footers.
hide_row_col
Example of hiding rows and columns.
hide_sheet
Simple example of hiding a worksheet.
hyperlink1
Shows how to create web hyperlinks.
ignore_errors
An example of turning off worksheet cells errors/warnings.
indent
An example of cell indentation.
macros
An example of adding macros from an existing file.
merge1
A simple example of cell merging.
merge2
A simple example of cell merging with formatting.
merge3
Add hyperlinks to merged cells.
merge4
An advanced example of cell merging with formatting.
merge5
An advanced example of cell merging with formatting.
merge6
An example of merging with Unicode strings.
outline
An example of outlines and grouping.
outline_collapsed
An example of collapsed outlines.
panes
An example of how to create panes.
properties
Add document properties to a workbook.
protection
Example of cell locking and formula hiding.
rich_strings
Example of strings with multiple formats.
right_to_left
Change default sheet direction to right to left.
sales
An example of a simple sales spreadsheet.
shape1
Insert shapes in worksheet.
shape2
Insert shapes in worksheet. With properties.
shape3
Insert shapes in worksheet. Scaled.
shape4
Insert shapes in worksheet. With modification.
shape5
Insert shapes in worksheet. With connections.
shape6
Insert shapes in worksheet. With connections.
shape7
Insert shapes in worksheet. One to many connections.
shape8
Insert shapes in worksheet. One to many connections.
shape_all
Demo of all the available shape and connector types.
sparklines1
Simple sparklines demo.
sparklines2
Sparklines demo showing formatting options.
stats_ext
Same as stats.rb with external references.
stocks
Demonstrates conditional formatting.
stocks
Example of how to set the background image for a worksheet.
tab_colors
Example of how to set worksheet tab colors.
tables
Add Excel tables to a worksheet.
update_range_format_with_params
update formatting of the cell keeping cell contents and formatting.