mirror of
https://github.com/QtExcel/QXlsx.git
synced 2025-01-16 04:42:53 +08:00
db608768a3
This project has no standard on coding style, some files use tab, others space, and new Merge Requests usually break the current formatting with this clang-format we can easy this.
58 lines
1.4 KiB
C++
58 lines
1.4 KiB
C++
// worksheetoperations.cpp
|
|
|
|
#include "xlsxabstractsheet.h"
|
|
#include "xlsxdocument.h"
|
|
|
|
#include <QtCore>
|
|
#include <QtGlobal>
|
|
|
|
QXLSX_USE_NAMESPACE
|
|
|
|
int worksheetoperations()
|
|
{
|
|
//![Create a xlsx file]
|
|
Document xlsx;
|
|
|
|
for (int i = 1; i < 20; ++i) {
|
|
for (int j = 1; j < 15; ++j)
|
|
xlsx.write(i, j, QString("R %1 C %2").arg(i).arg(j));
|
|
}
|
|
xlsx.addSheet();
|
|
xlsx.write(2, 2, "Hello Qt Xlsx");
|
|
xlsx.addSheet();
|
|
xlsx.write(3, 3, "This will be deleted...");
|
|
|
|
xlsx.addSheet("HiddenSheet");
|
|
xlsx.currentSheet()->setHidden(true);
|
|
xlsx.write("A1", "This sheet is hidden.");
|
|
|
|
xlsx.addSheet("VeryHiddenSheet");
|
|
xlsx.sheet("VeryHiddenSheet")->setSheetState(AbstractSheet::SS_VeryHidden);
|
|
xlsx.write("A1", "This sheet is very hidden.");
|
|
|
|
xlsx.saveAs("worksheetoperations1.xlsx");
|
|
//![Create a xlsx file]
|
|
|
|
Document xlsx2("worksheetoperations1.xlsx");
|
|
//![add_copy_move_delete]
|
|
xlsx2.renameSheet("Sheet1", "TheFirstSheet");
|
|
|
|
xlsx2.copySheet("TheFirstSheet", "CopyOfTheFirst");
|
|
|
|
xlsx2.selectSheet("CopyOfTheFirst");
|
|
xlsx2.write(25, 2, "On the Copy Sheet");
|
|
|
|
xlsx2.deleteSheet("Sheet3");
|
|
|
|
xlsx2.moveSheet("Sheet2", 0);
|
|
//![add_copy_move_delete]
|
|
|
|
//![show_hidden_sheets]
|
|
xlsx2.sheet("HiddenSheet")->setVisible(true);
|
|
xlsx2.sheet("VeryHiddenSheet")->setVisible(true);
|
|
//![show_hidden_sheets]
|
|
|
|
xlsx2.saveAs("worksheetoperations2.xlsx");
|
|
return 0;
|
|
}
|