iOS 中将数据导出成Excel文件 ---- libxlsxwriter框架

1.使用cocoapods导入libxlsxwriter

pod libxlsxwriter

在桥接文件中导入头文件
#import <xlsxwriter.h>

2.创建文件路径

let documentPath = NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true).first!
let filePath = (documentPath as NSString).appendingPathComponent("标题.xlsx")
print(filePath)

3.创建表格并添加标题

let workbook = workbook_new(filePath)
let worksheet = workbook_add_worksheet(workbook, "工作表1")
worksheet_write_string(worksheet, 0, 0, "时间", nil)
worksheet_write_string(worksheet, 0, 1, "值", nil)
worksheet_write_string(worksheet, 0, 2, "阶段", nil)

4.往表格中写入数据

for (index,dic) in datas.enumerated() {
  let time = "\(dic["time"] ?? "")"
  let value = "\(dic["value"] ?? "0.0")"
  let real_value = "\(NSDecimalNumber(string: value).floatValue)"
  let desc = "\(dic["desc"] ?? "")"
 
    /*第一个参数是工作表
    第二个参数是行数（索引从0开始）
    第三个参数是列数（索引从0开始）
    第四个参数是写入的内容
    第五个参数是单元格样式，可为NULL。*/
   worksheet_write_string(worksheet, lxw_row_t(index + 1), 0, time, nil)
   worksheet_write_string(worksheet, lxw_row_t(index + 1), 1, real_value, nil)
   worksheet_write_string(worksheet, lxw_row_t(index + 1), 2, desc, nil)
   worksheet_set_column(worksheet, 0, 2, 20, nil)
}
workbook_close(workbook)

5.代码汇总

let documentPath = NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true).first!
let filePath = (documentPath as NSString).appendingPathComponent("标题.xlsx")
print(filePath)

let workbook = workbook_new(filePath)
let worksheet = workbook_add_worksheet(workbook, "工作表1")
worksheet_write_string(worksheet, 0, 0, "时间", nil)
worksheet_write_string(worksheet, 0, 1, "值", nil)
worksheet_write_string(worksheet, 0, 2, "阶段", nil)

for (index,dic) in datas.enumerated() {
  let time = "\(dic["time"] ?? "")"
  let value = "\(dic["value"] ?? "0.0")"
  let real_value = "\(NSDecimalNumber(string: value).floatValue)"
  let desc = "\(dic["desc"] ?? "")"
   worksheet_write_string(worksheet, lxw_row_t(index + 1), 0, time, nil)
   worksheet_write_string(worksheet, lxw_row_t(index + 1), 1, real_value, nil)
   worksheet_write_string(worksheet, lxw_row_t(index + 1), 2, desc, nil)
   worksheet_set_column(worksheet, 0, 2, 20, nil)
}
workbook_close(workbook)

还可以设置表格的各种样式，如水平居中，垂直居中，边框等有需要的话可以在框架中自己查看摸索吧
在系统自带的 文件app 中打开查看Excel文件