C++ 使用 Spire.XLS 将 MYSQL_ROW 数据写入 Excel 文件

"void exltest(MYSQL_ROW twoDimensionalArray)\n{\n\tprintf("exltest\n");\n\n\t//指定输出文件路径和名称\n\twstring outputPath = L"C:\Users\gxyz\Desktop\" ;\n\twstring outputFile = outputPath + L"test485.xlsx" ;\n\n\t//创建一个Workbook对象\n\tWorkbook* workbook = new Workbook();\n\n\t//获取第一个工作表\n\t//Worksheet* sheet = workbook->GetWorksheets()->Get(0);\n\tboost::intrusive_ptrSpire::Xls::XlsWorksheet sheet = workbook->GetWorksheets()->Get(0);\n\n\t//创建一维数组\n\twstring oneDimensionalArray[12] = { L"编号", L"v0", L"v1", L"v2", L"v3", L"v4", L"v5", L"v6", L"v7", L"v8", L"v9", L"v10" };\n\n\t//将数组转换为向量\n\tvector vec; \n\tfor (size_t i = 0; i < sizeof(oneDimensionalArray) / sizeof(oneDimensionalArray[0]); i++)\n\t{\n\t vec.push_back(oneDimensionalArray[i].c_str());\n\t}\n\n\t//将向量插入工作表\n\tsheet->InsertArray(vec, 1, 1, false);\n\n\t//创建一个二维数组\n\t/\n\twstring twoDimensionalArray[2][12] = {\n\t {L"", L"", L"", L"", L"", L"", L"", L"", L"", L"", L"", L""}\n\t};/\n\n\t//获取行号和列号\n\t//int rowNum = sizeof(twoDimensionalArray) / sizeof(twoDimensionalArray[0]);\n\t//int columnNum = sizeof(twoDimensionalArray[0]) / sizeof(twoDimensionalArray[0][0]);\n\n\t//将二维数组拆分为多个一维向量\n\t\n\tfor (size_t i = 0; i < 1; i++)\n\t{\n\t vector vec_temp; \n\t for (size_t j = 0; j < 12; j++)\n\t {\n\t vec_temp.push_back(twoDimensionalArray[i][j]);\n\t }\n\n\t //将向量插入工作表\n\t sheet->InsertArray(vec_temp, 4 + i, 1, false);\n\t}\n\t/\n\tfor (int i = 0; i < rowNum; i++) {\n\t for (int j = 0; j < columnNum; j++) {\n\t sheet->SetCellValue(i + 1, j + 1, twoDimensionalArray[i][j]); //此处报错\n\t }\n\t}/\n\tprintf("**************\n");\n\n\t//自动调整列宽\n\tsheet->GetAllocatedRange()->AutoFitColumns();\n\n\t//将样式应用于第一行\n\t//CellStyle style = workbook->GetStyles()->Add(L"newStyle" );\n\tboost::intrusive_ptrSpire::Xls::CellStyle style = workbook->GetStyles()->Add(L"newStyle" );\n\tstyle->GetFont()->SetIsBold(true);\n\t//sheet->GetRange(1, 1, 1, 6)->SetStyle(style);\n\t//sheet->GetRange(4, 1, 4, 5)->SetStyle(style);\n\tsheet->GetRange()->SetStyle(style);\n\tsheet->GetRange()->SetStyle(style);\n\n\t//保存文件\n\tworkbook->SaveToFile(outputFile.c_str(), ExcelVersion::Version2016);\n\tworkbook->Dispose();\n}