欢迎来到我的博客#xff0c;一起学习#xff0c;共同进步。

这篇文章主要介绍Excel处理库-libxlsxwriter配置使用。

文章目录

项目Github地址https://github.com/jmcnamara/libxlsxwriter

Wiki地址https://libxlsxwriter.github.io/

libxlsxwriter

文件的C库。

它提供了一系列功能可以让您通过编程方式生成包含单元格、图表、格式化等内容的

Excel

支持创建工作表、单元格、公式、图表、条件格式化、数据筛选等功能。

4.高性能该库被设计为具有高性能在大型数据集的情况下生成速度快。

5.支持多种格式和样式您可以设置单元格的格式、字体、颜色、边框、背景等属性以及应用数值格式、日期格式、公式和函数等。

6.支持图表libxlsxwriter

文件。

可以通过c自带的文件处理来读取处理后的数据再手动导入到最后的表中

环境配置

https://github.com/jmcnamara/libxlsxwriter

libxlsxwriter

workbook_new(demo.xlsx);lxw_worksheet

*worksheet

workbook_add_worksheet(workbook,

NULL);/*

workbook_add_format(workbook);/*

Set

*/worksheet_set_column(worksheet,

20,

*/worksheet_write_string(worksheet,

Hello,

*/worksheet_write_string(worksheet,

World,

*/worksheet_write_number(worksheet,

123,

NULL);worksheet_write_number(worksheet,

123.456,

*/worksheet_insert_image(worksheet,

logo.png);workbook_close(workbook);return

#include

https://www.cnblogs.com/Fred1987/p/17442487.html

main

{std::chrono::time_pointstd::chrono::high_resolution_clock

now

std::chrono::high_resolution_clock::now();time_t

raw_time

std::chrono::high_resolution_clock::to_time_t(now);struct

tm_info

*localtime(raw_time);std::stringstream

ss;ss

(is_exact){std::chrono::seconds

seconds

std::chrono::duration_caststd::chrono::seconds(now.time_since_epoch());std::chrono::milliseconds

mills

std::chrono::duration_caststd::chrono::milliseconds(now.time_since_epoch());std::chrono::microseconds

micros

std::chrono::duration_caststd::chrono::microseconds(now.time_since_epoch());std::chrono::nanoseconds

nanos

std::chrono::duration_caststd::chrono::nanoseconds(now.time_since_epoch());std::uint64_t

mills_count

std::to_string(nanos_count);}return

ss.str();

new_uuid;uuid_generate(new_uuid);uuid_unparse(new_uuid,

uuid_value);return

workbook_new(uuid.xlsx);lxw_worksheet

*worksheet

workbook_add_worksheet(workbook,

NULL);worksheet_set_column(worksheet,0,0,50,NULL);

设置列宽//

headerworksheet_write_string(worksheet,

Header,

NULL);worksheet_write_string(worksheet,

Number,

row){worksheet_write_string(worksheet,

row,

NULL);worksheet_write_number(worksheet,

row,

NULL);}workbook_close(workbook);std::cout

get_time_now(true)

{xlsxwriter_excel(atoi(argv[1]));

读取命令行生成几个uuidreturn

}结合CGAL计算几何库对txt点集进行处理并处理后的数据写入xlsx示例

#include

CGAL/Exact_predicates_inexact_constructions_kernel.h

#include

CGAL::Exact_predicates_inexact_constructions_kernel

typedef

workbook_new(output.xlsx);lxw_worksheet*

worksheet

workbook_add_worksheet(workbook,

NULL);int

0;worksheet_write_number(worksheet,

row,

NULL);worksheet_write_number(worksheet,

row,

NULL);row;}workbook_close(workbook);std::cout

Output