Table of Contents - rubyXL 3.0.0
Pages
-
README
- rubyXL
- To Install:
- To Use:
- Parsing an existing workbook
- Creating a new Workbook
- Accessing
- Accessing a Worksheet
- Accessing just the values
- Accessing a Row (Array of Cells)
- Accessing a Cell object
- Wrappers for accessing Cell properties
- Wrappers for accessing Row properties
- Accessing column properties
- Table identification
- Modifying
- Adding Worksheets
- Renaming Worksheets
- Adding Cells
- Changing Cells
- Changing Fonts
- Changing Fills
- Changing Borders
- Changing Alignment
- Horizontal
- Vertical
- Changing Row Height
- Changing Column Width
- Merging Cells
- Insert Row
- Insert Column
- Delete Row
- Delete Column
- Insert Cell
- Delete Cell
- Writing
- Miscellaneous
- For more information
- Contributing to rubyXL
- Copyright
Classes and Modules
- RubyXL::AExtension
- RubyXL::AExtensionStorageArea
- RubyXL::Alignment
- RubyXL::BooleanNode
- RubyXL::BooleanValue
- RubyXL::BorderEdge
- RubyXL::CalculationChain
- RubyXL::CalculationChainCell
- RubyXL::Cell
- RubyXL::CellStyle
- RubyXL::CellValue
- RubyXL::ChartsheetProperties
- RubyXL::ChartsheetProtection
- RubyXL::Color
- RubyXL::ColumnRange
- RubyXL::ColumnRanges
- RubyXL::Comment
- RubyXL::ContentTypeDefault
- RubyXL::ContentTypeOverride
- RubyXL::ContentTypes
- RubyXL::DataType
- RubyXL::DataValidation
- RubyXL::DateGroupItem
- RubyXL::DocumentPropertiesFile
- RubyXL::DrawingFile
- RubyXL::Extension
- RubyXL::ExtensionStorageArea
- RubyXL::FileSharing
- RubyXL::FileVersion
- RubyXL::FloatNode
- RubyXL::FloatValue
- RubyXL::Font
- RubyXL::Formula
- RubyXL::GenericStorageObject
- RubyXL::IntegerNode
- RubyXL::IntegerValue
- RubyXL::LegacyCell
- RubyXL::LegacyWorkbook
- RubyXL::LegacyWorksheet
- RubyXL::NumberFormat
- RubyXL::NumberFormats
- RubyXL::OOXMLObjectClassMethods
- RubyXL::OOXMLRelationshipsFile
- RubyXL::OutlineProperties
- RubyXL::PageSetupProperties
- RubyXL::Parser
- RubyXL::PrinterSettingsFile
- RubyXL::RID
- RubyXL::RawOOXML
- RubyXL::Reference
- RubyXL::Relationship
- RubyXL::RunProperties
- RubyXL::SharedStringsTable
- RubyXL::Sqref
- RubyXL::Stop
- RubyXL::StringNode
- RubyXL::StringNodeW3C
- RubyXL::StringValue
- RubyXL::Text
- RubyXL::Variant
- RubyXL::WebPublishingItem
- RubyXL::WorkbookProperties
- RubyXL::WorkbookRoot
- RubyXL::WorksheetProperties
Methods
- ::default — RubyXL::WorkbookRoot
- ::get_class_by_rel_type — RubyXL::OOXMLRelationshipsFile
- ::ind2ref — RubyXL::Reference
- ::load_relationship_file — RubyXL::OOXMLRelationshipsFile
- ::new — RubyXL::Parser
- ::new — RubyXL::GenericStorageObject
- ::new — RubyXL::Reference
- ::new — RubyXL::Sqref
- ::new — RubyXL::LegacyWorksheet
- ::new — RubyXL::LegacyWorkbook
- ::new — RubyXL::SharedStringsTable
- ::parse — RubyXL::AExtension
- ::parse — RubyXL::Parser
- ::parse — RubyXL::RawOOXML
- ::parse_file — RubyXL::GenericStorageObject
- ::parse_file — RubyXL::WorkbookRoot
- ::ref2ind — RubyXL::Reference
- ::save_order — RubyXL::ContentTypes
- ::save_order — RubyXL::OOXMLRelationshipsFile
- ::save_order — RubyXL::GenericStorageObject
- ::validate_color — RubyXL::Color
- ::xlsx_path — RubyXL::ContentTypes
- #== — RubyXL::Reference
- #== — RubyXL::Font
- #== — RubyXL::BorderEdge
- #[] — RubyXL::SharedStringsTable
- #[] — RubyXL::LegacyWorksheet
- #[] — RubyXL::LegacyWorkbook
- #add — RubyXL::SharedStringsTable
- #add_cell — RubyXL::LegacyWorksheet
- #add_override — RubyXL::ContentTypes
- #add_part_title — RubyXL::DocumentPropertiesFile
- #add_relationship — RubyXL::OOXMLRelationshipsFile
- #add_row — RubyXL::LegacyWorksheet
- #add_to_zip — RubyXL::GenericStorageObject
- #add_worksheet — RubyXL::LegacyWorkbook
- #attach_relationship — RubyXL::WorkbookRoot
- #attach_relationship — RubyXL::DrawingFile
- #before_write_xml — RubyXL::ColumnRanges
- #before_write_xml — RubyXL::Text
- #before_write_xml — RubyXL::DocumentPropertiesFile
- #before_write_xml — RubyXL::SharedStringsTable
- #before_write_xml — RubyXL::CellValue
- #before_write_xml — RubyXL::ContentTypes
- #border_bottom — RubyXL::LegacyCell
- #border_diagonal — RubyXL::LegacyCell
- #border_left — RubyXL::LegacyCell
- #border_right — RubyXL::LegacyCell
- #border_top — RubyXL::LegacyCell
- #borders — RubyXL::LegacyWorkbook
- #cell_xfs — RubyXL::LegacyWorkbook
- #change_border_bottom — RubyXL::LegacyCell
- #change_border_diagonal — RubyXL::LegacyCell
- #change_border_left — RubyXL::LegacyCell
- #change_border_right — RubyXL::LegacyCell
- #change_border_top — RubyXL::LegacyCell
- #change_column_bold — RubyXL::LegacyWorksheet
- #change_column_border_bottom — RubyXL::LegacyWorksheet
- #change_column_border_diagonal — RubyXL::LegacyWorksheet
- #change_column_border_left — RubyXL::LegacyWorksheet
- #change_column_border_right — RubyXL::LegacyWorksheet
- #change_column_border_top — RubyXL::LegacyWorksheet
- #change_column_fill — RubyXL::LegacyWorksheet
- #change_column_font_color — RubyXL::LegacyWorksheet
- #change_column_font_name — RubyXL::LegacyWorksheet
- #change_column_font_size — RubyXL::LegacyWorksheet
- #change_column_horizontal_alignment — RubyXL::LegacyWorksheet
- #change_column_italics — RubyXL::LegacyWorksheet
- #change_column_strikethrough — RubyXL::LegacyWorksheet
- #change_column_underline — RubyXL::LegacyWorksheet
- #change_column_vertical_alignment — RubyXL::LegacyWorksheet
- #change_column_width — RubyXL::LegacyWorksheet
- #change_column_width_raw — RubyXL::LegacyWorksheet
- #change_contents — RubyXL::LegacyCell
- #change_fill — RubyXL::LegacyCell
- #change_font_bold — RubyXL::LegacyCell
- #change_font_color — RubyXL::LegacyCell
- #change_font_italics — RubyXL::LegacyCell
- #change_font_name — RubyXL::LegacyCell
- #change_font_size — RubyXL::LegacyCell
- #change_font_strikethrough — RubyXL::LegacyCell
- #change_font_underline — RubyXL::LegacyCell
- #change_horizontal_alignment — RubyXL::LegacyCell
- #change_row_bold — RubyXL::LegacyWorksheet
- #change_row_border_bottom — RubyXL::LegacyWorksheet
- #change_row_border_diagonal — RubyXL::LegacyWorksheet
- #change_row_border_left — RubyXL::LegacyWorksheet
- #change_row_border_right — RubyXL::LegacyWorksheet
- #change_row_border_top — RubyXL::LegacyWorksheet
- #change_row_fill — RubyXL::LegacyWorksheet
- #change_row_font_color — RubyXL::LegacyWorksheet
- #change_row_font_name — RubyXL::LegacyWorksheet
- #change_row_font_size — RubyXL::LegacyWorksheet
- #change_row_height — RubyXL::LegacyWorksheet
- #change_row_horizontal_alignment — RubyXL::LegacyWorksheet
- #change_row_italics — RubyXL::LegacyWorksheet
- #change_row_strikethrough — RubyXL::LegacyWorksheet
- #change_row_underline — RubyXL::LegacyWorksheet
- #change_row_vertical_alignment — RubyXL::LegacyWorksheet
- #change_text_wrap — RubyXL::LegacyCell
- #change_vertical_alignment — RubyXL::LegacyCell
- #column — RubyXL::Cell
- #column= — RubyXL::Cell
- #cover? — RubyXL::Reference
- #date_to_num — RubyXL::LegacyWorkbook
- #define_attribute — RubyXL::OOXMLObjectClassMethods
- #define_child_node — RubyXL::OOXMLObjectClassMethods
- #define_element_name — RubyXL::OOXMLObjectClassMethods
- #delete_cell — RubyXL::LegacyWorksheet
- #delete_column — RubyXL::ColumnRange
- #delete_column — RubyXL::LegacyWorksheet
- #delete_row — RubyXL::LegacyWorksheet
- #each — RubyXL::LegacyWorkbook
- #each — RubyXL::LegacyWorksheet
- #empty? — RubyXL::SharedStringsTable
- #extract_data — RubyXL::LegacyWorksheet
- #fill_color — RubyXL::LegacyCell
- #fills — RubyXL::LegacyWorkbook
- #find — RubyXL::ColumnRanges
- #find_by_format_id — RubyXL::NumberFormats
- #find_by_rid — RubyXL::OOXMLRelationshipsFile
- #find_by_target — RubyXL::OOXMLRelationshipsFile
- #first_col — RubyXL::Reference
- #first_row — RubyXL::Reference
- #font_color — RubyXL::LegacyCell
- #font_name — RubyXL::LegacyCell
- #font_size — RubyXL::LegacyCell
- #fonts — RubyXL::LegacyWorkbook
- #get_column_border_bottom — RubyXL::LegacyWorksheet
- #get_column_border_diagonal — RubyXL::LegacyWorksheet
- #get_column_border_left — RubyXL::LegacyWorksheet
- #get_column_border_right — RubyXL::LegacyWorksheet
- #get_column_border_top — RubyXL::LegacyWorksheet
- #get_column_fill — RubyXL::LegacyWorksheet
- #get_column_font_color — RubyXL::LegacyWorksheet
- #get_column_font_name — RubyXL::LegacyWorksheet
- #get_column_font_size — RubyXL::LegacyWorksheet
- #get_column_horizontal_alignment — RubyXL::LegacyWorksheet
- #get_column_vertical_alignment — RubyXL::LegacyWorksheet
- #get_column_width — RubyXL::LegacyWorksheet
- #get_column_width_raw — RubyXL::LegacyWorksheet
- #get_fill_color — RubyXL::LegacyWorkbook
- #get_index — RubyXL::SharedStringsTable
- #get_name — RubyXL::Font
- #get_range — RubyXL::ColumnRanges
- #get_rgb_color — RubyXL::Font
- #get_row_border_bottom — RubyXL::LegacyWorksheet
- #get_row_border_diagonal — RubyXL::LegacyWorksheet
- #get_row_border_left — RubyXL::LegacyWorksheet
- #get_row_border_right — RubyXL::LegacyWorksheet
- #get_row_border_top — RubyXL::LegacyWorksheet
- #get_row_fill — RubyXL::LegacyWorksheet
- #get_row_font_color — RubyXL::LegacyWorksheet
- #get_row_font_name — RubyXL::LegacyWorksheet
- #get_row_font_size — RubyXL::LegacyWorksheet
- #get_row_height — RubyXL::LegacyWorksheet
- #get_row_horizontal_alignment — RubyXL::LegacyWorksheet
- #get_row_vertical_alignment — RubyXL::LegacyWorksheet
- #get_size — RubyXL::Font
- #get_table — RubyXL::LegacyWorksheet
- #horizontal_alignment — RubyXL::LegacyCell
- #include? — RubyXL::ColumnRange
- #index_in_collection — RubyXL::Cell
- #insert_cell — RubyXL::LegacyWorksheet
- #insert_column — RubyXL::ColumnRanges
- #insert_column — RubyXL::LegacyWorksheet
- #insert_column — RubyXL::ColumnRange
- #insert_row — RubyXL::LegacyWorksheet
- #inspect — RubyXL::Reference
- #inspect — RubyXL::LegacyCell
- #is_bold — RubyXL::Font
- #is_bolded — RubyXL::LegacyCell
- #is_column_bolded — RubyXL::LegacyWorksheet
- #is_column_italicized — RubyXL::LegacyWorksheet
- #is_column_struckthrough — RubyXL::LegacyWorksheet
- #is_column_underlined — RubyXL::LegacyWorksheet
- #is_date? — RubyXL::Cell
- #is_date_format? — RubyXL::NumberFormat
- #is_italic — RubyXL::Font
- #is_italicized — RubyXL::LegacyCell
- #is_row_bolded — RubyXL::LegacyWorksheet
- #is_row_italicized — RubyXL::LegacyWorksheet
- #is_row_struckthrough — RubyXL::LegacyWorksheet
- #is_row_underlined — RubyXL::LegacyWorksheet
- #is_strikethrough — RubyXL::Font
- #is_struckthrough — RubyXL::LegacyCell
- #is_underlined — RubyXL::Font
- #is_underlined — RubyXL::LegacyCell
- #last_col — RubyXL::Reference
- #last_row — RubyXL::Reference
- #load_related_files — RubyXL::OOXMLRelationshipsFile
- #merge_cells — RubyXL::LegacyWorksheet
- #modify_alignment — RubyXL::LegacyWorkbook
- #modify_border — RubyXL::LegacyWorkbook
- #modify_fill — RubyXL::LegacyWorkbook
- #modify_text_wrap — RubyXL::LegacyWorkbook
- #new_relationship — RubyXL::OOXMLRelationshipsFile
- #num_to_date — RubyXL::LegacyWorkbook
- #number_format — RubyXL::Cell
- #obtain_class_variable — RubyXL::OOXMLObjectClassMethods
- #parse — RubyXL::Parser
- #parse — RubyXL::OOXMLObjectClassMethods
- #raw_value — RubyXL::Cell
- #raw_value= — RubyXL::Cell
- #register_new_fill — RubyXL::LegacyWorkbook
- #register_new_font — RubyXL::LegacyWorkbook
- #register_new_xf — RubyXL::LegacyWorkbook
- #related_objects — RubyXL::WorkbookRoot
- #relationship_file_class — RubyXL::WorkbookRoot
- #relationship_file_class — RubyXL::DrawingFile
- #row — RubyXL::Cell
- #row= — RubyXL::Cell
- #set_bold — RubyXL::Font
- #set_countable — RubyXL::OOXMLObjectClassMethods
- #set_italic — RubyXL::Font
- #set_name — RubyXL::Font
- #set_rgb_color — RubyXL::Font
- #set_size — RubyXL::Font
- #set_strikethrough — RubyXL::Font
- #set_underline — RubyXL::Font
- #single_cell? — RubyXL::Reference
- #text_wrap — RubyXL::LegacyCell
- #to_s — RubyXL::Text
- #to_s — RubyXL::Reference
- #to_s — RubyXL::Sqref
- #value — RubyXL::Cell
- #vertical_alignment — RubyXL::LegacyCell
- #workbook — RubyXL::LegacyCell
- #write — RubyXL::LegacyWorkbook
- #write_xml — RubyXL::AExtension
- #write_xml — RubyXL::RawOOXML
- #xlsx_path — RubyXL::ContentTypes
- #xlsx_path — RubyXL::DocumentPropertiesFile
- #xlsx_path — RubyXL::SharedStringsTable
- #xlsx_path — RubyXL::CalculationChain
- #xlsx_path — RubyXL::OOXMLRelationshipsFile