iOS-Excel文件创建
导入 libxlsxwriterPodfile 文件添加如下示例,终端cd到项目文件夹,执行 pod install
pod 'libxlsxwriter'引用
导入头文件
#import <xlsxwriter/xlsxwriter.h>创建Excel
- (void)createExcel1Random{
NSString *fileName = [ stringByAppendingPathComponent:@"demo_k.xlsx"];
if ([ fileExistsAtPath:fileName] ) {
[ removeItemAtPath:fileName error:nil];
}
NSLog(@"fileName = %@",fileName);
// 创建新xlsx文件,路径需要转成c字符串
lxw_workbook*workbook= workbook_new();
// 创建一个sheet
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, [@"tem_data" UTF8String] );
///设置列宽
worksheet_set_column(worksheet, COLS("A:A"), 1.5, NULL);
///序列
worksheet_set_column(worksheet, COLS("B:B"), 15, NULL);
///数据列
worksheet_set_column(worksheet, COLS("C:C"), 50, NULL);
///行高
worksheet_set_row(worksheet, 0, 10, nil);
worksheet_set_row(worksheet, 1, 16.8, nil);
worksheet_set_row(worksheet, 2, 16.8, nil);
lxw_format *format = ;
for (int i = 0; i < 20; i++) {
NSString *ran = [ uppercaseString];
uint32_t lxw_row_t = (uint32_t)(i);
worksheet_write_string(worksheet, lxw_row_t + 1, 0 + 1, [ UTF8String], format);
worksheet_write_string(worksheet, lxw_row_t + 1, 1 + 1, , format);
}
workbook_close(workbook);
NSLog(@"fileName = %@",fileName);
}
/// 一般单元格样式
/// @param workbook lxw_format
- (lxw_format *)generalCellAttribute:(lxw_workbook *)workbook{
lxw_format *format = workbook_add_format(workbook);
format_set_border(format, LXW_BORDER_THIN);// 边框(四周):中宽边框
// 加粗
format_set_bold(format);
//颜色
format_set_font_color(format, LXW_COLOR_BLACK);
// 水平居中
format_set_align(format, LXW_ALIGN_CENTER);
//垂直居中
format_set_align(format, LXW_ALIGN_VERTICAL_CENTER);
//设置单元格格式
/*
format_set_num_format(format, "¥#,##0.00");
*/
return format;
}
- (void)createExcel2Random{
NSString *fileName = [ stringByAppendingPathComponent:@"demo_k.xlsx"];
if ([ fileExistsAtPath:fileName] ) {
[ removeItemAtPath:fileName error:nil];
}
NSLog(@"fileName = %@",fileName);
// 创建新xlsx文件,路径需要转成c字符串
lxw_workbook*workbook= workbook_new();
// 创建一个sheet
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, [@"tem_data" UTF8String] );
///设置列宽
worksheet_set_column(worksheet, COLS("A:A"), 1.5, NULL);
///序列
worksheet_set_column(worksheet, COLS("B:B"), 15, NULL);
///数据列
worksheet_set_column(worksheet, COLS("C:C"), 50, NULL);
///行高
worksheet_set_row(worksheet, 0, 10, nil);
worksheet_set_row(worksheet, 1, 16.8, nil);
worksheet_set_row(worksheet, 2, 16.8, nil);
/*合并4个单元格。*/
worksheet_merge_range(worksheet, 1, 1, 2, 2, [@"合并单元格" UTF8String], );
lxw_format *format = ;
for (int i = 0; i < 20; i++) {
NSString *ran = [ uppercaseString];
uint32_t lxw_row_t = (uint32_t)(i);
worksheet_write_string(worksheet, lxw_row_t + 3, 0 + 1, [ UTF8String], format);
worksheet_write_string(worksheet, lxw_row_t + 3, 1 + 1, , format);
}
workbook_close(workbook);
NSLog(@"fileName = %@",fileName);
}
/// 合并单元格样式
/// @param workbook lxw_format
- (lxw_format *)mergeCellAttribute:(lxw_workbook *)workbook{
lxw_format *merge_format = workbook_add_format(workbook);
/* 为合并范围配置格式。*/
//合并居中(左右)
format_set_align(merge_format, LXW_ALIGN_CENTER);
//合并居中(上下)
format_set_align(merge_format, LXW_ALIGN_VERTICAL_CENTER);
//字体加粗
format_set_bold(merge_format);
//字体颜色
format_set_font_color(merge_format,LXW_COLOR_BLACK);
//字体大小
format_set_font_size(merge_format, 16.0);
//背景颜色
format_set_bg_color(merge_format, LXW_COLOR_GRAY);
//边框样式
format_set_border(merge_format, LXW_BORDER_MEDIUM);
return merge_format;
}
相关格式
/* 创建新工作簿。*/
lxw_workbook *workbook = workbook_new("format_font.xlsx");
/* 添加工作表。*/
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
/* 扩大第一列,使文本更清晰。*/
worksheet_set_column(工作表,0,0,20,NULL);
/* 添加一些格式。*/
lxw_format *format1 = workbook_add_format(workbook);
lxw_format *format2 = workbook_add_format(workbook);
lxw_format *format3 = workbook_add_format(workbook);
/* 为格式1设置粗体属性。*/
format_set_bold(format1);
/* 为格式2设置斜体属性。*/
format_set_italic(format2);
/* 为格式3设置粗体和斜体属性。*/
format_set_bold(格式3);
format_set_italic(format3);
/*写一些格式化的字符串。*/
worksheet_write_string(工作表,0,0,“这是粗体”,格式1);
worksheet_write_string(工作表,1,0,“这是斜体”,格式2);
worksheet_write_string(工作表,2,0,“粗体和斜体”,格式3);
/* 关闭工作簿,保存文件并释放任何内存。*/
workbook_close(工作簿); 导出Excel
- (void)exportExcel{
NSString *filePath = [ stringByAppendingPathComponent:@"demo_k.xlsx"];
if ([ fileExistsAtPath:filePath] ) {
NSURL *url = ;
_documentController = ;
_documentController.delegate = self;
;
}
else{
NSLog(@"没有文件");
}
}
- (void)openDocumentMenu{
; // 菜单操作
}
官方文档
libxlsxwriter 使用说明文档
libxlsxwriter 使用文档及示例
https://www.cnblogs.com/wangkejia/p/15813165.html
页:
[1]