WriteXLSX

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
  • AREA CHART
  • BAR CHART
  • COLUMN CHART
  • DOUGHNUT CHART
  • LINE CHART
  • PIE CHART
  • RADAR CHART
  • SCATTER CHART
  • STOCK CHART
• CHART FONTS
• CHART LAYOUT
• SHAPE
• COMPATIBILITY WITH WRITEEXCEL

WORKING WITH COLOURS

Throughout WriteXLSX colours can be specified using a Html style #RRGGBB value. For example with a Format object:

format.set_color('FF0000')

For backward compatibility a limited number of color names are supported:

format.set_color('red')

The color names supported are:

black
blue
brown
cyan
gray
green
lime
magenta
navy
orange
pink
purple
red
silver
white
yellow

colors.rb in the examples directory.