- 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
- COMPATIBILITY WITH WRITEEXCEL
The WriteXLSX rubygem can be used to create an Excel file in the 2007+ XLSX format.
The XLSX format is the Office Open XML (OOXML) format used by Excel 2007 and later.
Multiple worksheets can be added to a workbook and formatting can be applied to cells. Text, numbers, and formulas can be written to the cells. See Examples
This module cannot, as yet, be used to write to an existing Excel XLSX file.
WriteXLSX uses the same interface as the Writeexcel rubygem which produces an Excel file in binary XLS format. WriteXLSX supports all of the features of Writeexcel and in some cases has more functionality. For more details see “Compatibility with Writeexcel”.
The main advantage of the XLSX format over the XLS format is that it allows a larger number of rows and columns in a worksheet. The XLSX file format also produces much smaller files than the XLS file format.
To write a string, a formatted string, a number and a formula to the first worksheet in an Excel workbook called ruby.xlsx:
require 'write_xlsx' # Create a new Excel workbook workbook = WriteXLSX.new('ruby.xlsx') # Add a worksheet worksheet = workbook.add_worksheet # Add and define a format format = workbook.add_format format.set_bold format.set_color('red') format.set_align('center') # Write a formatted and unformatted string, row and column notation. col = row = 0 worksheet.write(row, col, 'Hi Excel!', format) worksheet.write(1, col, 'Hi Excel!') # Write a number and a formula using A1 notation worksheet.write('A3', 1.2345 ) worksheet.write('A4', '=SIN(PI()/4)')