windows下一个好用的exel表格操作库c++

以你之姓@ 2023-02-23 08:24 30阅读 0赞

这个库是libxl,可以去官网下载，也可以用破解（仅供学习，不可用于商业，如用官方产生法律纠纷，概不负责）  
我这边是动态库libxl.dll 和libxl.lib 还有include  
因为是动态库所以不管vs20xx还是debug/release/win32/x64都可以用，  
具体查看我的下载管理  
《libxl综合文件》  
或者百度网盘：  
https://pan.baidu.com/s/1Aff6yNwy8t4oM4f4sIi4rQ  
提取码：1eg9  
二维码  
![在这里插入图片描述][20200706152325906.png]

下面是我写的一个简单案例，基本包括了表格建立，写表格，保存等操作，可以作为参考：

// ConsoleApplication1.cpp : 定义控制台应用程序的入口点。
    //
    
    #include "stdafx.h"
    #include "libxl.h"
    #include <string>
    #include <stdio.h>
    #include <time.h>
    #include <IBookT.h>
    #include <iostream>
    #include <vector>
    #include <list>
    
    using namespace std;
    using namespace libxl;
    
    
    int main()
    { 
    	list<vector<string>> excel_content;
    	vector<string> vec_header;
    	vec_header.push_back("序号");
    	vec_header.push_back("信息");
    	vec_header.push_back("时间");
    	vec_header.push_back("设备");
    	vec_header.push_back("位置");
    	vec_header.push_back("备注");
    	vec_header.push_back("备注时间");
    	vec_header.push_back("处理人");
    
    	vector<int> col_width_vec;
    	col_width_vec.push_back(25);
    	col_width_vec.push_back(25);
    	col_width_vec.push_back(25);
    	col_width_vec.push_back(25);
    	col_width_vec.push_back(25);
    	col_width_vec.push_back(30);
    	col_width_vec.push_back(25);
    	col_width_vec.push_back(25);
    
    	excel_content.push_back(vec_header);
    	
    	for (int i = 0; i < 10; ++i)//10随便写的一个
    	{ 
    		vector<string> vec;
    		vec.push_back("something");
    		vec.push_back("other some things.");
    		excel_content.push_back(vec);
    	}
    
    	//----------------------
    	int t = time(NULL);
    	string basename = "exel";
    	string xls_name = ".\\"+basename+".xlsx";
    
    	Book* xls_book = xlCreateXMLBook();
    	if (xls_book == nullptr) { 
    		cout<<"create xls file error"<<endl;
    		return 1;
    	}
    	xls_book->setKey("Halil Kural", "windows-2723210a07c4e90162b26966a8jcdboe");
    	Sheet* sheet = xls_book->addSheet("Sheet1");//添加一个工作表
    	if (sheet == nullptr)
    	{ 
    		cout<<"create sheet in excel fail error"<<endl;
    		return 1;
    	}
    
    	Format* cell_format = xls_book->addFormat();
    	cell_format->setAlignH(AlignH::ALIGNH_CENTER);
    	cell_format->setAlignV(AlignV::ALIGNV_CENTER);
    	cell_format->setBorder(BORDERSTYLE_DASHDOT);
    
    	std::vector<int> column_width_vec= col_width_vec;
    	for (int i = 0; i < column_width_vec.size(); ++i)
    	{ 
    		sheet->setCol(i, i, column_width_vec[i]);
    	}
    
    	int i = 0;
    	int j = 0;
    	std::list<std::vector<std::string>> content_list= excel_content;
    	auto it = content_list.begin();
    	for (; it != content_list.end(); ++it, ++i)
    	{ 
    		vector<string> vec = *it;
    		for (j = 0; j < vec.size(); ++j)
    		{ 
    			sheet->writeStr(i, j, vec[j].c_str(), cell_format);
    		}
    	}
    
    	if (!xls_book->save(xls_name.c_str()))
    	{ 
    		cout<<"fail to save excel"<<endl;
    		return -1;
    	}
        return 0;
    }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzM2MDcwNw_size_16_color_FFFFFF_t_70]

[20200706152325906.png]: https://img-blog.csdnimg.cn/20200706152325906.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzM2MDcwNw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200706145937313.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzM2MDcwNw==,size_16,color_FFFFFF,t_70