本篇文章属于《518抽奖软件开发日志》系列文章的一部分。

我在开发《518抽奖软件》（）的时候，需要支持导出名单、抽奖结果等到excel表格。找到几个写表格的开源库，但是有的收费有的不好用，最终用的libxlsxwriter这个只能写xlsx的开源库，代码如下。

#include "zlib.h"#include "xlsxwriter.h"#pragma comment(lib, "zlibstatic.lib")#pragma comment(lib, "xlsxwriter.lib")lxw_workbook* workbook = workbook_new(fileA);lxw_worksheet* worksheet = workbook_add_worksheet(workbook, NULL);lxw_format* fmtL = workbook_add_format(workbook);lxw_format* fmtR = workbook_add_format(workbook);lxw_format* fmtC = workbook_add_format(workbook);format_set_align(fmtL, LXW_ALIGN_LEFT);format_set_align(fmtR, LXW_ALIGN_RIGHT);format_set_align(fmtC, LXW_ALIGN_CENTER);format_set_bg_color(fmtC, 0xd2e9ff);format_set_border(fmtC, LXW_BORDER_THIN);format_set_border_color(fmtC, 0x46a3ff);format_set_bold(fmtC);worksheet_write_string(worksheet, 0, 0, fldA, fmtC);worksheet_write_string(worksheet, 0, 1, fldA, fmtC);worksheet_write_string(worksheet, 0, 2, fldA, fmtC);worksheet_write_string(worksheet, 0, 3, fldA, fmtC);worksheet_merge_range(worksheet, 0, 3, 0, 2 + cxrs.fldNum, fldA, fmtC);lxw_error e = workbook_close(workbook);if (e != LXW_NO_ERROR)	return FALSE;return TRUE;