Class: Xlsxrb::StreamWriter::WorksheetProxy

Inherits:
Object
  • Object
show all
Defined in:
lib/xlsxrb.rb,
sig/generated/xlsxrb.rbs

Overview

Proxy object yielded by the sheet method to prevent writing to inactive sheets.

Instance Method Summary collapse

Constructor Details

#initialize(writer, sheet_name) ⇒ WorksheetProxy

Returns a new instance of WorksheetProxy.

Parameters:

  • writer (Object)
  • sheet_name (Object) 


1744
1745
1746
1747
 
# File 'lib/xlsxrb.rb', line 1744

def initialize(writer, sheet_name)
  @writer = writer
  @sheet_name = sheet_name
end

Instance Method Details

#app_property ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Set app metadata property.

: (String | Symbol name, untyped value) -> void

Parameters:

  • name (String, Symbol) —

    Property name.

  • value (Object) —

    Property value.



2347
2348
2349
2350
2351
 
# File 'lib/xlsxrb.rb', line 2347

def app_property(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.app_property(...)
end

#auto_filter ⇒ void

This method returns an undefined value.

Set the auto-filter range on the sheet.

: (String ref) -> void

Examples:

s.auto_filter("A1:D100")

Parameters:

  • ref (String) —

    The cell range (e.g. "A1:D10").



1917
1918
1919
1920
1921
 
# File 'lib/xlsxrb.rb', line 1917

def auto_filter(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.auto_filter(...)
end

#chart {|chart_builder| ... } ⇒ void

This method returns an undefined value.

Add a chart to the sheet.

: (?Symbol | String? type, **untyped opts) ?{ (Xlsxrb::ChartBuilder) -> void } -> void

Examples:

s.chart(:bar) do |chart_builder|
  chart_builder.title("Quarterly Sales")
  chart_builder.series(values: "Sheet1!$B$2:$B$5", categories: "Sheet1!$A$2:$A$5", name: "Revenue")
end

Parameters:

  • type (Symbol, String, nil) —

    The chart type (:bar, :col, :line, :pie, :scatter, :area, :doughnut, :radar).

  • opts (Hash) —

    Additional chart options.

Yields:

  • (chart_builder)

Yield Parameters:



1880
1881
1882
1883
1884
 
# File 'lib/xlsxrb.rb', line 1880

def chart(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.chart(...)
end

#cleanup! ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block : () -> void



2019
2020
2021
2022
2023
 
# File 'lib/xlsxrb.rb', line 2019

def cleanup!(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.cleanup!(...)
end

#column ⇒ void

This method returns an undefined value.

Configure column width and properties.

: (Integer | String | Symbol col_index, ?width: Float | Integer | nil, ?hidden: bool, ?best_fit: bool, ?custom_width: bool, ?outline_level: Integer | nil, ?collapsed: bool) -> void

Examples:

Set column A width

s.column(0, width: 25.0)

Parameters:

  • col_index (Integer, String, Symbol) —

    0-based column index or letter (e.g. 0 or "A" or :A).

  • width (Float, Integer, nil) —

    Column width in characters.

  • hidden (Boolean) —

    Whether the column is hidden.

  • best_fit (Boolean) —

    Whether the column automatically fits content.

  • custom_width (Boolean) —

    Whether to flag as custom width.

  • outline_level (Integer, nil) —

    Grouping/outline level (0 - 7).

  • collapsed (Boolean) —

    Whether the outline group is collapsed.

  • width: (Float, Integer, nil)
  • hidden: (Boolean)
  • best_fit: (Boolean)
  • custom_width: (Boolean)
  • outline_level: (Integer, nil)
  • collapsed: (Boolean) 


1859
1860
1861
1862
1863
 
# File 'lib/xlsxrb.rb', line 1859

def column(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.column(...)
end

#comment ⇒ void

This method returns an undefined value.

Add a comment to a cell.

: (String | Integer cell, String text, ?author: String) -> void

Examples:

s.comment("A1", "Reviewed and approved", author: "Auditor")

Parameters:

  • cell (String, Integer) —

    The cell reference (e.g. "A1").

  • text (String) —

    The comment text.

  • author (String) —

    The author name.

  • author: (String) 


2037
2038
2039
2040
2041
 
# File 'lib/xlsxrb.rb', line 2037

def comment(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.comment(...)
end

#conditional_format ⇒ void

This method returns an undefined value.

Add conditional formatting to a range.

: (String range, ?type: String | Symbol, **untyped opts) -> void

Examples:

Highlight values greater than 100

s.conditional_format("A1:A10", type: "cellIs", operator: "greaterThan", formula: 100, style: :highlight)

Parameters:

  • range (String) —

    The cell range (e.g. "A1:A10").

  • type (String, Symbol) —

    Rule type ("cellIs", "colorScale", "dataBar", "expression").

  • opts (Hash) —

    Rule options.

  • type: (String, Symbol) 


1990
1991
1992
1993
1994
 
# File 'lib/xlsxrb.rb', line 1990

def conditional_format(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.conditional_format(...)
end

#core_property ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Set core metadata property.

: (String | Symbol name, untyped value) -> void

Parameters:

  • name (String, Symbol) —

    Property name.

  • value (Object) —

    Property value.



2225
2226
2227
2228
2229
 
# File 'lib/xlsxrb.rb', line 2225

def core_property(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.core_property(...)
end

#custom_property ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Set custom metadata property.

: (String | Symbol name, untyped value) -> void

Parameters:

  • name (String, Symbol) —

    Property name.

  • value (Object) —

    Property value.



2378
2379
2380
2381
2382
 
# File 'lib/xlsxrb.rb', line 2378

def custom_property(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.custom_property(...)
end

#defined_name ⇒ void

This method returns an undefined value.

Add a defined named range or formula.

: (String name, String formula, ?sheet_id: Integer | nil, ?hidden: bool) -> void

Examples:

s.defined_name("TaxRate", "0.10")

Parameters:

  • name (String) —

    The name.

  • formula (String) —

    The formula or range expression.

  • sheet_id (Integer, nil) —

    Optional sheet scope.

  • hidden (Boolean) —

    Whether the name is hidden.

  • sheet_id: (Integer, nil)
  • hidden: (Boolean) 


2123
2124
2125
2126
2127
 
# File 'lib/xlsxrb.rb', line 2123

def defined_name(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.defined_name(...)
end

#filter_column ⇒ void

This method returns an undefined value.

Set filter criteria for a column in the auto-filter.

: (Integer col_id, Array | Hash[Symbol, untyped] filter_values) -> void

Examples:

Simple values filter

s.filter_column(0, ["Active", "Pending"])

Custom filter specification

s.filter_column(0, { type: :filters, values: ["Data"] })

Parameters:

  • col_id (Integer) —

    0-based column index relative to auto-filter range.

  • filter_values (Array<String>, Hash) —

    Values or filter specification hash.



1936
1937
1938
1939
1940
 
# File 'lib/xlsxrb.rb', line 1936

def filter_column(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.filter_column(...)
end

#freeze_pane ⇒ void

This method returns an undefined value.

Freeze rows and/or columns for scrolling.

: (?row: Integer | nil, ?col: Integer | nil) -> void

Examples:

Freeze top row

s.freeze_pane(row: 1)

Freeze first column and top 2 rows

s.freeze_pane(row: 2, col: 1)

Parameters:

  • row (Integer, nil) —

    Number of rows to freeze.

  • col (Integer, nil) —

    Number of columns to freeze.

  • row: (Integer, nil)
  • col: (Integer, nil) 


2142
2143
2144
2145
2146
 
# File 'lib/xlsxrb.rb', line 2142

def freeze_pane(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.freeze_pane(...)
end

#header_footer ⇒ void

This method returns an undefined value.

Configure header and footer text for printing.

: (**untyped opts) -> void

Examples:

s.header_footer(odd_header: "&CConfidential", odd_footer: "&RPage &P of &N")

Parameters:

  • opts (Hash) —

    Header and footer specifications.



2296
2297
2298
2299
2300
 
# File 'lib/xlsxrb.rb', line 2296

def header_footer(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.header_footer(...)
end

#hyperlink ⇒ void

This method returns an undefined value.

Add a hyperlink to a cell.

: (String cell, ?String? url, ?display: String?, ?tooltip: String?, ?location: String?) -> void

Examples:

Positional URL

s.hyperlink("A1", "https://example.com", display: "Example")

Keyword location

s.hyperlink("A1", location: "https://example.com", tooltip: "Go to Example")

Parameters:

  • cell (String) —

    The cell reference (e.g. "A1").

  • url (String, nil) —

    The target URL or URI.

  • display (String, nil) —

    Display text for the link.

  • tooltip (String, nil) —

    Tooltip text when hovering.

  • location (String, nil) —

    Destination location / URL (keyword alternative).

  • display: (String, nil)
  • tooltip: (String, nil)
  • location: (String, nil) 


1902
1903
1904
1905
1906
 
# File 'lib/xlsxrb.rb', line 1902

def hyperlink(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.hyperlink(...)
end

#image ⇒ void

This method returns an undefined value.

Insert an image into the sheet.

: (String file_data, ?ext: String, ?from_col: Integer, ?from_row: Integer, ?to_col: Integer, ?to_row: Integer, **untyped opts) -> void

Examples:

s.image(File.read("logo.png"), ext: "png", from_col: 0, from_row: 0, to_col: 2, to_row: 3)

Parameters:

  • file_data (String) —

    Binary image data or file content.

  • ext (String) —

    Image extension ("png", "jpeg", etc.).

  • from_col (Integer) —

    Starting column index (0-based).

  • from_row (Integer) —

    Starting row index (0-based).

  • to_col (Integer) —

    Ending column index (0-based).

  • to_row (Integer) —

    Ending row index (0-based).

  • opts (Hash) —

    Additional anchor and sizing options.

  • ext: (String)
  • from_col: (Integer)
  • from_row: (Integer)
  • to_col: (Integer)
  • to_row: (Integer) 


2400
2401
2402
2403
2404
 
# File 'lib/xlsxrb.rb', line 2400

def image(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.image(...)
end

#internal_sheet_setup ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block : (*untyped args, **untyped kwargs) ?{ (*untyped) -> untyped } -> untyped

Parameters:

  • args (Object)
  • kwargs (Object) 


1814
1815
1816
1817
1818
 
# File 'lib/xlsxrb.rb', line 1814

def internal_sheet_setup(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.internal_sheet_setup(...)
end

#merge ⇒ void

This method returns an undefined value.

Merge a range of cells.

: (?String? range, ?row: Integer | nil, ?col_start: (Integer | String)?, ?col_end: (Integer | String)?, ?row_start: Integer | nil, ?row_end: Integer | nil) -> void

Examples:

Merge with cell reference string

s.merge("A1:C1")

Merge with coordinates

s.merge(row: 0, col_start: 0, col_end: 2)

Parameters:

  • range (String, nil) —

    The cell range (e.g. "A1:B2").

  • row (Integer, nil) —

    0-based row index.

  • col_start (Integer, String, nil) —

    0-based start column index or letter.

  • col_end (Integer, String, nil) —

    0-based end column index or letter.

  • row_start (Integer, nil) —

    0-based start row index.

  • row_end (Integer, nil) —

    0-based end row index.

  • row: (Integer, nil)
  • col_start: (Integer, String, nil)
  • col_end: (Integer, String, nil)
  • row_start: (Integer, nil)
  • row_end: (Integer, nil) 


1784
1785
1786
1787
1788
 
# File 'lib/xlsxrb.rb', line 1784

def merge(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.merge(...)
end

#page_break_col ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Add a vertical page break after the given column index.

: (Integer col_index) -> void

Examples:

s.page_break_col(5)

Parameters:

  • col_index (Integer) —

    0-based column index.



2452
2453
2454
2455
2456
 
# File 'lib/xlsxrb.rb', line 2452

def page_break_col(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.page_break_col(...)
end

#page_break_row ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Add a horizontal page break after the given row index.

: (Integer row_index) -> void

Examples:

s.page_break_row(25)

Parameters:

  • row_index (Integer) —

    0-based row index.



2434
2435
2436
2437
2438
 
# File 'lib/xlsxrb.rb', line 2434

def page_break_row(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.page_break_row(...)
end

#page_margins ⇒ void

This method returns an undefined value.

Configure page margins for printing.

: (?left: Float | nil, ?right: Float | nil, ?top: Float | nil, ?bottom: Float | nil, ?header: Float | nil, ?footer: Float | nil) -> void

Examples:

s.page_margins(left: 0.7, right: 0.7, top: 0.75, bottom: 0.75)

Parameters:

  • left (Float, nil) —

    Left margin in inches.

  • right (Float, nil) —

    Right margin in inches.

  • top (Float, nil) —

    Top margin in inches.

  • bottom (Float, nil) —

    Bottom margin in inches.

  • header (Float, nil) —

    Header margin in inches.

  • footer (Float, nil) —

    Footer margin in inches.

  • left: (Float, nil)
  • right: (Float, nil)
  • top: (Float, nil)
  • bottom: (Float, nil)
  • header: (Float, nil)
  • footer: (Float, nil) 


2264
2265
2266
2267
2268
 
# File 'lib/xlsxrb.rb', line 2264

def page_margins(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.page_margins(...)
end

#page_setup ⇒ void

This method returns an undefined value.

Configure page orientation, paper size, and print setup.

: (?orientation: (String | Symbol)?, ?paper_size: Integer | nil, **untyped opts) -> void

Examples:

Landscape A4

s.page_setup(orientation: "landscape", paper_size: 9)

Parameters:

  • orientation (String, Symbol, nil) —

    "portrait" or "landscape" (or :portrait, :landscape).

  • paper_size (Integer, nil) —

    Paper size index (e.g. 9 for A4, 1 for Letter).

  • opts (Hash) —

    Additional options (scale, fit_to_width, fit_to_height).

  • orientation: (String, Symbol, nil)
  • paper_size: (Integer, nil) 


2281
2282
2283
2284
2285
 
# File 'lib/xlsxrb.rb', line 2281

def page_setup(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.page_setup(...)
end

#pivot_table ⇒ void

This method returns an undefined value.

Add a Pivot Table to the sheet.

: (String source_ref, row_fields: untyped, data_fields: untyped, ?col_fields: untyped, ?dest_ref: String, ?name: String?, ?field_names: untyped, ?items: untyped, **untyped opts) -> void

Examples:

s.pivot_table("Sheet1!A1:D100", row_fields: ["Category"], data_fields: ["Amount"], dest_ref: "F1")

Parameters:

  • source_ref (String) —

    Source data range reference (e.g. "Sheet1!A1:D100").

  • row_fields (Array<String>) —

    Field names for rows.

  • data_fields (Array<String>) —

    Field names for data values.

  • col_fields (Array<String>) —

    Field names for columns.

  • dest_ref (String) —

    Target top-left cell reference (default: "E1").

  • name (String, nil) —

    Pivot table name.

  • field_names (Array<String>, nil) —

    Override field names.

  • items (Array, nil) —

    Items configuration.

  • opts (Hash) —

    Additional options.

  • row_fields: (Object)
  • data_fields: (Object)
  • col_fields: (Object)
  • dest_ref: (String)
  • name: (String, nil)
  • field_names: (Object)
  • items: (Object) 


2060
2061
2062
2063
2064
 
# File 'lib/xlsxrb.rb', line 2060

def pivot_table(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.pivot_table(...)
end

#print_area ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Set the print area range for the sheet.

: (String ref) -> void

Examples:

s.print_area("A1:G50")

Parameters:

  • ref (String) —

    Range reference.



2159
2160
2161
2162
2163
 
# File 'lib/xlsxrb.rb', line 2159

def print_area(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.print_area(...)
end

#print_options ⇒ void

This method returns an undefined value.

Configure print options (e.g. gridlines, headings).

: (Symbol | String name, untyped value) -> void

Examples:

s.print_options(:grid_lines, true)

Parameters:

  • name (Symbol, String) —

    Print option name.

  • value (Object) —

    Print option value.



2312
2313
2314
2315
2316
 
# File 'lib/xlsxrb.rb', line 2312

def print_options(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.print_options(...)
end

#print_titles ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Configure repeating title rows and columns for printing.

: (?rows: String?, ?cols: String?) -> void

Examples:

Repeat top 2 rows on every page

s.print_titles(rows: "1:2")

Parameters:

  • rows (String, nil) —

    Row range to repeat (e.g. "1:2").

  • cols (String, nil) —

    Column range to repeat (e.g. "A:B").

  • rows: (String, nil)
  • cols: (String, nil) 


2178
2179
2180
2181
2182
 
# File 'lib/xlsxrb.rb', line 2178

def print_titles(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.print_titles(...)
end

#properties ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Set document metadata properties (core, app, custom).

: (?core: Hash[untyped, untyped]?, ?app: Hash[untyped, untyped]?, ?custom: Hash[untyped, untyped]?) -> void

Examples:

s.properties(core: { title: "Report", creator: "App" })

Parameters:

  • core (Hash, nil) —

    Core properties (title, creator, subject, etc.).

  • app (Hash, nil) —

    App properties (company, manager).

  • custom (Hash, nil) —

    Custom properties.

  • core: (Hash[untyped, untyped], nil)
  • app: (Hash[untyped, untyped], nil)
  • custom: (Hash[untyped, untyped], nil) 


2331
2332
2333
2334
2335
 
# File 'lib/xlsxrb.rb', line 2331

def properties(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.properties(...)
end

#protect_sheet ⇒ void

This method returns an undefined value.

Protect the worksheet against modifications.

: (**untyped opts) -> void

Examples:

s.protect_sheet(password: "secret", select_locked_cells: true)

Parameters:

  • opts (Hash) —

    Protection options.



2363
2364
2365
2366
2367
 
# File 'lib/xlsxrb.rb', line 2363

def protect_sheet(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.protect_sheet(...)
end

#protect_workbook ⇒ void

This method returns an undefined value.

simplecov:disable Edge case / untested delegation block Protect the workbook structure.

: (**untyped opts) -> void

Parameters:

  • opts (Hash) —

    Protection options.



2209
2210
2211
2212
2213
 
# File 'lib/xlsxrb.rb', line 2209

def protect_workbook(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.protect_workbook(...)
end

#row ⇒ void

This method returns an undefined value.

Add a row to the active sheet.

: (Array | Hash[untyped, untyped] values, ?styles: untyped, ?height: Float | Integer | nil, ?hidden: bool, ?custom_height: bool, ?outline_level: Integer | nil) -> void

Examples:

Write an array of values

s.row(["Name", "Age", "City"])

Write with explicit column keys and styles

s.row({ A: "Header", C: 100 }, styles: { A: :bold })

Parameters:

  • values (Array, Hash) —

    The cell values (e.g. [1, 2, 3] or { A: 1, C: 3 }).

  • styles (String, Symbol, Array, Hash, nil) —

    Style names or hashes to apply.

  • height (Float, Integer, nil) —

    The row height in points (0 - 409).

  • hidden (Boolean) —

    Whether the row is hidden.

  • custom_height (Boolean) —

    Whether to flag as custom height.

  • outline_level (Integer, nil) —

    Grouping/outline level (0 - 7).

  • styles: (Object)
  • height: (Float, Integer, nil)
  • hidden: (Boolean)
  • custom_height: (Boolean)
  • outline_level: (Integer, nil) 


1838
1839
1840
1841
1842
 
# File 'lib/xlsxrb.rb', line 1838

def row(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.row(...)
end

#select_cell ⇒ void

This method returns an undefined value.

Set the active/selected cell on the sheet.

: (String active_cell, ?sqref: String?, ?pane: (String | Symbol)?) -> void

Examples:

s.select_cell("B5")
s.select_cell("A1", sqref: "A1:A2", pane: "topRight")

Parameters:

  • active_cell (String) —

    Cell reference (e.g. "A1").

  • sqref (String, nil) —

    Selection range.

  • pane (String, Symbol, nil) —

    Pane identifier.

  • sqref: (String, nil)
  • pane: (String, Symbol, nil) 


2244
2245
2246
2247
2248
 
# File 'lib/xlsxrb.rb', line 2244

def select_cell(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.select_cell(...)
end

#shape ⇒ void

This method returns an undefined value.

Add a drawing shape to the sheet.

: (?preset: String, ?text: String?, ?from_col: Integer, ?from_row: Integer, ?to_col: Integer, ?to_row: Integer, **untyped opts) -> void

Examples:

s.shape(preset: "ellipse", text: "Circle", from_col: 1, from_row: 1, to_col: 4, to_row: 5)

Parameters:

  • preset (String) —

    Preset shape type (e.g. "rect", "ellipse").

  • text (String, nil) —

    Shape label text.

  • from_col (Integer) —

    Starting column index (0-based).

  • from_row (Integer) —

    Starting row index (0-based).

  • to_col (Integer) —

    Ending column index (0-based).

  • to_row (Integer) —

    Ending row index (0-based).

  • opts (Hash) —

    Additional shape formatting options.

  • preset: (String)
  • text: (String, nil)
  • from_col: (Integer)
  • from_row: (Integer)
  • to_col: (Integer)
  • to_row: (Integer) 


1805
1806
1807
1808
1809
 
# File 'lib/xlsxrb.rb', line 1805

def shape(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.shape(...)
end

#sheet_properties ⇒ void

This method returns an undefined value.

Set sheet properties (e.g. tab color, page setup flags).

: (Symbol | String name, untyped value) -> void

Examples:

s.sheet_properties(:tab_color, "FF0000")

Parameters:

  • name (Symbol, String) —

    Property name.

  • value (Object) —

    Property value.



2105
2106
2107
2108
2109
 
# File 'lib/xlsxrb.rb', line 2105

def sheet_properties(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.sheet_properties(...)
end

#sheet_view ⇒ void

This method returns an undefined value.

Configure sheet view settings (zoom scale, grid lines visibility).

: (Symbol | String name, untyped value) -> void

Examples:

s.sheet_view(:show_grid_lines, false)
s.sheet_view(:zoom_scale, 120)

Parameters:

  • name (Symbol, String) —

    View setting name.

  • value (Object) —

    View setting value.



2417
2418
2419
2420
2421
 
# File 'lib/xlsxrb.rb', line 2417

def sheet_view(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.sheet_view(...)
end

#sort_state ⇒ void

This method returns an undefined value.

Configure sort state on a range.

: (String ref, Array[Hash[Symbol, untyped]] | Hash[Symbol, untyped] sort_conditions, **untyped opts) -> void

Examples:

s.sort_state("A1:A10", [{ ref: "A1:A10", descending: true }])

Parameters:

  • ref (String) —

    The range to sort.

  • sort_conditions (Array<Hash>, Hash) —

    Sort conditions array or options hash.

  • opts (Hash) —

    Additional sort options.



1953
1954
1955
1956
1957
 
# File 'lib/xlsxrb.rb', line 1953

def sort_state(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.sort_state(...)
end

#sparkline_group ⇒ void

This method returns an undefined value.

Add sparklines to the sheet.

: (sparklines: Array[Hash[Symbol, untyped]], ?type: String?, **untyped opts) -> void

Examples:

s.sparkline_group(sparklines: [{ data_ref: "A1:E1", location_ref: "F1" }], type: "line")

Parameters:

  • sparklines (Array<Hash>) —

    Array of { data_ref:, location_ref: } hashes.

  • type (String, nil) —

    "line" (default), "column", or "stacked".

  • opts (Hash) —

    Additional sparkline options.

  • sparklines: (Array[Hash[Symbol, untyped]])
  • type: (String, nil) 


2077
2078
2079
2080
2081
 
# File 'lib/xlsxrb.rb', line 2077

def sparkline_group(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.sparkline_group(...)
end

#split_pane ⇒ void

This method returns an undefined value.

Split sheet view into panes.

: (?x_split: Numeric | nil, ?y_split: Numeric | nil, ?top_left_cell: String?, ?active_pane: String?, ?state: String?) -> void

Parameters:

  • x_split (Numeric, nil) —

    Horizontal split position.

  • y_split (Numeric, nil) —

    Vertical split position.

  • top_left_cell (String, nil) —

    Top-left visible cell in bottom-right pane.

  • active_pane (String, nil) —

    Active pane identifier.

  • state (String, nil) —

    Split state.

  • x_split: (Numeric, nil)
  • y_split: (Numeric, nil)
  • top_left_cell: (String, nil)
  • active_pane: (String, nil)
  • state: (String, nil) 


2195
2196
2197
2198
2199
 
# File 'lib/xlsxrb.rb', line 2195

def split_pane(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.split_pane(...)
end

#style {|style_builder| ... } ⇒ Xlsxrb::StyleBuilder

Define or configure a named cell style.

: (String | Symbol name, **untyped opts) ?{ (Xlsxrb::StyleBuilder) -> void } -> Xlsxrb::StyleBuilder

Examples:

s.style(:header, bold: true, fill_color: "4F81BD", font_color: "FFFFFF")

Parameters:

  • name (String, Symbol) —

    The name of the style.

  • opts (Hash) —

    Style options (e.g. bold: true, fill_color: "FF0000").

Yields:

  • (style_builder)

Yield Parameters:

Returns:



1761
1762
1763
1764
1765
 
# File 'lib/xlsxrb.rb', line 1761

def style(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.style(...)
end

#table ⇒ void

This method returns an undefined value.

Add a formatted Excel Table to the sheet.

: (String ref, columns: untyped, ?name: String?, ?display_name: String?, ?style: String?, **untyped opts) -> void

Examples:

s.table("A1:C10", columns: ["ID", "Name", "Total"], name: "SalesTable", style: "TableStyleMedium9")

Parameters:

  • ref (String) —

    The cell range for the table (e.g. "A1:D10").

  • columns (Array<String>, Array<Hash>) —

    Column names or definitions.

  • name (String, nil) —

    Table name.

  • display_name (String, nil) —

    Display name.

  • style (String, nil) —

    Table style name.

  • opts (Hash) —

    Additional options.

  • columns: (Object)
  • name: (String, nil)
  • display_name: (String, nil)
  • style: (String, nil) 


2010
2011
2012
2013
2014
 
# File 'lib/xlsxrb.rb', line 2010

def table(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.table(...)
end

#validate_data ⇒ void

This method returns an undefined value.

Add data validation rules to a range.

: (String range, ?type: String | Symbol, **untyped opts) -> void

Examples:

Dropdown list validation

s.validate_data("B2:B100", type: "list", formula1: '"High,Medium,Low"')

Integer range validation

s.validate_data("C2:C100", type: "whole", operator: "between", formula1: 1, formula2: 100)

Parameters:

  • range (String) —

    The cell range (e.g. "B2:B10").

  • type (String, Symbol) —

    Validation type ("list", "whole", "decimal", "date", "time", "textLength", "custom").

  • opts (Hash) —

    Validation options.

  • type: (String, Symbol) 


1973
1974
1975
1976
1977
 
# File 'lib/xlsxrb.rb', line 1973

def validate_data(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.validate_data(...)
end

#workbook_property ⇒ void

This method returns an undefined value.

Set workbook-level properties.

: (**untyped opts) -> void

Parameters:

  • opts (Hash) —

    Workbook property options.



2089
2090
2091
2092
2093
 
# File 'lib/xlsxrb.rb', line 2089

def workbook_property(...)
  raise Error, "Sheet '' is no longer active. In streaming mode, you cannot write to a previous sheet." if @writer.current_sheet != @sheet_name

  @writer.workbook_property(...)
end