Orcus
Public Member Functions | List of all members
orcus::spreadsheet::iface::import_sheet Class Referenceabstract

#include <import_interface.hpp>

Public Member Functions

virtual import_sheet_viewget_sheet_view ()
 
virtual import_sheet_propertiesget_sheet_properties ()
 
virtual import_data_tableget_data_table ()
 
virtual import_auto_filterget_auto_filter ()
 
virtual import_tableget_table ()
 
virtual import_conditional_formatget_conditional_format ()
 
virtual import_named_expressionget_named_expression ()
 
virtual import_array_formulaget_array_formula ()
 
virtual import_formulaget_formula ()
 
virtual void set_auto (row_t row, col_t col, const char *p, size_t n)=0
 
virtual void set_string (row_t row, col_t col, size_t sindex)=0
 
virtual void set_value (row_t row, col_t col, double value)=0
 
virtual void set_bool (row_t row, col_t col, bool value)=0
 
virtual void set_date_time (row_t row, col_t col, int year, int month, int day, int hour, int minute, double second)=0
 
virtual void set_format (row_t row, col_t col, size_t xf_index)=0
 
virtual void set_format (row_t row_start, col_t col_start, row_t row_end, col_t col_end, size_t xf_index)=0
 
virtual range_size_t get_sheet_size () const =0
 

Detailed Description

Interface for sheet.

Member Function Documentation

◆ get_auto_filter()

virtual import_auto_filter* orcus::spreadsheet::iface::import_sheet::get_auto_filter ( )
virtual

Get an interface for importing auto filter ranges.

The implementor should also initialize the internal state of the temporary auto filter object when this method is called.

Returns
pointer to the auto filter interface object.

◆ get_conditional_format()

virtual import_conditional_format* orcus::spreadsheet::iface::import_sheet::get_conditional_format ( )
virtual

get an interface for importing conditional formats. The implementer is responsible for managing the life cycle of the returned interface object.

Returns
pointer to the conditional format interface object, or NULL if the implementer doesn't support importing conditional formats.

◆ get_data_table()

virtual import_data_table* orcus::spreadsheet::iface::import_sheet::get_data_table ( )
virtual

Get an interface for importing data tables. Note that the implementer may decide not to support this feature in which case this method returns NULL. The implementer is responsible for managing the life cycle of the returned interface object.

The implementor should also initialize the internal state of the temporary data table object when this method is called.

Returns
pointer to the data table interface object.

◆ get_formula()

virtual import_formula* orcus::spreadsheet::iface::import_sheet::get_formula ( )
virtual

Get an interface for importing formula cells.

Returns
pointer to the formula interface object, or nullptr if the implementer doesn't support importing of formula cells.

◆ get_sheet_size()

virtual range_size_t orcus::spreadsheet::iface::import_sheet::get_sheet_size ( ) const
pure virtual

Get the size of the sheet.

Returns
structure containing the numbers of rows and columns of the sheet.

◆ get_table()

virtual import_table* orcus::spreadsheet::iface::import_sheet::get_table ( )
virtual

Get an interface for importing tables. The implementer is responsible for managing the life cycle of the returned interface object.

The implementor should also initialize the internal state of the temporary table object when this method is called.

Returns
pointer to the table interface object, or NULL if the implementer doesn't support importing of tables.

◆ set_auto()

virtual void orcus::spreadsheet::iface::import_sheet::set_auto ( row_t  row,
col_t  col,
const char *  p,
size_t  n 
)
pure virtual

Set raw string value to a cell and have the implementation auto-recognize its data type.

Parameters
rowrow ID
colcolumn ID
ppointer to the first character of the raw string value.
nsize of the raw string value.

◆ set_bool()

virtual void orcus::spreadsheet::iface::import_sheet::set_bool ( row_t  row,
col_t  col,
bool  value 
)
pure virtual

Set a boolean value to a cell.

Parameters
rowrow ID
colcol ID
valueboolean value being assigned to the cell

◆ set_date_time()

virtual void orcus::spreadsheet::iface::import_sheet::set_date_time ( row_t  row,
col_t  col,
int  year,
int  month,
int  day,
int  hour,
int  minute,
double  second 
)
pure virtual

Set date and time value to a cell.

Parameters
rowrow ID
colcolumn ID

◆ set_format() [1/2]

virtual void orcus::spreadsheet::iface::import_sheet::set_format ( row_t  row,
col_t  col,
size_t  xf_index 
)
pure virtual

Set cell format to specified cell. The cell format is referred to by the xf (cell format) index in the styles table.

Parameters
rowrow ID
colcolumn ID
index0-based xf (cell format) index

◆ set_format() [2/2]

virtual void orcus::spreadsheet::iface::import_sheet::set_format ( row_t  row_start,
col_t  col_start,
row_t  row_end,
col_t  col_end,
size_t  xf_index 
)
pure virtual

Set cell format to specified cell range. The cell format is referred to by the xf (cell format) index in the styles table.

Parameters
row_startstart row ID
col_startstart column ID
row_endend row ID
col_endend column ID
index0-based xf (cell format) index

◆ set_string()

virtual void orcus::spreadsheet::iface::import_sheet::set_string ( row_t  row,
col_t  col,
size_t  sindex 
)
pure virtual

Set string value to a cell.

Parameters
rowrow ID
colcolumn ID
sindex0-based string index in the shared string table.

◆ set_value()

virtual void orcus::spreadsheet::iface::import_sheet::set_value ( row_t  row,
col_t  col,
double  value 
)
pure virtual

Set numerical value to a cell.

Parameters
rowrow ID
colcolumn ID
valuevalue being assigned to the cell.