1
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

rubyXLのconvenience_methods メソッド一覧

Last updated at Posted at 2023-02-02

公式の方でまとめられているものを書き出しています
https://github.com/weshatheleopard/rubyXL/tree/master/lib/rubyXL

rubyXL/convenience_methods/cell

  • change_contents
  • remove_formula
  • get_border
  • get_border_color
  • change_horizontal_alignment
  • change_vertical_alignment
  • change_text_wrap
  • change_shrink_to_fit
  • change_text_rotation
  • change_text_indent
  • change_border
  • change_border_color
  • is_italicized
  • is_bolded
  • is_underlined
  • is_struckthrough
  • font_name
  • font_size
  • font_color
  • fill_color
  • horizontal_alignment
  • vertical_alignment
  • text_wrap
  • text_rotation
  • text_indent
  • set_number_format
  • change_fill
  • change_font_name
  • change_font_size
  • change_font_color
  • change_font_italics
  • change_font_bold
  • change_font_underline
  • change_font_strikethrough
  • update_font_references
  • font_switch
  • add_hyperlink
  • add_shared_string

rubyXL/convenience_methods/color

  • get_rgb
  • to_hls
  • to_rgb
  • to_s
  • set_color
  • self.parse
  • apply_tint

rubyXL/convenience_methods/font

  • is_italic
  • is_bold
  • is_underlined
  • is_strikethrough
  • get_name
  • get_size
  • get_rgb_color
  • set_italic
  • set_bold
  • set_underline
  • set_strikethrough
  • set_name
  • set_size
  • set_rgb_color

rubyXL/convenience_methods/workbook

  • each
  • cell_xfs
  • fonts
  • fills
  • borders
  • get_fill_color
  • register_new_fill
  • register_new_font
  • register_new_xf
  • modify_alignment
  • modify_fill
  • modify_border
  • modify_border_color
  • password_hash
  • define_new_name
  • get_defined_name
  • title

rubyXL/convenience_methods/worksheet

  • insert_cell
  • delete_cell
  • insert_row
  • delete_row
  • insert_column
  • delete_column
  • get_row_style
  • get_row_fill
  • get_row_font_name
  • get_row_font_size
  • get_row_font_color
  • is_row_italicized
  • is_row_bolded
  • is_row_underlined
  • is_row_struckthrough
  • get_row_height
  • get_row_border
  • get_row_border_color
  • row_font
  • get_row_alignment
  • get_cols_style_index
  • get_column_font_name
  • get_column_font_size
  • get_column_font_color
  • is_column_italicized
  • is_column_bolded
  • is_column_underlined
  • is_column_struckthrough
  • get_column_width_raw
  • get_column_width
  • change_column_width_raw
  • change_column_width
  • get_col_style
  • get_column_fill
  • change_column_fill
  • get_column_border
  • get_column_border_color
  • column_font
  • get_column_alignment
  • change_row_horizontal_alignment
  • change_row_vertical_alignment
  • change_row_border
  • change_row_border_color
  • change_row_fill
  • change_row_font
  • change_row_font_name
  • change_row_font_size
  • change_row_font_color
  • change_row_italics
  • change_row_bold
  • change_row_underline
  • change_row_strikethrough
  • change_row_height
  • change_column_font
  • change_column_font_name
  • change_column_font_size
  • change_column_font_color
  • change_column_italics
  • change_column_bold
  • change_column_underline
  • change_column_strikethrough
  • change_column_horizontal_alignment
  • change_column_vertical_alignment
  • change_column_border
  • change_column_border_color
  • change_row_alignment
  • change_column_alignment
  • merge_cells
  • add_validation_list
1
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?