思路

將數(shù)據(jù)源拼成字符串，每組（行）數(shù)據(jù)用\n隔開，每組數(shù)據(jù)中每個數(shù)據(jù)之間用\t隔開，然后采用utf16的編碼格式生成NSData類型的數(shù)據(jù)，存儲為.xls后綴的文件。

姓名\t 年齡 \t身高\t體重\n
xxx1\t 19 \t 180\t56 \n
xxx2\t 20 \t 175\t78 \n

代碼實現(xiàn)

#import <Foundation/Foundation.h>
#import "HJXLSTitleModle.h"

@interface HJXLSManager : NSObject

/**
 *  @Author A, 2017-3-17 9:00:00
 *
 *  生成Excel文件
 *
 *  @param titles HJXLSTitleModle類型的數(shù)組，
 *   HJXLSTitleModle用于存儲標題，和對應(yīng)模型數(shù)據(jù)中的key
 *  
 *  @param datas 數(shù)據(jù)模型數(shù)組
 *
 *  @return BOOL 生成是否成功
 */

+(BOOL)createXLSFileTitles:(NSArray <HJXLSTitleModle *>*)titles datas:(NSArray *)datas fileName:(NSString *)name;

/**
 *  @Author A, 2017-3-17 9:00:00
 *
 *  通過名字獲取ecel文件
 *
 *
 *  @return excel文件data數(shù)據(jù)
 */
+(NSData *)XLSFileWithFileName:(NSString *)Name;

+(NSString *)xlsFilePath;


@end


#import "HJBasicModle.h"

@interface HJXLSTitleModle : HJBasicModle
@property (nonatomic,copy) NSString *name;
@property (nonatomic,copy) NSString *key;

-(instancetype)initWithName:(NSString *)name key:(NSString *)key;
@end

titles也可以字典，字典key為模型的屬性名，字典value為標題名稱。因為字典是無序的，所以標題名稱也是無序的，所以這里我采用數(shù)組存儲這個標題名稱。

#import "HJXLSManager.h"

@implementation HJXLSManager

+(NSString *)xlsFilePath{
    NSString *documentPath = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES).firstObject;
    NSString *xlsDirPath = [documentPath stringByAppendingPathComponent:@"xlsFile"];
    if (![[NSFileManager defaultManager] fileExistsAtPath:xlsDirPath]) {
        [[NSFileManager defaultManager] createDirectoryAtPath:xlsDirPath withIntermediateDirectories:YES attributes:nil error:nil];
    }
    return xlsDirPath;
}



+(BOOL)createXLSFileTitles:(NSArray <HJXLSTitleModle *>*)titles datas:(NSArray *)datas fileName:(NSString *)name{
    if (!titles) {
        return NO;
    }
    NSString *fileName = name?[name stringByAppendingString:@".xls"]:@"excel.xls";
    NSMutableArray *xlsDataMuArr = [NSMutableArray array];
    //插入標題
    for (HJXLSTitleModle *modle in titles) {
        [xlsDataMuArr addObject:modle.name];
        //插入制表符
        [xlsDataMuArr addObject:@"\t"];
    }
    //插入數(shù)據(jù)
    [xlsDataMuArr replaceObjectAtIndex:xlsDataMuArr.count-1 withObject:@"\n"];//換行
    for (id subData in datas) {
        for (HJXLSTitleModle *modle in titles) {
            NSString *objectString = [subData valueForKey:modle.key];
            [xlsDataMuArr addObject:[self XLSString:objectString]];
            [xlsDataMuArr addObject:@"\t"];
        }
        [xlsDataMuArr replaceObjectAtIndex:xlsDataMuArr.count-1 withObject:@"\n"];
    }
    NSString *xlsString = [xlsDataMuArr componentsJoinedByString:@""];
    NSData *xlsData = [xlsString dataUsingEncoding:NSUTF16StringEncoding];
    NSFileManager *fileManager = [NSFileManager defaultManager];
    return [fileManager createFileAtPath:[[self xlsFilePath] stringByAppendingPathComponent:fileName] contents:xlsData attributes:nil];
}

+(NSString *)XLSString:(NSString *)string{
    return string?:@"null";
}

+(NSData *)XLSFileWithFileName:(NSString *)Name{
    NSString *filePath = [[self xlsFilePath] stringByAppendingPathComponent:[Name stringByAppendingString:@".xls"]];
    return [[NSData alloc] initWithContentsOfFile:filePath];
}

@end

使用

 HJXLSTitleModle *modle1 = [[HJXLSTitleModle alloc] initWithName:@"名字" key:@"name"];
    HJXLSTitleModle *modle2 = [[HJXLSTitleModle alloc] initWithName:@"年齡" key:@"age"];
    HJXLSTitleModle *modle3 = [[HJXLSTitleModle alloc] initWithName:@"身高" key:@"height"];
    HJXLSTitleModle *modle4 = [[HJXLSTitleModle alloc] initWithName:@"體重" key:@"weight"];
    HJCeShiModle *dataModle1 = [[HJCeShiModle alloc] initWithName:@"xxx1" age:@"19" height:@"180" weight:@"56"];
    HJCeShiModle *dataModle2 = [[HJCeShiModle alloc] initWithName:@"xxx2" age:@"20" height:@"175" weight:@"78"];
    
    BOOL flag = [HJXLSManager createXLSFileTitles:@[modle1,modle2,modle3,modle4] datas:@[dataModle1,dataModle2] fileName:@"資料"];

生成的Excel文件如下：