Table of Contents - rubyXL-git-ref-6002046-2.0.0 Documentation
Pages
- LICENSE
-
README
- rubyXL
- To Install:
- To Use:
- Parsing an existing workbook
- Creating a new Workbook
- Accessing
- Accessing a Worksheet
- Accessing Only the Values
- Accessing a Row (Array of Cells)
- Accessing a Cell
- Accessing Cell properties
- Accessing row properties
- Accessing column properties
- Table identification
- Modifying
- Adding 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
- RubyXL::Alignment
- RubyXL::BooleanValue
- RubyXL::Border
- RubyXL::BorderEdge
- RubyXL::Cell
- RubyXL::CellStyle
- RubyXL::Color
- RubyXL::ColumnRange
- RubyXL::DataValidation
- RubyXL::DefinedName
- RubyXL::Fill
- RubyXL::FloatValue
- RubyXL::Font
- RubyXL::Formula
- RubyXL::GenericStorage
- RubyXL::GradientFill
- RubyXL::IntegerValue
- RubyXL::LegacyDrawing
- RubyXL::MyZip
- RubyXL::NumFmt
- RubyXL::OOXMLObject
- RubyXL::Pane
- RubyXL::Parser
- RubyXL::PatternFill
- RubyXL::PrivateClass
- RubyXL::Protection
- RubyXL::Reference
- RubyXL::Selection
- RubyXL::SharedStrings
- RubyXL::SheetView
- RubyXL::Sqref
- RubyXL::Stop
- RubyXL::StringValue
- RubyXL::Workbook
- RubyXL::Worksheet
- RubyXL::Writer
- RubyXL::Writer::AppWriter
- RubyXL::Writer::CalcChainWriter
- RubyXL::Writer::ContentTypesWriter
- RubyXL::Writer::CoreWriter
- RubyXL::Writer::GenericWriter
- RubyXL::Writer::RootRelsWriter
- RubyXL::Writer::SharedStringsWriter
- RubyXL::Writer::StylesWriter
- RubyXL::Writer::ThemeWriter
- RubyXL::Writer::WorkbookRelsWriter
- RubyXL::Writer::WorkbookWriter
- RubyXL::Writer::WorksheetWriter
- RubyXL::XF
Methods
- ::accessorize — RubyXL::OOXMLObject
- ::attr_float — RubyXL::Parser
- ::attr_int — RubyXL::Parser
- ::attr_string — RubyXL::Parser
- ::define_attribute — RubyXL::OOXMLObject
- ::define_child_node — RubyXL::OOXMLObject
- ::define_element_name — RubyXL::OOXMLObject
- ::find — RubyXL::ColumnRange
- ::ind2ref — RubyXL::ColumnRange
- ::ind2ref — RubyXL::Reference
- ::insert_column — RubyXL::ColumnRange
- ::new — RubyXL::Cell
- ::new — RubyXL::GenericStorage
- ::new — RubyXL::ColumnRange
- ::new — RubyXL::OOXMLObject
- ::new — RubyXL::Reference
- ::new — RubyXL::Sqref
- ::new — RubyXL::Parser
- ::new — RubyXL::SharedStrings
- ::new — RubyXL::Workbook
- ::new — RubyXL::Worksheet
- ::new — RubyXL::Writer::GenericWriter
- ::new — RubyXL::Writer::WorksheetWriter
- ::obtain_class_variable — RubyXL::OOXMLObject
- ::parse — RubyXL::ColumnRange
- ::parse — RubyXL::OOXMLObject
- ::parse — RubyXL::Parser
- ::ref2ind — RubyXL::ColumnRange
- ::ref2ind — RubyXL::Reference
- ::set_countable — RubyXL::OOXMLObject
- ::update — RubyXL::ColumnRange
- ::validate_color — RubyXL::Color
- #== — RubyXL::BorderEdge
- #== — RubyXL::Border
- #== — RubyXL::XF
- #== — RubyXL::Font
- #== — RubyXL::Reference
- #[] — RubyXL::SharedStrings
- #[] — RubyXL::Workbook
- #[] — RubyXL::Worksheet
- #add — RubyXL::SharedStrings
- #add_cell — RubyXL::Worksheet
- #add_cell_obj — RubyXL::Worksheet
- #add_cell_style — RubyXL::Worksheet
- #add_to_zip — RubyXL::GenericStorage
- #add_to_zip — RubyXL::Writer::GenericWriter
- #add_worksheet — RubyXL::Workbook
- #base_date — RubyXL::Workbook
- #before_write_xml — RubyXL::Selection
- #binary — RubyXL::GenericStorage
- #border_bottom — RubyXL::Cell
- #border_diagonal — RubyXL::Cell
- #border_left — RubyXL::Cell
- #border_right — RubyXL::Cell
- #border_top — RubyXL::Cell
- #change_border — RubyXL::Cell
- #change_border_bottom — RubyXL::Cell
- #change_border_diagonal — RubyXL::Cell
- #change_border_left — RubyXL::Cell
- #change_border_right — RubyXL::Cell
- #change_border_top — RubyXL::Cell
- #change_column_alignment — RubyXL::Worksheet
- #change_column_bold — RubyXL::Worksheet
- #change_column_border — RubyXL::Worksheet
- #change_column_border_bottom — RubyXL::Worksheet
- #change_column_border_diagonal — RubyXL::Worksheet
- #change_column_border_left — RubyXL::Worksheet
- #change_column_border_right — RubyXL::Worksheet
- #change_column_border_top — RubyXL::Worksheet
- #change_column_fill — RubyXL::Worksheet
- #change_column_font — RubyXL::Worksheet
- #change_column_font_color — RubyXL::Worksheet
- #change_column_font_name — RubyXL::Worksheet
- #change_column_font_size — RubyXL::Worksheet
- #change_column_horizontal_alignment — RubyXL::Worksheet
- #change_column_italics — RubyXL::Worksheet
- #change_column_strikethrough — RubyXL::Worksheet
- #change_column_underline — RubyXL::Worksheet
- #change_column_vertical_alignment — RubyXL::Worksheet
- #change_column_width — RubyXL::Worksheet
- #change_contents — RubyXL::Cell
- #change_fill — RubyXL::Cell
- #change_font_bold — RubyXL::Cell
- #change_font_color — RubyXL::Cell
- #change_font_italics — RubyXL::Cell
- #change_font_name — RubyXL::Cell
- #change_font_size — RubyXL::Cell
- #change_font_strikethrough — RubyXL::Cell
- #change_font_underline — RubyXL::Cell
- #change_horizontal_alignment — RubyXL::Cell
- #change_row_alignment — RubyXL::Worksheet
- #change_row_bold — RubyXL::Worksheet
- #change_row_border — RubyXL::Worksheet
- #change_row_border_bottom — RubyXL::Worksheet
- #change_row_border_diagonal — RubyXL::Worksheet
- #change_row_border_left — RubyXL::Worksheet
- #change_row_border_right — RubyXL::Worksheet
- #change_row_border_top — RubyXL::Worksheet
- #change_row_fill — RubyXL::Worksheet
- #change_row_font — RubyXL::Worksheet
- #change_row_font_color — RubyXL::Worksheet
- #change_row_font_name — RubyXL::Worksheet
- #change_row_font_size — RubyXL::Worksheet
- #change_row_height — RubyXL::Worksheet
- #change_row_horizontal_alignment — RubyXL::Worksheet
- #change_row_italics — RubyXL::Worksheet
- #change_row_strikethrough — RubyXL::Worksheet
- #change_row_underline — RubyXL::Worksheet
- #change_row_vertical_alignment — RubyXL::Worksheet
- #change_text_wrap — RubyXL::Cell
- #change_vertical_alignment — RubyXL::Cell
- #column_font — RubyXL::Worksheet
- #cover? — RubyXL::Reference
- #data_only — RubyXL::Parser
- #date_num_fmt? — RubyXL::Workbook
- #date_to_num — RubyXL::Workbook
- #delete_cell — RubyXL::Worksheet
- #delete_column — RubyXL::ColumnRange
- #delete_column — RubyXL::Worksheet
- #delete_row — RubyXL::Worksheet
- #dup — RubyXL::OOXMLObject
- #each — RubyXL::Workbook
- #each — RubyXL::Worksheet
- #empty? — RubyXL::SharedStrings
- #ensure_cell_exists — RubyXL::Worksheet
- #extract_data — RubyXL::Worksheet
- #filepath — RubyXL::Writer::AppWriter
- #filepath — RubyXL::Writer::CalcChainWriter
- #filepath — RubyXL::Writer::ContentTypesWriter
- #filepath — RubyXL::Writer::CoreWriter
- #filepath — RubyXL::Writer::GenericWriter
- #filepath — RubyXL::Writer::RootRelsWriter
- #filepath — RubyXL::Writer::SharedStringsWriter
- #filepath — RubyXL::Writer::StylesWriter
- #filepath — RubyXL::Writer::ThemeWriter
- #filepath — RubyXL::Writer::WorkbookRelsWriter
- #filepath — RubyXL::Writer::WorkbookWriter
- #filepath — RubyXL::Writer::WorksheetWriter
- #fill_color — RubyXL::Cell
- #fill_shared_strings — RubyXL::Workbook
- #fill_styles — RubyXL::Workbook
- #find_first_row_with_content — RubyXL::Worksheet
- #find_xf — RubyXL::PrivateClass
- #first_col — RubyXL::Reference
- #first_row — RubyXL::Reference
- #font_color — RubyXL::Cell
- #font_name — RubyXL::Cell
- #font_size — RubyXL::Cell
- #font_switch — RubyXL::Worksheet
- #get_border — RubyXL::Cell
- #get_cell_border — RubyXL::Cell
- #get_cell_font — RubyXL::Cell
- #get_cell_xf — RubyXL::Cell
- #get_col_style — RubyXL::Worksheet
- #get_col_xf — RubyXL::Worksheet
- #get_cols_style_index — RubyXL::Worksheet
- #get_column_alignment — RubyXL::Worksheet
- #get_column_border — RubyXL::Worksheet
- #get_column_border_bottom — RubyXL::Worksheet
- #get_column_border_diagonal — RubyXL::Worksheet
- #get_column_border_left — RubyXL::Worksheet
- #get_column_border_right — RubyXL::Worksheet
- #get_column_border_top — RubyXL::Worksheet
- #get_column_fill — RubyXL::Worksheet
- #get_column_font_color — RubyXL::Worksheet
- #get_column_font_name — RubyXL::Worksheet
- #get_column_font_size — RubyXL::Worksheet
- #get_column_horizontal_alignment — RubyXL::Worksheet
- #get_column_style_index — RubyXL::Worksheet
- #get_column_vertical_alignment — RubyXL::Worksheet
- #get_column_width — RubyXL::Worksheet
- #get_default_name — RubyXL::Worksheet
- #get_edge_style — RubyXL::Border
- #get_fill_color — RubyXL::Workbook
- #get_index — RubyXL::SharedStrings
- #get_name — RubyXL::Font
- #get_rgb_color — RubyXL::Font
- #get_row_alignment — RubyXL::Worksheet
- #get_row_border — RubyXL::Worksheet
- #get_row_border_bottom — RubyXL::Worksheet
- #get_row_border_diagonal — RubyXL::Worksheet
- #get_row_border_left — RubyXL::Worksheet
- #get_row_border_right — RubyXL::Worksheet
- #get_row_border_top — RubyXL::Worksheet
- #get_row_fill — RubyXL::Worksheet
- #get_row_font_color — RubyXL::Worksheet
- #get_row_font_name — RubyXL::Worksheet
- #get_row_font_size — RubyXL::Worksheet
- #get_row_height — RubyXL::Worksheet
- #get_row_horizontal_alignment — RubyXL::Worksheet
- #get_row_style — RubyXL::Worksheet
- #get_row_vertical_alignment — RubyXL::Worksheet
- #get_row_xf — RubyXL::Worksheet
- #get_size — RubyXL::Font
- #get_table — RubyXL::Worksheet
- #horizontal_alignment — RubyXL::Cell
- #include? — RubyXL::ColumnRange
- #insert_cell — RubyXL::Worksheet
- #insert_column — RubyXL::ColumnRange
- #insert_column — RubyXL::Worksheet
- #insert_row — RubyXL::Worksheet
- #inspect — RubyXL::Cell
- #inspect — RubyXL::Reference
- #is_bold — RubyXL::Font
- #is_bolded — RubyXL::Cell
- #is_column_bolded — RubyXL::Worksheet
- #is_column_italicized — RubyXL::Worksheet
- #is_column_struckthrough — RubyXL::Worksheet
- #is_column_underlined — RubyXL::Worksheet
- #is_date? — RubyXL::Cell
- #is_date_format? — RubyXL::Workbook
- #is_italic — RubyXL::Font
- #is_italicized — RubyXL::Cell
- #is_row_bolded — RubyXL::Worksheet
- #is_row_italicized — RubyXL::Worksheet
- #is_row_struckthrough — RubyXL::Worksheet
- #is_row_underlined — RubyXL::Worksheet
- #is_strikethrough — RubyXL::Font
- #is_struckthrough — RubyXL::Cell
- #is_underlined — RubyXL::Cell
- #is_underlined — RubyXL::Font
- #last_col — RubyXL::Reference
- #last_row — RubyXL::Reference
- #load_dir — RubyXL::GenericStorage
- #load_file — RubyXL::GenericStorage
- #merge_cells — RubyXL::Worksheet
- #modify_alignment — RubyXL::PrivateClass
- #modify_fill — RubyXL::PrivateClass
- #modify_text_wrap — RubyXL::PrivateClass
- #modify_xf — RubyXL::PrivateClass
- #num_fmts_by_id — RubyXL::Workbook
- #num_to_date — RubyXL::Workbook
- #obtain_class_variable — RubyXL::OOXMLObject
- #parse — RubyXL::Parser
- #parse_worksheet — RubyXL::Parser
- #prepare_attributes — RubyXL::OOXMLObject
- #register_new_border — RubyXL::Workbook
- #register_new_fill — RubyXL::Workbook
- #register_new_font — RubyXL::Workbook
- #register_new_xf — RubyXL::Workbook
- #render_xml — RubyXL::Writer::GenericWriter
- #row_font — RubyXL::Worksheet
- #set_bold — RubyXL::Font
- #set_edge_style — RubyXL::Border
- #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::Cell
- #to_s — RubyXL::Reference
- #to_s — RubyXL::Sqref
- #unzip — RubyXL::MyZip
- #update_font_references — RubyXL::Cell
- #validate_before_write — RubyXL::Workbook
- #validate_border — RubyXL::PrivateClass
- #validate_horizontal_alignment — RubyXL::PrivateClass
- #validate_nonnegative — RubyXL::PrivateClass
- #validate_text_wrap — RubyXL::PrivateClass
- #validate_vertical_alignment — RubyXL::PrivateClass
- #validate_workbook — RubyXL::Cell
- #validate_workbook — RubyXL::Worksheet
- #validate_worksheet — RubyXL::Cell
- #value — RubyXL::Cell
- #vertical_alignment — RubyXL::Cell
- #write — RubyXL::Workbook
- #write — RubyXL::Writer::AppWriter
- #write — RubyXL::Writer::CalcChainWriter
- #write — RubyXL::Writer::ContentTypesWriter
- #write — RubyXL::Writer::CoreWriter
- #write — RubyXL::Writer::RootRelsWriter
- #write — RubyXL::Writer::SharedStringsWriter
- #write — RubyXL::Writer::StylesWriter
- #write — RubyXL::Writer::ThemeWriter
- #write — RubyXL::Writer::WorkbookRelsWriter
- #write — RubyXL::Writer::WorkbookWriter
- #write — RubyXL::Writer::WorksheetWriter
- #write_xml — RubyXL::OOXMLObject