Module: Libxlsxwriter::WorksheetWrappers

Included in:
Worksheet
Defined in:
lib/fast_excel/binding/worksheet.rb

Overview

Fields:

:file

(FFI::Pointer(*FILE))

:optimize_tmpfile

(FFI::Pointer(*FILE))

:table

(TableRows)

:hyperlinks

(TableRows)

:array

(FFI::Pointer(**Cell))

:merged_ranges

(MergedRanges)

:selections

(Selections)

:image_data

(ImageData)

:chart_data

(ChartData)

:dim_rowmin

(Integer)

:dim_rowmax

(Integer)

:dim_colmin

(Integer)

:dim_colmax

(Integer)

:sst

(Sst)

:name

(String)

:quoted_name

(String)

:tmpdir

(String)

:index

(Integer)

:active

(Integer)

:selected

(Integer)

:hidden

(Integer)

:active_sheet

(FFI::Pointer(*Uint16T))

:first_sheet

(FFI::Pointer(*Uint16T))

:col_options

(FFI::Pointer(**ColOptions))

:col_options_max

(Integer)

:col_sizes

(FFI::Pointer(*Double))

:col_sizes_max

(Integer)

:col_formats

(FFI::Pointer(**Format))

:col_formats_max

(Integer)

:col_size_changed

(Integer)

:row_size_changed

(Integer)

:optimize

(Integer)

:optimize_row

(FFI::Pointer(*Row))

:fit_height

(Integer)

:fit_width

(Integer)

:horizontal_dpi

(Integer)

:hlink_count

(Integer)

:page_start

(Integer)

:print_scale

(Integer)

:rel_count

(Integer)

:vertical_dpi

(Integer)

:zoom

(Integer)

:filter_on

(Integer)

:fit_page

(Integer)

:hcenter

(Integer)

:orientation

(Integer)

:outline_changed

(Integer)

:outline_on

(Integer)

:page_order

(Integer)

:page_setup_changed

(Integer)

:page_view

(Integer)

:paper_size

(Integer)

:print_gridlines

(Integer)

:print_headers

(Integer)

:print_options_changed

(Integer)

:right_to_left

(Integer)

:screen_gridlines

(Integer)

:show_zeros

(Integer)

:vba_codename

(Integer)

:vcenter

(Integer)

:zoom_scale_normal

(Integer)

:tab_color

(Integer)

:margin_left

(Float)

:margin_right

(Float)

:margin_top

(Float)

:margin_bottom

(Float)

:margin_header

(Float)

:margin_footer

(Float)

:default_row_height

(Float)

:default_row_pixels

(Integer)

:default_col_pixels

(Integer)

:default_row_zeroed

(Integer)

:default_row_set

(Integer)

:header_footer_changed

(Integer)

:header

(Array<Integer>)

:footer

(Array<Integer>)

:repeat_rows

(RepeatRows)

:repeat_cols

(RepeatCols)

:print_area

(PrintArea)

:autofilter

(Autofilter)

:merged_range_count

(Integer)

:hbreaks

(FFI::Pointer(*RowT))

:vbreaks

(FFI::Pointer(*ColT))

:hbreaks_count

(Integer)

:vbreaks_count

(Integer)

:external_hyperlinks

(FFI::Pointer(*RelTuples))

:external_drawing_links

(FFI::Pointer(*RelTuples))

:drawing_links

(FFI::Pointer(*RelTuples))

:panes

(Panes)

:protection

(Protection)

:drawing

(Drawing)

:list_pointers

(WorksheetListPointers)

Instance Method Summary collapse

Instance Method Details

#activate ⇒ nil

Returns:

  • (nil) 


392
393
394
 
# File 'lib/fast_excel/binding/worksheet.rb', line 392

def activate()
  Libxlsxwriter.worksheet_activate(self)
end

#assemble_xml_file ⇒ nil

Returns:

  • (nil) 


631
632
633
 
# File 'lib/fast_excel/binding/worksheet.rb', line 631

def assemble_xml_file()
  Libxlsxwriter.worksheet_assemble_xml_file(self)
end

#autofilter(first_row, first_col, last_row, last_col) ⇒ Symbol from _enum_error_

Parameters:

  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)

Returns:



387
388
389
 
# File 'lib/fast_excel/binding/worksheet.rb', line 387

def autofilter(first_row, first_col, last_row, last_col)
  Libxlsxwriter.worksheet_autofilter(self, first_row, first_col, last_row, last_col)
end

#center_horizontally ⇒ nil

Returns:

  • (nil) 


539
540
541
 
# File 'lib/fast_excel/binding/worksheet.rb', line 539

def center_horizontally()
  Libxlsxwriter.worksheet_center_horizontally(self)
end

#center_vertically ⇒ nil

Returns:

  • (nil) 


544
545
546
 
# File 'lib/fast_excel/binding/worksheet.rb', line 544

def center_vertically()
  Libxlsxwriter.worksheet_center_vertically(self)
end

#find_row(row_num) ⇒ Row

Parameters:

  • row_num (Integer)

Returns:



658
659
660
 
# File 'lib/fast_excel/binding/worksheet.rb', line 658

def find_row(row_num)
  Row.new(Libxlsxwriter.worksheet_find_row(self, row_num))
end

#fit_to_pages(width, height) ⇒ nil

Parameters:

  • width (Integer)
  • height (Integer)

Returns:

  • (nil) 


579
580
581
 
# File 'lib/fast_excel/binding/worksheet.rb', line 579

def fit_to_pages(width, height)
  Libxlsxwriter.worksheet_fit_to_pages(self, width, height)
end

#free ⇒ nil

Returns:

  • (nil) 


626
627
628
 
# File 'lib/fast_excel/binding/worksheet.rb', line 626

def free()
  Libxlsxwriter.worksheet_free(self)
end

#freeze_panes(row, col) ⇒ nil

Parameters:

  • row (Integer)
  • col (Integer)

Returns:

  • (nil) 


414
415
416
 
# File 'lib/fast_excel/binding/worksheet.rb', line 414

def freeze_panes(row, col)
  Libxlsxwriter.worksheet_freeze_panes(self, row, col)
end

#freeze_panes_opt(first_row, first_col, top_row, left_col, type) ⇒ nil

Parameters:

  • first_row (Integer)
  • first_col (Integer)
  • top_row (Integer)
  • left_col (Integer)
  • type (Integer)

Returns:

  • (nil) 


431
432
433
 
# File 'lib/fast_excel/binding/worksheet.rb', line 431

def freeze_panes_opt(first_row, first_col, top_row, left_col, type)
  Libxlsxwriter.worksheet_freeze_panes_opt(self, first_row, first_col, top_row, left_col, type)
end

#gridlines(option) ⇒ nil

Parameters:

  • option (Integer)

Returns:

  • (nil) 


534
535
536
 
# File 'lib/fast_excel/binding/worksheet.rb', line 534

def gridlines(option)
  Libxlsxwriter.worksheet_gridlines(self, option)
end

#hide ⇒ nil

Returns:

  • (nil) 


402
403
404
 
# File 'lib/fast_excel/binding/worksheet.rb', line 402

def hide()
  Libxlsxwriter.worksheet_hide(self)
end

#hide_zero ⇒ nil

Returns:

  • (nil) 


601
602
603
 
# File 'lib/fast_excel/binding/worksheet.rb', line 601

def hide_zero()
  Libxlsxwriter.worksheet_hide_zero(self)
end

#insert_chart(row, col, chart) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • chart (Chart)

Returns:



358
359
360
 
# File 'lib/fast_excel/binding/worksheet.rb', line 358

def insert_chart(row, col, chart)
  Libxlsxwriter.worksheet_insert_chart(self, row, col, chart)
end

#insert_chart_opt(row, col, chart, user_options) ⇒ Symbol from _enum_error_

Parameters:

Returns:



367
368
369
 
# File 'lib/fast_excel/binding/worksheet.rb', line 367

def insert_chart_opt(row, col, chart, user_options)
  Libxlsxwriter.worksheet_insert_chart_opt(self, row, col, chart, user_options)
end

#insert_image(row, col, filename) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • filename (String)

Returns:



341
342
343
 
# File 'lib/fast_excel/binding/worksheet.rb', line 341

def insert_image(row, col, filename)
  Libxlsxwriter.worksheet_insert_image(self, row, col, filename)
end

#insert_image_opt(row, col, filename, options) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • filename (String)
  • options (ImageOptions)

Returns:



350
351
352
 
# File 'lib/fast_excel/binding/worksheet.rb', line 350

def insert_image_opt(row, col, filename, options)
  Libxlsxwriter.worksheet_insert_image_opt(self, row, col, filename, options)
end

#merge_range(first_row, first_col, last_row, last_col, string, format) ⇒ Symbol from _enum_error_

Parameters:

  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)
  • string (String)
  • format (Format)

Returns:



378
379
380
 
# File 'lib/fast_excel/binding/worksheet.rb', line 378

def merge_range(first_row, first_col, last_row, last_col, string, format)
  Libxlsxwriter.worksheet_merge_range(self, first_row, first_col, last_row, last_col, string, format)
end

#prepare_chart(chart_ref_id, drawing_id, image_data) ⇒ nil

Parameters:

  • chart_ref_id (Integer)
  • drawing_id (Integer)
  • image_data (ImageOptions)

Returns:

  • (nil) 


652
653
654
 
# File 'lib/fast_excel/binding/worksheet.rb', line 652

def prepare_chart(chart_ref_id, drawing_id, image_data)
  Libxlsxwriter.worksheet_prepare_chart(self, chart_ref_id, drawing_id, image_data)
end

#prepare_image(image_ref_id, drawing_id, image_data) ⇒ nil

Parameters:

  • image_ref_id (Integer)
  • drawing_id (Integer)
  • image_data (ImageOptions)

Returns:

  • (nil) 


644
645
646
 
# File 'lib/fast_excel/binding/worksheet.rb', line 644

def prepare_image(image_ref_id, drawing_id, image_data)
  Libxlsxwriter.worksheet_prepare_image(self, image_ref_id, drawing_id, image_data)
end

#print_across ⇒ nil

Returns:

  • (nil) 


522
523
524
 
# File 'lib/fast_excel/binding/worksheet.rb', line 522

def print_across()
  Libxlsxwriter.worksheet_print_across(self)
end

#print_area(first_row, first_col, last_row, last_col) ⇒ Symbol from _enum_error_

Parameters:

  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)

Returns:



572
573
574
 
# File 'lib/fast_excel/binding/worksheet.rb', line 572

def print_area(first_row, first_col, last_row, last_col)
  Libxlsxwriter.worksheet_print_area(self, first_row, first_col, last_row, last_col)
end

#print_row_col_headers ⇒ nil

Returns:

  • (nil) 


549
550
551
 
# File 'lib/fast_excel/binding/worksheet.rb', line 549

def print_row_col_headers()
  Libxlsxwriter.worksheet_print_row_col_headers(self)
end

#protect(password, options) ⇒ nil

Parameters:

Returns:

  • (nil) 


614
615
616
 
# File 'lib/fast_excel/binding/worksheet.rb', line 614

def protect(password, options)
  Libxlsxwriter.worksheet_protect(self, password, options)
end

#repeat_columns(first_col, last_col) ⇒ Symbol from _enum_error_

Parameters:

  • first_col (Integer)
  • last_col (Integer)

Returns:



563
564
565
 
# File 'lib/fast_excel/binding/worksheet.rb', line 563

def repeat_columns(first_col, last_col)
  Libxlsxwriter.worksheet_repeat_columns(self, first_col, last_col)
end

#repeat_rows(first_row, last_row) ⇒ Symbol from _enum_error_

Parameters:

  • first_row (Integer)
  • last_row (Integer)

Returns:



556
557
558
 
# File 'lib/fast_excel/binding/worksheet.rb', line 556

def repeat_rows(first_row, last_row)
  Libxlsxwriter.worksheet_repeat_rows(self, first_row, last_row)
end

#right_to_left ⇒ nil

Returns:

  • (nil) 


596
597
598
 
# File 'lib/fast_excel/binding/worksheet.rb', line 596

def right_to_left()
  Libxlsxwriter.worksheet_right_to_left(self)
end

#select ⇒ nil

Returns:

  • (nil) 


397
398
399
 
# File 'lib/fast_excel/binding/worksheet.rb', line 397

def select()
  Libxlsxwriter.worksheet_select(self)
end

#set_column(first_col, last_col, width, format) ⇒ Symbol from _enum_error_

Parameters:

  • first_col (Integer)
  • last_col (Integer)
  • width (Float)
  • format (Format)

Returns:



323
324
325
 
# File 'lib/fast_excel/binding/worksheet.rb', line 323

def set_column(first_col, last_col, width, format)
  Libxlsxwriter.worksheet_set_column(self, first_col, last_col, width, format)
end

#set_column_opt(first_col, last_col, width, format, options) ⇒ Symbol from _enum_error_

Parameters:

Returns:



333
334
335
 
# File 'lib/fast_excel/binding/worksheet.rb', line 333

def set_column_opt(first_col, last_col, width, format, options)
  Libxlsxwriter.worksheet_set_column_opt(self, first_col, last_col, width, format, options)
end

#set_default_row(height, hide_unused_rows) ⇒ nil

Parameters:

  • height (Float)
  • hide_unused_rows (Integer)

Returns:

  • (nil) 


621
622
623
 
# File 'lib/fast_excel/binding/worksheet.rb', line 621

def set_default_row(height, hide_unused_rows)
  Libxlsxwriter.worksheet_set_default_row(self, height, hide_unused_rows)
end

#set_first_sheet ⇒ nil

Returns:

  • (nil) 


407
408
409
 
# File 'lib/fast_excel/binding/worksheet.rb', line 407

def set_first_sheet()
  Libxlsxwriter.worksheet_set_first_sheet(self)
end

#set_footer(string) ⇒ Symbol from _enum_error_

Parameters:

  • string (String)

Returns:



491
492
493
 
# File 'lib/fast_excel/binding/worksheet.rb', line 491

def set_footer(string)
  Libxlsxwriter.worksheet_set_footer(self, string)
end

#set_footer_opt(string, options) ⇒ Symbol from _enum_error_

Parameters:

Returns:



505
506
507
 
# File 'lib/fast_excel/binding/worksheet.rb', line 505

def set_footer_opt(string, options)
  Libxlsxwriter.worksheet_set_footer_opt(self, string, options)
end

#set_h_pagebreaks(breaks) ⇒ Symbol from _enum_error_

Parameters:

  • breaks (FFI::Pointer(*U_int))

Returns:



511
512
513
 
# File 'lib/fast_excel/binding/worksheet.rb', line 511

def set_h_pagebreaks(breaks)
  Libxlsxwriter.worksheet_set_h_pagebreaks(self, breaks)
end

#set_header(string) ⇒ Symbol from _enum_error_

Parameters:

  • string (String)

Returns:



485
486
487
 
# File 'lib/fast_excel/binding/worksheet.rb', line 485

def set_header(string)
  Libxlsxwriter.worksheet_set_header(self, string)
end

#set_header_opt(string, options) ⇒ Symbol from _enum_error_

Parameters:

Returns:



498
499
500
 
# File 'lib/fast_excel/binding/worksheet.rb', line 498

def set_header_opt(string, options)
  Libxlsxwriter.worksheet_set_header_opt(self, string, options)
end

#set_landscape ⇒ nil

Returns:

  • (nil) 


454
455
456
 
# File 'lib/fast_excel/binding/worksheet.rb', line 454

def set_landscape()
  Libxlsxwriter.worksheet_set_landscape(self)
end

#set_margins(left, right, top, bottom) ⇒ nil

Parameters:

  • left (Float)
  • right (Float)
  • top (Float)
  • bottom (Float)

Returns:

  • (nil) 


479
480
481
 
# File 'lib/fast_excel/binding/worksheet.rb', line 479

def set_margins(left, right, top, bottom)
  Libxlsxwriter.worksheet_set_margins(self, left, right, top, bottom)
end

#set_page_view ⇒ nil

Returns:

  • (nil) 


464
465
466
 
# File 'lib/fast_excel/binding/worksheet.rb', line 464

def set_page_view()
  Libxlsxwriter.worksheet_set_page_view(self)
end

#set_paper(paper_type) ⇒ nil

Parameters:

  • paper_type (Integer)

Returns:

  • (nil) 


470
471
472
 
# File 'lib/fast_excel/binding/worksheet.rb', line 470

def set_paper(paper_type)
  Libxlsxwriter.worksheet_set_paper(self, paper_type)
end

#set_portrait ⇒ nil

Returns:

  • (nil) 


459
460
461
 
# File 'lib/fast_excel/binding/worksheet.rb', line 459

def set_portrait()
  Libxlsxwriter.worksheet_set_portrait(self)
end

#set_print_scale(scale) ⇒ nil

Parameters:

  • scale (Integer)

Returns:

  • (nil) 


591
592
593
 
# File 'lib/fast_excel/binding/worksheet.rb', line 591

def set_print_scale(scale)
  Libxlsxwriter.worksheet_set_print_scale(self, scale)
end

#set_row(row, height, format) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • height (Float)
  • format (Format)

Returns:



305
306
307
 
# File 'lib/fast_excel/binding/worksheet.rb', line 305

def set_row(row, height, format)
  Libxlsxwriter.worksheet_set_row(self, row, height, format)
end

#set_row_opt(row, height, format, options) ⇒ Symbol from _enum_error_

Parameters:

Returns:



314
315
316
 
# File 'lib/fast_excel/binding/worksheet.rb', line 314

def set_row_opt(row, height, format, options)
  Libxlsxwriter.worksheet_set_row_opt(self, row, height, format, options)
end

#set_selection(first_row, first_col, last_row, last_col) ⇒ nil

Parameters:

  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)

Returns:

  • (nil) 


449
450
451
 
# File 'lib/fast_excel/binding/worksheet.rb', line 449

def set_selection(first_row, first_col, last_row, last_col)
  Libxlsxwriter.worksheet_set_selection(self, first_row, first_col, last_row, last_col)
end

#set_start_page(start_page) ⇒ nil

Parameters:

  • start_page (Integer)

Returns:

  • (nil) 


585
586
587
 
# File 'lib/fast_excel/binding/worksheet.rb', line 585

def set_start_page(start_page)
  Libxlsxwriter.worksheet_set_start_page(self, start_page)
end

#set_tab_color(color) ⇒ nil

Parameters:

  • color (Integer)

Returns:

  • (nil) 


607
608
609
 
# File 'lib/fast_excel/binding/worksheet.rb', line 607

def set_tab_color(color)
  Libxlsxwriter.worksheet_set_tab_color(self, color)
end

#set_v_pagebreaks(breaks) ⇒ Symbol from _enum_error_

Parameters:

  • breaks (FFI::Pointer(*U_short))

Returns:



517
518
519
 
# File 'lib/fast_excel/binding/worksheet.rb', line 517

def set_v_pagebreaks(breaks)
  Libxlsxwriter.worksheet_set_v_pagebreaks(self, breaks)
end

#set_zoom(scale) ⇒ nil

Parameters:

  • scale (Integer)

Returns:

  • (nil) 


528
529
530
 
# File 'lib/fast_excel/binding/worksheet.rb', line 528

def set_zoom(scale)
  Libxlsxwriter.worksheet_set_zoom(self, scale)
end

#split_panes(vertical, horizontal) ⇒ nil

Parameters:

  • vertical (Float)
  • horizontal (Float)

Returns:

  • (nil) 


421
422
423
 
# File 'lib/fast_excel/binding/worksheet.rb', line 421

def split_panes(vertical, horizontal)
  Libxlsxwriter.worksheet_split_panes(self, vertical, horizontal)
end

#split_panes_opt(vertical, horizontal, top_row, left_col) ⇒ nil

Parameters:

  • vertical (Float)
  • horizontal (Float)
  • top_row (Integer)
  • left_col (Integer)

Returns:

  • (nil) 


440
441
442
 
# File 'lib/fast_excel/binding/worksheet.rb', line 440

def split_panes_opt(vertical, horizontal, top_row, left_col)
  Libxlsxwriter.worksheet_split_panes_opt(self, vertical, horizontal, top_row, left_col)
end

#write_array_formula(first_row, first_col, last_row, last_col, formula, format) ⇒ Symbol from _enum_error_

Parameters:

  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)
  • formula (String)
  • format (Format)

Returns:



229
230
231
 
# File 'lib/fast_excel/binding/worksheet.rb', line 229

def write_array_formula(first_row, first_col, last_row, last_col, formula, format)
  Libxlsxwriter.worksheet_write_array_formula(self, first_row, first_col, last_row, last_col, formula, format)
end

#write_array_formula_num(first_row, first_col, last_row, last_col, formula, format, result) ⇒ Symbol from _enum_error_

Parameters:

  • first_row (Integer)
  • first_col (Integer)
  • last_row (Integer)
  • last_col (Integer)
  • formula (String)
  • format (Format)
  • result (Float)

Returns:



241
242
243
 
# File 'lib/fast_excel/binding/worksheet.rb', line 241

def write_array_formula_num(first_row, first_col, last_row, last_col, formula, format, result)
  Libxlsxwriter.worksheet_write_array_formula_num(self, first_row, first_col, last_row, last_col, formula, format, result)
end

#write_blank(row, col, format) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • format (Format)

Returns:



287
288
289
 
# File 'lib/fast_excel/binding/worksheet.rb', line 287

def write_blank(row, col, format)
  Libxlsxwriter.worksheet_write_blank(self, row, col, format)
end

#write_boolean(row, col, value, format) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • value (Integer)
  • format (Format)

Returns:



279
280
281
 
# File 'lib/fast_excel/binding/worksheet.rb', line 279

def write_boolean(row, col, value, format)
  Libxlsxwriter.worksheet_write_boolean(self, row, col, value, format)
end

#write_datetime(row, col, datetime, format) ⇒ Symbol from _enum_error_

Parameters:

Returns:



250
251
252
 
# File 'lib/fast_excel/binding/worksheet.rb', line 250

def write_datetime(row, col, datetime, format)
  Libxlsxwriter.worksheet_write_datetime(self, row, col, datetime, format)
end

#write_formula(row, col, formula, format) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • formula (String)
  • format (Format)

Returns:



218
219
220
 
# File 'lib/fast_excel/binding/worksheet.rb', line 218

def write_formula(row, col, formula, format)
  Libxlsxwriter.worksheet_write_formula(self, row, col, formula, format)
end

#write_formula_num(row, col, formula, format, result) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • formula (String)
  • format (Format)
  • result (Float)

Returns:



297
298
299
 
# File 'lib/fast_excel/binding/worksheet.rb', line 297

def write_formula_num(row, col, formula, format, result)
  Libxlsxwriter.worksheet_write_formula_num(self, row, col, formula, format, result)
end

#write_number(row, col, number, format) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • number (Float)
  • format (Format)

Returns:



200
201
202
 
# File 'lib/fast_excel/binding/worksheet.rb', line 200

def write_number(row, col, number, format)
  Libxlsxwriter.worksheet_write_number(self, row, col, number, format)
end

#write_single_row ⇒ nil

Returns:

  • (nil) 


636
637
638
 
# File 'lib/fast_excel/binding/worksheet.rb', line 636

def write_single_row()
  Libxlsxwriter.worksheet_write_single_row(self)
end

#write_string(row, col, string, format) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • string (String)
  • format (Format)

Returns:



209
210
211
 
# File 'lib/fast_excel/binding/worksheet.rb', line 209

def write_string(row, col, string, format)
  Libxlsxwriter.worksheet_write_string(self, row, col, string, format)
end

#write_url(row, col, url, format) ⇒ Symbol from _enum_error_

Parameters:

  • row (Integer)
  • col (Integer)
  • url (String)
  • format (Format)

Returns:



270
271
272
 
# File 'lib/fast_excel/binding/worksheet.rb', line 270

def write_url(row, col, url, format)
  Libxlsxwriter.worksheet_write_url(self, row, col, url, format)
end

#write_url_opt(row_num, col_num, url, format, string, tooltip) ⇒ Symbol from _enum_error_

Parameters:

  • row_num (Integer)
  • col_num (Integer)
  • url (String)
  • format (Format)
  • string (String)
  • tooltip (String)

Returns:



261
262
263
 
# File 'lib/fast_excel/binding/worksheet.rb', line 261

def write_url_opt(row_num, col_num, url, format, string, tooltip)
  Libxlsxwriter.worksheet_write_url_opt(self, row_num, col_num, url, format, string, tooltip)
end