LibEngsas
Public Types | Public Member Functions | Private Member Functions | Private Attributes | List of all members
ExcelSheet Class Reference

#include <excelsheet.h>

+ Inheritance diagram for ExcelSheet:
+ Collaboration diagram for ExcelSheet:

Public Types

enum  UnderlineStyle {
  UnderlineStyleDouble = -4119, UnderlineStyleDoubleAccounting = 5, UnderlineStyleNone = -4142, UnderlineStyleSingle = 2,
  UnderlineStyleSingleAccounting = 4
}
 The UnderlineStyle enum is a "mirror" enum of Excel::Constants::XlUnderlineStyle. More...
 
enum  VerticalAlignment {
  VerticalAlignmentBottom = -4107, VerticalAlignmentCenter = -4108, VerticalAlignmentDistributed = -4117, VerticalAlignmentJustify = -4130,
  VerticalAlignmentTop = -4160
}
 The VerticalAlignment enum is a "mirror" enum of Excel::Constants::XlVAlign. More...
 
enum  HorizontalAlignment {
  HorizontalAlignmentCenter = -4108, HorizontalAlignmentCenterAcrossSelection = 7, HorizontalAlignmentDistributed = -4117, HorizontalAlignmentFill = 5,
  HorizontalAlignmentGeneral = 1, HorizontalAlignmentJustify = -4130, HorizontalAlignmentLeft = -4131, HorizontalAlignmentRight = -4152
}
 The HorizontalAlignment enum is a "mirror" enum of Excel::Constants::XlHAlign. More...
 
enum  CellType { CellTypeLastCell = 11 }
 Parts of the Excel::Constants::XlCellType enum. More...
 
enum  ColorIndex { ColorIndexAutomatic = -4105, ColorIndexNone = -4142 }
 Mirror enum of XlColorIndex. More...
 
- Public Types inherited from ESpreadsheet
enum  Header { HeaderNone = 0x0, HeaderVertical = 0x1, HeaderHorizontal = 0x2, HeaderAll = HeaderVertical | HeaderHorizontal }
 Used by setData(QAbstractItemModel*, QModelIndex, Header) to determine which header to add. More...
 

Public Member Functions

 ExcelSheet (QAxObject *sheet, ESpreadsheetProvider *provider, QObject *parent=NULL)
 
void setName (QString name)
 
bool setData (ESpreadsheetCell cell)
 Adds value to this spreadsheet at ESpreadsheetCell::row() and ESpreadsheetCell::column of cell. More...
 
ESpreadsheetCell data (int row, int column) const
 Returns the data of the cell row, column. More...
 
int rowCount () const
 Returns the number of rows within this spreadsheet. More...
 
int columnCount () const
 Returns the number of columns within this spreadsheet. More...
 
- Public Member Functions inherited from ESpreadsheet
 ESpreadsheet (ESpreadsheetProvider *provider, QObject *parent=NULL)
 
QString name () const
 
ESpreadsheetProviderprovider () const
 
void setProvider (ESpreadsheetProvider *provider)
 
bool setData (QAbstractItemModel *model, ESpreadsheet::Headers header=ESpreadsheet::HeaderNone, QModelIndex root=QModelIndex())
 Adds the data of the childs of index root to this spreadsheet. More...
 
bool setForeground (int row, int column, QBrush foreground)
 Sets the foreground of cell row and column to foreground. More...
 
bool setBackground (int row, int column, QBrush background)
 Sets the background of cell row and column to background. More...
 
bool setFont (int row, int column, QFont font)
 Sets the font of cell row and column to font. More...
 
bool setAlignment (int row, int column, Qt::AlignmentFlag alignment)
 Sets the alignment of cell row and column to alignment. More...
 
bool data (QAbstractItemModel *model, QModelIndex root=QModelIndex()) const
 Loads the data of this spreadsheet into model as childs of index root. More...
 
- Public Member Functions inherited from EObject
 EObject (QObject *parent=0)
 
virtual ~EObject ()
 
void connectByPass (QObject *object)
 

Private Member Functions

QColor convertColor (QString vbaColorString) const
 

Private Attributes

QAxObject * mySheet
 

Additional Inherited Members

- Public Slots inherited from EObject
virtual void reloadSettings ()
 Used to reload the settings. More...
 
- Signals inherited from EObject
void error (const QString &message)
 
void warning (const QString &message)
 
void information (const QString &message)
 
void reloadEnableActions ()
 Request reloading of enabled actions in EMainWindow. More...
 
void addMenu (QMenu *newMenu, const QString &parent, QString before=QString())
 
void addAction (QAction *newAction, const QString &parent, QString before=QString())
 
void addToolBar (QToolBar *newToolBar, Qt::ToolBarArea area=Qt::TopToolBarArea)
 
void addNewDockWidget (QDockWidget *widget, const Qt::DockWidgetArea &area)
 
void setCentralWidget (QWidget *centralWidget)
 
void showSettings ()
 
void showHelp (const QString &page)
 
void showStatusWidget (QWidget *widget)
 
void reloadSettingsRequest ()
 Indicates, that a reload of the settings is needed. More...
 
void doReloadSettings ()
 Emitted to bring the reload request back to the farest child. More...
 
- Static Public Member Functions inherited from EObject
static void connectByPass (QObject *parent, QObject *child)
 
- Protected Slots inherited from EObject
virtual void errorByPass (const QString &message)
 
virtual void warningByPass (const QString &message)
 
virtual void informationByPass (const QString &message)
 
virtual void reloadEnableActionsByPass ()
 
virtual void addMenuByPass (QMenu *newMenu, const QString &parent, QString before=QString())
 
virtual void addActionByPass (QAction *newAction, const QString &parent, QString before=QString())
 
virtual void addToolBarByPass (QToolBar *newToolBar, Qt::ToolBarArea area=Qt::TopToolBarArea)
 
virtual void addNewDockWidgetByPass (QDockWidget *widget, const Qt::DockWidgetArea &area)
 
virtual void setCentralWidgetByPass (QWidget *centralWidget)
 
virtual void showSettingsByPass ()
 
virtual void showHelpByPass (const QString &page)
 
virtual void showStatusWidgetByPass (QWidget *widget)
 
virtual void reloadSettingsRequestByPass ()
 
- Protected Member Functions inherited from ESpreadsheet
 ESpreadsheet (QObject *parent=NULL)
 Constructs an ESpreadsheet without a provider. More...
 
- Protected Member Functions inherited from EObject
void addManagedDockWidget (QDockWidget *widget, const Qt::DockWidgetArea &area, QString actionLabel=QString(), QString actionParent=QString())
 Adds an dock widget via addNewDockWidget() and adds widget to the list of managed dock widgets. More...
 

Member Enumeration Documentation

Parts of the Excel::Constants::XlCellType enum.

Enumerator
CellTypeLastCell 

Mirror enum of XlColorIndex.

See Also
http://msdn.microsoft.com/en-us/library/aa221100%28office.11%29.aspx
Enumerator
ColorIndexAutomatic 
ColorIndexNone 

The HorizontalAlignment enum is a "mirror" enum of Excel::Constants::XlHAlign.

See Also
http://msdn.microsoft.com/en-us/library/aa221100%28office.11%29.aspx
Enumerator
HorizontalAlignmentCenter 
HorizontalAlignmentCenterAcrossSelection 

Not supported

HorizontalAlignmentDistributed 

Not supported

HorizontalAlignmentFill 

Not supported

HorizontalAlignmentGeneral 

Not supported

HorizontalAlignmentJustify 
HorizontalAlignmentLeft 
HorizontalAlignmentRight 

The UnderlineStyle enum is a "mirror" enum of Excel::Constants::XlUnderlineStyle.

See Also
http://msdn.microsoft.com/en-us/library/aa221100%28office.11%29.aspx
Enumerator
UnderlineStyleDouble 

Not supported

UnderlineStyleDoubleAccounting 

Not supported

UnderlineStyleNone 
UnderlineStyleSingle 
UnderlineStyleSingleAccounting 

Read as 2

The VerticalAlignment enum is a "mirror" enum of Excel::Constants::XlVAlign.

See Also
http://msdn.microsoft.com/en-us/library/aa221100%28office.11%29.aspx
Enumerator
VerticalAlignmentBottom 
VerticalAlignmentCenter 
VerticalAlignmentDistributed 

Not supported

VerticalAlignmentJustify 
VerticalAlignmentTop 

Constructor & Destructor Documentation

ExcelSheet::ExcelSheet ( QAxObject *  sheet,
ESpreadsheetProvider provider,
QObject *  parent = NULL 
)

+ Here is the call graph for this function:

Member Function Documentation

int ExcelSheet::columnCount ( ) const
virtual

Returns the number of columns within this spreadsheet.

Note
This function should be implemented by the plugin providing an ESpreadsheetProvider.

Implements ESpreadsheet.

+ Here is the caller graph for this function:

QColor ExcelSheet::convertColor ( QString  vbaColorString) const
private

+ Here is the caller graph for this function:

ESpreadsheetCell ExcelSheet::data ( int  row,
int  column 
) const
virtual

Returns the data of the cell row, column.

Note
This function should be implemented by the plugin providing an ESpreadsheetProvider.

Implements ESpreadsheet.

+ Here is the call graph for this function:

int ExcelSheet::rowCount ( ) const
virtual

Returns the number of rows within this spreadsheet.

Note
This function should be implemented by the plugin providing an ESpreadsheetProvider.

Implements ESpreadsheet.

+ Here is the caller graph for this function:

bool ExcelSheet::setData ( ESpreadsheetCell  cell)
virtual

Adds value to this spreadsheet at ESpreadsheetCell::row() and ESpreadsheetCell::column of cell.

To manipulate the text font, provide font, alignment and foreground. To specifiy a background color, set background.

See Also
setData(QAbstractItemModel*, QModelIndex)
setForeground()
setBackground()
setFont()
setAlignment()
data(int, int)
data(QAbstractItemModel*, QModelIndex)
Note
This function should be implemented by the plugin providing an ESpreadsheetProvider.

Implements ESpreadsheet.

+ Here is the call graph for this function:

void ExcelSheet::setName ( QString  name)
virtual

Reimplemented from ESpreadsheet.

+ Here is the call graph for this function:

+ Here is the caller graph for this function:

Member Data Documentation

QAxObject* ExcelSheet::mySheet
private

The documentation for this class was generated from the following files: