标题:xlsx 计算公式
作者:zhouxining
日期:2020-02-11 17:23
内容:
采用qtxlsxwriter进行xlsx操作，
QXlsx::Document xlsx("test01.xlsx"); QXlsx::Workbook *workBook = xlsx.workbook(); QXlsx::Worksheet *workSheet = dynamic_cast(workBook->sheet(0)); xlsx.write("B1", ui->lineEdit_2->text().toDouble()); xlsx.write("B2", 30); xlsx.write("B3", 50); xlsx.write("A4", "SUM(B1:B3)="); xlsx.write("B4", [color=#0080 ..