void StylesTest::testAddFormat()
{
QXlsx::Styles styles;
for (int i=0; i<10; ++i) {
QXlsx::Format *format = styles.createFormat();
format->setFontBold(true);
styles.addFormat(format);
}
QByteArray xmlData = styles.saveToXmlData();
QVERIFY2(xmlData.contains("<cellXfs count=\"2\">"), ""); //Note we have a default one
}
int main(int argc, char** argv)
{
QGuiApplication(argc, argv);
QXlsx::Document xlsx;
xlsx.setColumn(1, 4, 20.0);
QXlsx::Format header;
header.setFontBold(true);
header.setFontSize(20);
//Custom number formats
QStringList numFormats;
numFormats<<"Qt #"
<<"yyyy-mmm-dd"
<<"$ #,##0.00"
<<"[red]0.00";
xlsx.write(1, 1, "Raw data", header);
xlsx.write(1, 2, "Format", header);
xlsx.write(1, 3, "Shown value", header);
for (int i=0; i<numFormats.size(); ++i) {
int row = i+2;
xlsx.write(row, 1, 100.0);
xlsx.write(row, 2, numFormats[i]);
QXlsx::Format format;
format.setNumberFormat(numFormats[i]);
xlsx.write(row, 3, 100.0, format);
}
//Builtin number formats
xlsx.addSheet();
xlsx.setColumn(1, 4, 20.0);
xlsx.write(1, 1, "Raw data", header);
xlsx.write(1, 2, "Builtin Format", header);
xlsx.write(1, 3, "Shown value", header);
for (int i=0; i<50; ++i) {
int row = i+2;
int numFmt = i;
xlsx.write(row, 1, 100.0);
xlsx.write(row, 2, numFmt);
QXlsx::Format format;
format.setNumberFormatIndex(numFmt);
xlsx.write(row, 3, 100.0, format);
}
xlsx.save();
return 0;
}
void IoslotValueExporter::toExcel()
{
QXlsx::Document xlsx;
// Title
QXlsx::Format format;
format.setFontSize(18);
format.setFontBold(true);
format.setHorizontalAlignment(QXlsx::Format::AlignLeft);
xlsx.write(XLSX_PROGRAM_NAME_ROW, XLSX_KEY_COL, tr("Hydroponic system configurator"), format);
format.setFontSize(10);
format.setFontBold(false);
format.setHorizontalAlignment(QXlsx::Format::AlignLeft);
xlsx.write(XLSX_VERSION_ROW, XLSX_KEY_COL, tr("Version"), format);
format.setHorizontalAlignment(QXlsx::Format::AlignHCenter);
xlsx.write(XLSX_VERSION_ROW, XLSX_VALUE_COL, tr("1.0"), format);
format.setFontSize(12);
format.setFontBold(true);
format.setHorizontalAlignment(QXlsx::Format::AlignLeft);
xlsx.write(XLSX_DEVICE_ADDRESS_ROW, XLSX_KEY_COL, tr("Address"), format);
format.setHorizontalAlignment(QXlsx::Format::AlignHCenter);
xlsx.write(XLSX_DEVICE_ADDRESS_ROW, XLSX_VALUE_COL, d_address, format);
QVector<bool> valueEmpty(d_ioslotManager->ioslotCount(), false);
// Table header
format.setFontSize(12);
format.setFontBold(true);
format.setHorizontalAlignment(QXlsx::Format::AlignHCenter);
format.setTopBorderStyle(QXlsx::Format::BorderThick);
format.setBottomBorderStyle(QXlsx::Format::BorderThick);
format.setLeftBorderStyle(QXlsx::Format::BorderThin);
format.setRightBorderStyle(QXlsx::Format::BorderThin);
int col = 1;
xlsx.write(XLSX_HEADER_ROW, col, tr("Timestamp"), format);
++col;
for (int num = 0; num < d_ioslotManager->ioslotCount(); ++num) {
if (d_ioslotManager->ioslot(num)->type() == UnknownIoslotType) {
valueEmpty[num] = true;
continue;
}
const QString &name = d_ioslotManager->ioslot(num)->name();
xlsx.write(XLSX_HEADER_ROW, col, name, format);
++col;
}
// Table content
format.setFontSize(12);
format.setFontBold(false);
format.setHorizontalAlignment(QXlsx::Format::AlignHCenter);
format.setTopBorderStyle(QXlsx::Format::BorderThin);
format.setBottomBorderStyle(QXlsx::Format::BorderThin);
format.setLeftBorderStyle(QXlsx::Format::BorderThin);
format.setRightBorderStyle(QXlsx::Format::BorderThin);
int count = d_table->recordCount(d_from, d_to);
const int limit = 100;
int row = 0;
for (int offset = 0; offset < count; offset += limit) {
QList<IoslotValueRecord> records = d_table->records(d_from, d_to, limit, offset);
QList<IoslotValueRecord>::iterator it = records.begin();
for (; it != records.end(); ++it, ++row) {
IoslotValueRecord &record = *it;
int col = 1;
xlsx.write(XLSX_DATA_START_ROW + row, col,
record.timestamp().toString("yyyy-MM-dd hh:mm:ss.zzz"),
format);
++col;
const QList<IoslotValueRecord::RecordValue> &values = record.values();
QList<IoslotValueRecord::RecordValue>::const_iterator it2 = values.begin();
for (int num = 0; it2 != values.end(); ++it2, ++num) {
if (valueEmpty[num]) continue;
const IoslotValueRecord::RecordValue &value = *it2;
xlsx.write(XLSX_DATA_START_ROW + row, col, value.second, format);
++col;
}
}
Q_EMIT progress(offset, count);
}
(void)xlsx.saveAs(d_filename);
}