Excel转Plist

最新推荐文章于 2023-05-19 10:53:08 发布

端_木

最新推荐文章于 2023-05-19 10:53:08 发布

阅读量2.5k

点赞数

分类专栏： iOS

本文链接：https://blog.csdn.net/quanqinyang/article/details/72845578

版权

iOS 专栏收录该内容

308 篇文章 1 订阅

订阅专栏

将excel文件转化为plist文档

1、把 excel 文件转换成.csv文件，mac下直接使用numbers软件就可以实现，文件-->导出到 csv。

操作时保留excel 文件中的第一行的列名。

2、具体的代码：

NSString *iOSPath = [[NSBundle mainBundle] pathForResource:@"test" ofType:@"csv"];
    NSString *content = [NSString stringWithContentsOfFile:iOSPath encoding:NSUTF8StringEncoding error:nil];
    NSArray *baseStationInfoArr= [content componentsSeparatedByCharactersInSet:[NSCharacterSet newlineCharacterSet]];
    NSString *names = [baseStationInfoArr objectAtIndex:0];
    NSMutableArray *baseStations = [baseStationInfoArr mutableCopy];
    [baseStations removeObjectAtIndex:0];
    NSMutableArray *allPlists = [NSMutableArray array];
    //    NSString *plistPath = [[NSBundle mainBundle] pathForResource:@"baseStation" ofType:@"plist"];
    NSString *plistPath = [NSHomeDirectory() stringByAppendingPathComponent:@"Documents/test2.plist"];
   
    for (int i = 0; i < baseStations.count; i++) {
        
        if (i % 2 == 0) {
            continue;
        }
        NSArray *allTitle = [names componentsSeparatedByString:@","];
        NSArray *allContents = [baseStations[i] componentsSeparatedByString:@","];
        NSMutableDictionary *dic = [NSMutableDictionary dictionary];
        for (int j = 0; j < allContents.count; j++) {
            [dic setObject:allContents[j] forKey:allTitle[j]];
        }
        [allPlists addObject:dic];
    }
    [allPlists writeToFile:plistPath atomically:YES];