LibEngsas
excelsheet.h
Go to the documentation of this file.
1 #ifndef EXCELSHEET_H
2 #define EXCELSHEET_H
3 
4 #include <espreadsheet.h>
5 
7 
8 class QAxObject;
9 
10 class ExcelSheet : public ESpreadsheet
11 {
12  Q_OBJECT
13  public:
14  ExcelSheet(QAxObject *sheet, ESpreadsheetProvider *provider, QObject *parent = NULL);
15 
27  };
39  };
54  };
55 
59  enum CellType {
61  };
62 
68  enum ColorIndex {
71  };
72 
73  void setName(QString name);
74  bool setData(ESpreadsheetCell cell);
75  ESpreadsheetCell data(int row, int column) const;
76  int rowCount() const;
77  int columnCount() const;
78 
79  private:
80  QColor convertColor(QString vbaColorString) const;
81 
82  QAxObject *mySheet;
83 };
84 
85 #endif // EXCELSHEET_H
Definition: excelsheet.h:51
int columnCount() const
Returns the number of columns within this spreadsheet.
Definition: excelsheet.cpp:225
A spreadsheet, within a spreadsheet file.A spreadsheet consists of cells of type ESpreadsheetCell, which are ordered in rows and columns. An object of this type can be used to manipulate the hold data (see e. g. setData(ESpreadsheetCell)). To retrieve the cell content use data(int, int).
Definition: espreadsheet.h:58
VerticalAlignment
The VerticalAlignment enum is a "mirror" enum of Excel::Constants::XlVAlign.
Definition: excelsheet.h:33
Definition: excelsheet.h:22
ESpreadsheetProvider * provider() const
Definition: espreadsheet.cpp:41
void setName(QString name)
Definition: excelsheet.cpp:21
Definition: excelsheet.h:69
CellType
Parts of the Excel::Constants::XlCellType enum.
Definition: excelsheet.h:59
ESpreadsheetCell data(int row, int column) const
Returns the data of the cell row, column.
Definition: excelsheet.cpp:125
Definition: excelsheet.h:46
Definition: excelsheet.h:25
QColor convertColor(QString vbaColorString) const
Definition: excelsheet.cpp:244
Definition: excelsheet.h:37
Definition: excelsheet.h:70
QAxObject * mySheet
Definition: excelsheet.h:82
Definition: excelsheet.h:49
QString name() const
Definition: espreadsheet.cpp:31
HorizontalAlignment
The HorizontalAlignment enum is a "mirror" enum of Excel::Constants::XlHAlign.
Definition: excelsheet.h:45
Definition: excelsheet.h:36
Definition: excelsheet.h:60
Definition: excelsheet.h:34
ExcelSheet(QAxObject *sheet, ESpreadsheetProvider *provider, QObject *parent=NULL)
Definition: excelsheet.cpp:10
int rowCount() const
Returns the number of rows within this spreadsheet.
Definition: excelsheet.cpp:206
bool setData(ESpreadsheetCell cell)
Adds value to this spreadsheet at ESpreadsheetCell::row() and ESpreadsheetCell::column of cell...
Definition: excelsheet.cpp:29
Definition: excelsheet.h:10
ColorIndex
Mirror enum of XlColorIndex.
Definition: excelsheet.h:68
Definition: excelsheet.h:53
Definition: excelsheet.h:52
Definition: excelsheet.h:50
Definition: excelsheet.h:24
Represents one cell of a ESpreadsheetIt contains the value (see value()) of a cell and also the forma...
Definition: espreadsheetcell.h:40
Definition: excelsheet.h:35
Interface to implement spreadsheet providers (e. g. to create excel files or ods, ...
Definition: espreadsheetprovider.h:38
Definition: excelsheet.h:38
UnderlineStyle
The UnderlineStyle enum is a "mirror" enum of Excel::Constants::XlUnderlineStyle. ...
Definition: excelsheet.h:21