(ios开发)导出tableView数据至excel

点击打开链接引言

在网上搜了好多的资料，把数据导出为excel格式，找了好久的资料都没找到。今天就写一篇教程给大家学习，如果有什么问题大家可以联系我。

0、开始的时候因为没有找到导出excel格式的文章，倒是找到了导出csv格式的文件的方法，但是由于中文乱码中文问题，问题一直没有找到好的解决方法。这里我也稍微介绍一下：

- (void)exportCSV:(NSString *)fileName {
    
    
    NSOutputStream *output = [[NSOutputStream alloc] initToFileAtPath:fileName append:YES];
    [output open];
    
    
    if (![output hasSpaceAvailable]) {
        NSLog(@"没有足够可用空间");
    } else {
        
        NSString *header = @"学号,姓名\n";   //这里是文件第一行的头（逗号是换列，\n是换行）

        const uint8_t *headerString = (const uint8_t *)[header cStringUsingEncoding:NSUTF8StringEncoding];
        NSInteger headerLength = [header lengthOfBytesUsingEncoding:NSUTF8StringEncoding];
        NSInteger result = [output write:headerString maxLength:headerLength];
        if (result <= 0) {
            NSLog(@"写入错误");
        }
        
        
        NSArray *students = [self queryStudents];
        for (Student *stu in students) {
           
            NSString *row = [NSString stringWithFormat:@"%@,%@\n", stu.num, stu.name];   //循环插入数据<span style="font-family: Arial, Helvetica, sans-serif;">（逗号是换列，\n是换行）</span>

            const uint8_t *rowString = (const uint8_t *)[row cStringUsingEncoding:NSUTF8StringEncoding];
            NSInteger rowLength = [row lengthOfBytesUsingEncoding:NSUTF8StringEncoding];
            result = [output write:rowString maxLength:rowLength];
            if (result <= 0) {
                NSLog(@"无法写入内容");
            }
            
        }
        
        [output close];
    }
}

生成csv文件：

 NSArray *documents = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDirectory, YES);
    NSString *docementDir = [documents objectAtIndex:0];
    self.filePath = [docementDir stringByAppendingPathComponent:@"Student.csv"];
    NSLog(@"filePath = %@", self.filePath);
    
    
    [self createFile:self.filePath];
    [self exportCSV:self.filePath];

1、现在开始进入正题，要先下载微软的excel库文件 http://www.libxl.com/download.html，解压后

2、里面有example，可以参考一下、把LibXL.framework导入自己的项目当中，设置bitcode为no，以及linker也要改为-lstdc++，如图

3、上代码，导入头文件，设置代理

#include "LibXL/libxl.h"

@interface JGdetailController ()<UITableViewDataSource,UITableViewDelegate,JGPeopleViewDelegate,UIDocumentInteractionControllerDelegate>

<pre name="code" class="objc">-(void)clickBarButton{
    NSLog(@"createExcel");

    BookHandle book = xlCreateBook(); // use xlCreateXMLBook() for working with xlsx files
    
    SheetHandle sheet = xlBookAddSheet(book, "Sheet1", NULL);
    //第一个参数代表插入哪个表，第二个是第几行（默认从0开始），第三个是第几列（默认从0开始）
    xlSheetWriteStr(sheet, 1, 0, "姓名", 0);
    xlSheetWriteStr(sheet, 1, 1, "性别", 0);
    xlSheetWriteStr(sheet, 1, 2, "学校", 0);
    xlSheetWriteStr(sheet, 1, 3, "电话", 0);
    
    
    for (int i = 0; i < self.nameArray.count; i++) {
        const char *name_c = [self.nameArray[i] cStringUsingEncoding:NSUTF8StringEncoding];  //这里是将NSString字符串转为C语言字符串
        xlSheetWriteStr(sheet, i+2, 0,name_c, 0);
       
    }
    for (int i = 0; i < self.sexArray.count; i++) {
        const char *sex_c = [self.sexArray[i] cStringUsingEncoding:NSUTF8StringEncoding];
        xlSheetWriteStr(sheet, i+2, 1,sex_c, 0);
      
    }
    for (int i = 0; i < self.schoolArray.count; i++) {
        const char *school_c = [self.schoolArray[i] cStringUsingEncoding:NSUTF8StringEncoding];
        xlSheetWriteStr(sheet, i+2, 2,school_c, 0);
        
    }
    for (int i = 0; i < self.phoneArray.count; i++) {
        const char *phone_c = [self.phoneArray[i] cStringUsingEncoding:NSUTF8StringEncoding];
        xlSheetWriteStr(sheet, i+2, 3,phone_c, 0);
       
    }

    
    NSString *documentPath =
    [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask, YES) objectAtIndex:0];
    NSString *filename = [documentPath stringByAppendingPathComponent:@"out.xls"];
    NSLog(@"filepath--%@",filename);
    
    xlBookSave(book, [filename UTF8String]);
    
    xlBookRelease(book);
    
    //导出xls文件
    UIDocumentInteractionController *docu = [UIDocumentInteractionController interactionControllerWithURL:[NSURL fileURLWithPath:filename]];
    
    docu.delegate = self;
    CGRect rect = CGRectMake(0, 0, 320, 300);  //这里感觉没什么用
    
    [docu presentOpenInMenuFromRect:rect inView:self.view animated:YES];  //不写可以直接预览
    
    [docu presentPreviewAnimated:YES];  //这句比较坑爹。如果不写这句，只写上面那句会弹出选择支持xls文件的APP。但是如果没写程序就会崩了，还有一个<p class="p1"><span class="s1">                                        //[docu </span><span class="s2">presentOptionsMenuFromRect</span><span class="s1">:rect </span><span class="s2">inView</span><span class="s1">:</span><span class="s3">self</span><span class="s1">.</span><span class="s4">view</span><span class="s1"> </span><span class="s2">animated</span><span class="s1">:</span><span class="s3">YES</span><span class="s1">];可以研究下。</span></p>

}

//doucumentDelegate方法（必须实现，还有几个展示选择系统自带print还是啥的就不说了，可以自己研究下）
- ( UIViewController *)documentInteractionControllerViewControllerForPreview:( UIDocumentInteractionController *)interactionController{
    
    return self;
    
}

4、把模型tableView里面的数据取出来放在数组里：

 self.nameArray = [NSMutableArray array];
        self.sexArray = [NSMutableArray array];
        self.schoolArray = [NSMutableArray array];
         self.phoneArray = [NSMutableArray array];
        for (JGdetail *de in self.people) {
            [self.nameArray addObject:de.name];
            if(de.sex == 0){
                [self.sexArray addObject:@"男"];
            }else if(de.sex == 1){
                [self.sexArray addObject:@"女"];
            }
             [self.schoolArray addObject:de.school];
             [self.phoneArray addObject:de.tel];
        }
        NSLog(@"Array---%@",self.sexArray);

5、这样就可以选择QQ打开生成的xls文件。效果如下，因为这个是要收费的，所以忽略第一行：

好了，我也是个才接触IOS开发，希望这篇文章能帮到大家，转载请指明出处。

这边好久没更新维护了，大家可以去我的博客阅读原文（点击打开链接）
http://download.csdn.net/detail/ningcol/9652601 源码地址

如果你觉得我的创作对您有帮助，非常感谢您的打赏支持