XLSXFilter

Public Methods

void

XLSXFilter()

int

endColumn() const

int

endRow() const

QString

fileInfoString(const QString &fileName)

int

firstColumn() const

bool

isValidCellReference(const QString &cellRefString)

bool

load(XmlStreamReader *) override

void

parse(const QString &fileName, QTreeWidgetItem *root)

QVector< QStringList >

previewForCurrentDataRegion(int lines, bool *okToMatrix)

void

readDataFromFile(const QString &fileName, AbstractDataSource *=nullptr, ImportMode=ImportMode::Replace) override

void

save(QXmlStreamWriter *) const override

void

setColumnNamesAsFirstRow(bool)

void

setCurrentRange(const QString &)

void

setCurrentSheet(const QString &)

void

setDataExportStartPos(const QString &)

void

setEndColumn(const int)

void

setEndRow(const int)

void

setExportAsNewSheet(bool)

void

setFirstRowAsColumnNames(bool)

void

setOverwriteData(bool)

void

setSheetToAppendTo(const QString &sheetName)

void

setStartColumn(const int)

void

setStartRow(const int)

QStringList

sheets() const

QStringList

sheets(const QString &fileName, bool *ok=nullptr)

int

startColumn() const

int

startRow() const

void

write(const QString &fileName, AbstractDataSource *) override

Detailed Description

class XLSXFilter : public AbstractFileFilter

Public Functions

virtual void write(const QString &fileName, AbstractDataSource*) override

write

Writing the content of the datasource to the file with filename fileName

Parameters:

fileName –

virtual void save(QXmlStreamWriter*) const override

Saves as XML.

void setStartRow(const int)

Sets the startRow to row.

Parameters:

row – the row to be set

int startRow() const

Returns startRow.

Returns:

The startRow

void setEndRow(const int)

Sets the endRow to row.

Parameters:

row – the row to be set

int endRow() const

Returns endRow.

Returns:

The endRow

void setStartColumn(const int)

Sets the startColumn to column.

Parameters:

column – the column to be set

int startColumn() const

Returns startColumn.

Returns:

The startColumn

void setEndColumn(const int)

Sets the endColumn to column.

Parameters:

column – the column to be set

int endColumn() const

Returns endColumn.

Returns:

The endColumn