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

#activatenil

Returns:

  • (nil)

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

def activate()
  Libxlsxwriter.worksheet_activate(self)
end

#assemble_xml_filenil

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_horizontallynil

Returns:

  • (nil)

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

def center_horizontally()
  Libxlsxwriter.worksheet_center_horizontally(self)
end

#center_verticallynil

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

#freenil

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

#hidenil

Returns:

  • (nil)

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

def hide()
  Libxlsxwriter.worksheet_hide(self)
end

#hide_zeronil

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

Returns:

  • (nil)

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

def print_across()
  Libxlsxwriter.worksheet_print_across(self)
end

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

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

#selectnil

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_sheetnil

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

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

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_landscapenil

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_viewnil

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_portraitnil

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_right_to_leftnil

Returns:

  • (nil)

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

def set_right_to_left()
  Libxlsxwriter.worksheet_right_to_left(self)
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_rownil

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