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,...
Definition: espreadsheet.h:58
int rowCount() const
Returns the number of rows within this spreadsheet.
Definition: excelsheet.cpp:206
VerticalAlignment
The VerticalAlignment enum is a "mirror" enum of Excel::Constants::XlVAlign.
Definition: excelsheet.h:33
Definition: excelsheet.h:22
void setName(QString name)
Definition: excelsheet.cpp:21
ESpreadsheetProvider * provider() const
Definition: espreadsheet.cpp:41
Definition: excelsheet.h:69
CellType
Parts of the Excel::Constants::XlCellType enum.
Definition: excelsheet.h:59
Definition: excelsheet.h:46
Definition: excelsheet.h:25
ESpreadsheetCell data(int row, int column) const
Returns the data of the cell row, column.
Definition: excelsheet.cpp:125
Definition: excelsheet.h:37
Definition: excelsheet.h:70
QAxObject * mySheet
Definition: excelsheet.h:82
Definition: excelsheet.h:49
HorizontalAlignment
The HorizontalAlignment enum is a "mirror" enum of Excel::Constants::XlHAlign.
Definition: excelsheet.h:45
Definition: excelsheet.h:36
QString name() const
Definition: espreadsheet.cpp:31
Definition: excelsheet.h:60
Definition: excelsheet.h:34
ExcelSheet(QAxObject *sheet, ESpreadsheetProvider *provider, QObject *parent=NULL)
Definition: excelsheet.cpp:10
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
QColor convertColor(QString vbaColorString) const
Definition: excelsheet.cpp:244
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