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) 


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

def activate()
  Libxlsxwriter.worksheet_activate(self)
end

#assemble_xml_file ⇒ nil

Returns:

  • (nil) 


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

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:



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

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) 


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

def center_horizontally()
  Libxlsxwriter.worksheet_center_horizontally(self)
end

#center_vertically ⇒ nil

Returns:

  • (nil) 


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

def center_vertically()
  Libxlsxwriter.worksheet_center_vertically(self)
end

#find_row(row_num) ⇒ Row

Parameters:

  • row_num (Integer)

Returns:



662
663
664
 
# File 'lib/fast_excel/binding/worksheet.rb', line 662

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) 


583
584
585
 
# File 'lib/fast_excel/binding/worksheet.rb', line 583

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

#free ⇒ nil

Returns:

  • (nil) 


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

def free()
  Libxlsxwriter.worksheet_free(self)
end

#freeze_panes(row, col) ⇒ nil

Parameters:

  • row (Integer)
  • col (Integer)

Returns:

  • (nil) 


418
419
420
 
# File 'lib/fast_excel/binding/worksheet.rb', line 418

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) 


435
436
437
 
# File 'lib/fast_excel/binding/worksheet.rb', line 435

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) 


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

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

#hide ⇒ nil

Returns:

  • (nil) 


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

def hide()
  Libxlsxwriter.worksheet_hide(self)
end

#hide_zero ⇒ nil

Returns:

  • (nil) 


605
606
607
 
# File 'lib/fast_excel/binding/worksheet.rb', line 605

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:



362
363
364
 
# File 'lib/fast_excel/binding/worksheet.rb', line 362

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:



371
372
373
 
# File 'lib/fast_excel/binding/worksheet.rb', line 371

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:



345
346
347
 
# File 'lib/fast_excel/binding/worksheet.rb', line 345

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:



354
355
356
 
# File 'lib/fast_excel/binding/worksheet.rb', line 354

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:



382
383
384
 
# File 'lib/fast_excel/binding/worksheet.rb', line 382

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) 


656
657
658
 
# File 'lib/fast_excel/binding/worksheet.rb', line 656

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) 


648
649
650
 
# File 'lib/fast_excel/binding/worksheet.rb', line 648

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) 


526
527
528
 
# File 'lib/fast_excel/binding/worksheet.rb', line 526

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:



576
577
578
 
# File 'lib/fast_excel/binding/worksheet.rb', line 576

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) 


553
554
555
 
# File 'lib/fast_excel/binding/worksheet.rb', line 553

def print_row_col_headers()
  Libxlsxwriter.worksheet_print_row_col_headers(self)
end

#protect(password, options) ⇒ nil

Parameters:

Returns:

  • (nil) 


618
619
620
 
# File 'lib/fast_excel/binding/worksheet.rb', line 618

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:



567
568
569
 
# File 'lib/fast_excel/binding/worksheet.rb', line 567

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:



560
561
562
 
# File 'lib/fast_excel/binding/worksheet.rb', line 560

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

#select ⇒ nil

Returns:

  • (nil) 


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

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:



327
328
329
 
# File 'lib/fast_excel/binding/worksheet.rb', line 327

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:



337
338
339
 
# File 'lib/fast_excel/binding/worksheet.rb', line 337

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) 


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

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) 


411
412
413
 
# File 'lib/fast_excel/binding/worksheet.rb', line 411

def set_first_sheet()
  Libxlsxwriter.worksheet_set_first_sheet(self)
end

#set_footer(string) ⇒ Symbol from _enum_error_

Parameters:

  • string (String)

Returns:



495
496
497
 
# File 'lib/fast_excel/binding/worksheet.rb', line 495

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

#set_footer_opt(string, options) ⇒ Symbol from _enum_error_

Parameters:

Returns:



509
510
511
 
# File 'lib/fast_excel/binding/worksheet.rb', line 509

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:



515
516
517
 
# File 'lib/fast_excel/binding/worksheet.rb', line 515

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

#set_header(string) ⇒ Symbol from _enum_error_

Parameters:

  • string (String)

Returns:



489
490
491
 
# File 'lib/fast_excel/binding/worksheet.rb', line 489

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

#set_header_opt(string, options) ⇒ Symbol from _enum_error_

Parameters:

Returns:



502
503
504
 
# File 'lib/fast_excel/binding/worksheet.rb', line 502

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

#set_landscape ⇒ nil

Returns:

  • (nil) 


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

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) 


483
484
485
 
# File 'lib/fast_excel/binding/worksheet.rb', line 483

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

#set_page_view ⇒ nil

Returns:

  • (nil) 


468
469
470
 
# File 'lib/fast_excel/binding/worksheet.rb', line 468

def set_page_view()
  Libxlsxwriter.worksheet_set_page_view(self)
end

#set_paper(paper_type) ⇒ nil

Parameters:

  • paper_type (Integer)

Returns:

  • (nil) 


474
475
476
 
# File 'lib/fast_excel/binding/worksheet.rb', line 474

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

#set_portrait ⇒ nil

Returns:

  • (nil) 


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

def set_portrait()
  Libxlsxwriter.worksheet_set_portrait(self)
end

#set_print_scale(scale) ⇒ nil

Parameters:

  • scale (Integer)

Returns:

  • (nil) 


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

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

#set_right_to_left ⇒ nil

Returns:

  • (nil) 


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

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:



309
310
311
 
# File 'lib/fast_excel/binding/worksheet.rb', line 309

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:



318
319
320
 
# File 'lib/fast_excel/binding/worksheet.rb', line 318

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) 


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

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) 


589
590
591
 
# File 'lib/fast_excel/binding/worksheet.rb', line 589

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) 


611
612
613
 
# File 'lib/fast_excel/binding/worksheet.rb', line 611

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:



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

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

#set_zoom(scale) ⇒ nil

Parameters:

  • scale (Integer)

Returns:

  • (nil) 


532
533
534
 
# File 'lib/fast_excel/binding/worksheet.rb', line 532

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

#split_panes(vertical, horizontal) ⇒ nil

Parameters:

  • vertical (Float)
  • horizontal (Float)

Returns:

  • (nil) 


425
426
427
 
# File 'lib/fast_excel/binding/worksheet.rb', line 425

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) 


444
445
446
 
# File 'lib/fast_excel/binding/worksheet.rb', line 444

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:



233
234
235
 
# File 'lib/fast_excel/binding/worksheet.rb', line 233

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:



245
246
247
 
# File 'lib/fast_excel/binding/worksheet.rb', line 245

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:



291
292
293
 
# File 'lib/fast_excel/binding/worksheet.rb', line 291

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:



283
284
285
 
# File 'lib/fast_excel/binding/worksheet.rb', line 283

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

#write_comment(row, col, string) ⇒ Object 



213
214
215
 
# File 'lib/fast_excel/binding/worksheet.rb', line 213

def write_comment(row, col, string)
  Libxlsxwriter.worksheet_write_comment(self, row, col, string)
end

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

Parameters:

Returns:



254
255
256
 
# File 'lib/fast_excel/binding/worksheet.rb', line 254

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:



222
223
224
 
# File 'lib/fast_excel/binding/worksheet.rb', line 222

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:



301
302
303
 
# File 'lib/fast_excel/binding/worksheet.rb', line 301

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) 


640
641
642
 
# File 'lib/fast_excel/binding/worksheet.rb', line 640

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:



274
275
276
 
# File 'lib/fast_excel/binding/worksheet.rb', line 274

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:



265
266
267
 
# File 'lib/fast_excel/binding/worksheet.rb', line 265

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