C++实现将数据写入Excel工作表的示例代码

#include "Spire.Xls.o.h";

using namespace Spire::Xls;

int main() {

    //指定输出文件路径和名称
    std::wstring outputPath = L"输出\\";
    std::wstring outputFile = outputPath + L"将单个值写入单元格.xlsx";

    //创建一个Workbook对象
    Workbook* workbook = new Workbook();

    //获取第一个工作表
    Worksheet* sheet = workbook->GetWorksheets()->Get(0);

    //将文本和数字写入指定的单元格
    sheet->GetRange(1, 1)->SetText(L"名字");
    sheet->GetRange(1, 2)->SetText(L"年龄");
    sheet->GetRange(1, 3)->SetText(L"部门");
    sheet->GetRange(1, 4)->SetText(L"入职日期");
    sheet->GetRange(1, 1)->SetText(L"名字");
    sheet->GetRange(2, 1)->SetText(L"谢殊");
    sheet->GetRange(2, 2)->SetNumberValue(29);
    sheet->GetRange(2, 3)->SetText(L"市场部");
    sheet->GetRange(2, 4)->SetText(L"2018-02-26");
    sheet->GetRange(3, 1)->SetText(L"李强");
    sheet->GetRange(3, 2)->SetNumberValue(30);
    sheet->GetRange(3, 3)->SetText(L"人力资源部");
    sheet->GetRange(3, 4)->SetText(L"2017-07-13");
    sheet->GetRange(4, 1)->SetText(L"高阳");
    sheet->GetRange(4, 2)->SetNumberValue(35);
    sheet->GetRange(4, 3)->SetText(L"策划部");
    sheet->GetRange(4, 4)->SetText(L"2015-04-01");

    //自动调整列宽
    sheet->GetAllocatedRange()->AutoFitColumns();

    //将样式应用于第一行
    CellStyle* style = workbook->GetStyles()->Add(L"newStyle");
    style->GetFont()->SetIsBold(true);
    sheet->GetRange(1, 1, 1, 4)->SetStyle(style);

    //保存文件
    workbook->SaveToFile(outputFile.c_str(), ExcelVersion::Version2016);
    workbook->Dispose();
}

#include "Spire.Xls.o.h";

using namespace Spire::Xls;
using namespace std;

int main() {

    //指定输出文件路径和名称
    wstring outputPath = L"输出\\";
    wstring outputFile = outputPath + L"将数组写入指定的单元格范围.xlsx";

    //创建一个Workbook对象
    Workbook* workbook = new Workbook();

    //获取第一个工作表
    Worksheet* sheet = workbook->GetWorksheets()->Get(0);

    //创建一维数组
    wstring oneDimensionalArray[6] = { L"一月", L"二月", L"三月", L"四月", L"五月", L"六月" };

    //将数组转换为向量
    vector<LPCWSTR> vec;
    for (size_t i = 0; i < sizeof(oneDimensionalArray) / sizeof(oneDimensionalArray[0]); i++)
    {
        vec.push_back(oneDimensionalArray[i].c_str());
    }

    //将向量插入工作表
    sheet->InsertArray(vec, 1, 1, false);

    //创建一个二维数组
    wstring twoDimensionalArray[4][5] = {
        {L"姓名", L"年龄", L"性别", L"部门.", L"联系方式."},
        {L"李刚", L"25", L"男", L"广告部", L"835256"},
        {L"刘兴桐", L"24", L"女", L"运营策划部", L"835583"},
        {L"陈海波", L"26", L"男", L"销售部", L"834176"}
    };

    //获取行号和列号
    int rowNum = sizeof(twoDimensionalArray) / sizeof(twoDimensionalArray[0]);
    int columnNum = sizeof(twoDimensionalArray[0]) / sizeof(twoDimensionalArray[0][0]);

    //将二维数组拆分为多个一维向量
    for (size_t i = 0; i < rowNum; i++)
    {
        vector<LPCWSTR> vec_temp;
        for (size_t j = 0; j < columnNum; j++)
        {
            vec_temp.push_back(twoDimensionalArray[i][j].c_str());
        }

        //将向量插入工作表
        sheet->InsertArray(vec_temp, 4 + i, 1, false);
    }

    //自动调整列宽
    sheet->GetAllocatedRange()->AutoFitColumns();

    //将样式应用于第一行
    CellStyle* style = workbook->GetStyles()->Add(L"newStyle");
    style->GetFont()->SetIsBold(true);
    sheet->GetRange(1, 1, 1, 6)->SetStyle(style);
    sheet->GetRange(4, 1, 4, 5)->SetStyle(style);

    //保存文件
    workbook->SaveToFile(outputFile.c_str(), ExcelVersion::Version2016);
    workbook->Dispose();
}