Module: Libxlsxwriter::WorkbookWrappers

Included in:
Workbook
Defined in:
lib/fast_excel/binding/workbook.rb

Overview

Fields:

:file

(FFI::Pointer(*FILE))

:worksheets

(Worksheets)

:worksheet_names

(WorksheetNames)

:charts

(Charts)

:ordered_charts

(Charts)

:formats

(Formats)

:defined_names

(DefinedNames)

:sst

(Sst)

:properties

(DocProperties)

:custom_properties

(CustomProperties)

:filename

(String)

:options

(WorkbookOptions)

:num_sheets

(Integer)

:first_sheet

(Integer)

:active_sheet

(Integer)

:num_xf_formats

(Integer)

:num_format_count

(Integer)

:drawing_count

(Integer)

:font_count

(Integer)

:border_count

(Integer)

:fill_count

(Integer)

:optimize

(Integer)

:has_png

(Integer)

:has_jpeg

(Integer)

:has_bmp

(Integer)

:used_xf_formats

(HashTable)

Instance Method Summary collapse

Instance Method Details

#add_chart(chart_type) ⇒ Chart

Parameters:

  • chart_type (Integer)

Returns:



86
87
88
 
# File 'lib/fast_excel/binding/workbook.rb', line 86

def add_chart(chart_type)
  Chart.new Libxlsxwriter.workbook_add_chart(self, chart_type)
end

#add_format ⇒ Format

Returns:



76
77
78
 
# File 'lib/fast_excel/binding/workbook.rb', line 76

def add_format()
  Format.new Libxlsxwriter.workbook_add_format(self)
end

#add_worksheet(sheetname) ⇒ Worksheet

Parameters:

  • sheetname (String)

Returns:



71
72
73
 
# File 'lib/fast_excel/binding/workbook.rb', line 71

def add_worksheet(sheetname)
  Worksheet.new Libxlsxwriter.workbook_add_worksheet(self, sheetname)
end

#assemble_xml_file ⇒ nil

Returns:

  • (nil) 


161
162
163
 
# File 'lib/fast_excel/binding/workbook.rb', line 161

def assemble_xml_file()
  Libxlsxwriter.workbook_assemble_xml_file(self)
end

#close ⇒ Symbol from _enum_error_

Returns:



91
92
93
 
# File 'lib/fast_excel/binding/workbook.rb', line 91

def close()
  Libxlsxwriter.workbook_close(self)
end

#default_format ⇒ Object 



80
81
82
 
# File 'lib/fast_excel/binding/workbook.rb', line 80

def default_format()
  Format.new Libxlsxwriter.workbook_default_format(self)
end

#define_name(name, formula) ⇒ Symbol from _enum_error_

Parameters:

  • name (String)
  • formula (String)

Returns:



139
140
141
 
# File 'lib/fast_excel/binding/workbook.rb', line 139

def define_name(name, formula)
  Libxlsxwriter.workbook_define_name(self, name, formula)
end

#free ⇒ nil

Returns:

  • (nil) 


156
157
158
 
# File 'lib/fast_excel/binding/workbook.rb', line 156

def free()
  Libxlsxwriter.workbook_free(self)
end

#get_worksheet_by_name(name) ⇒ Worksheet

Parameters:

  • name (String)

Returns:



145
146
147
 
# File 'lib/fast_excel/binding/workbook.rb', line 145

def get_worksheet_by_name(name)
  Worksheet.new Libxlsxwriter.workbook_get_worksheet_by_name(self, name)
end

#set_custom_property_boolean(name, value) ⇒ Symbol from _enum_error_

Parameters:

  • name (String)
  • value (Integer)

Returns:



125
126
127
 
# File 'lib/fast_excel/binding/workbook.rb', line 125

def set_custom_property_boolean(name, value)
  Libxlsxwriter.workbook_set_custom_property_boolean(self, name, value)
end

#set_custom_property_datetime(name, datetime) ⇒ Symbol from _enum_error_

Parameters:

Returns:



132
133
134
 
# File 'lib/fast_excel/binding/workbook.rb', line 132

def set_custom_property_datetime(name, datetime)
  Libxlsxwriter.workbook_set_custom_property_datetime(self, name, datetime)
end

#set_custom_property_integer(name, value) ⇒ Symbol from _enum_error_

Parameters:

  • name (String)
  • value (Integer)

Returns:



118
119
120
 
# File 'lib/fast_excel/binding/workbook.rb', line 118

def set_custom_property_integer(name, value)
  Libxlsxwriter.workbook_set_custom_property_integer(self, name, value)
end

#set_custom_property_number(name, value) ⇒ Symbol from _enum_error_

Parameters:

  • name (String)
  • value (Float)

Returns:



111
112
113
 
# File 'lib/fast_excel/binding/workbook.rb', line 111

def set_custom_property_number(name, value)
  Libxlsxwriter.workbook_set_custom_property_number(self, name, value)
end

#set_custom_property_string(name, value) ⇒ Symbol from _enum_error_

Parameters:

  • name (String)
  • value (String)

Returns:



104
105
106
 
# File 'lib/fast_excel/binding/workbook.rb', line 104

def set_custom_property_string(name, value)
  Libxlsxwriter.workbook_set_custom_property_string(self, name, value)
end

#set_default_xf_indices ⇒ nil

Returns:

  • (nil) 


166
167
168
 
# File 'lib/fast_excel/binding/workbook.rb', line 166

def set_default_xf_indices()
  Libxlsxwriter.workbook_set_default_xf_indices(self)
end

#set_properties(properties) ⇒ Symbol from _enum_error_

Parameters:

Returns:



97
98
99
 
# File 'lib/fast_excel/binding/workbook.rb', line 97

def set_properties(properties)
  Libxlsxwriter.workbook_set_properties(self, properties)
end

#validate_worksheet_name(sheetname) ⇒ Symbol from _enum_error_

Parameters:

  • sheetname (String)

Returns:



151
152
153
 
# File 'lib/fast_excel/binding/workbook.rb', line 151

def validate_worksheet_name(sheetname)
  Libxlsxwriter.workbook_validate_sheet_name(self, sheetname)
end