qt打开xls文件_Qt读取Excel之QXlsx

void FlightPlanWid::readExcel(QString path)

{

QXlsx::Document xlsx(path);

QXlsx::Workbook *workBook = xlsx.workbook();

QXlsx::Worksheet *workSheet = static_cast<:worksheet>(workBook->sheet(0));

ui.tableWidget->setRowCount(workSheet->dimension().rowCount());

ui.tableWidget->setColumnCount(23);

QString value;

for (int i = 6; i <= workSheet->dimension().rowCount(); i++)

{

for (int j = 1; j <= workSheet->dimension().columnCount(); j++)

{

QXlsx::Cell *cell = workSheet->cellAt(i, j);

if (cell==NULL) continue;

if (cell->isDateTime())//日期

{

if (cell->dateTime().date().year()==1899) continue;

value = cell->dateTime().toString("yyyy/MM/dd hh:mm");

}