通过代码将Excel的数据转换成plist文件

1.将Excel的文件另存为.csv文件
2.使用文本编辑打开.csv

image.png

3.新建一个文本编辑的文档，使用制作纯文本的模式

image.png

image.png

6.如果Excel中存在这些不必要的导入内容，可以直接删除。

image.png

    NSString *path = [[NSBundle mainBundle] pathForResource:@"未命名" ofType:@"txt"];
    NSString *contents = [[NSString alloc] initWithContentsOfFile:path encoding:NSUTF8StringEncoding error:nil];
    
    NSArray *contentsArray = [contents componentsSeparatedByString:@"\n"];
    NSString *docs = [NSHomeDirectory() stringByAppendingPathComponent:@"content.plist"];
    NSLog(@"%@",docs);//这里打印的路径为生成的plist的路径地址
    NSMutableArray *arr = [[NSMutableArray alloc] init];
    for (int i = 0; i < contentsArray.count; i++) {
        NSString *currentContent = [contentsArray objectAtIndex:i];
        NSArray *timeDataArr = [currentContent componentsSeparatedByCharactersInSet:[NSCharacterSet characterSetWithCharactersInString:@","]];
        NSMutableDictionary *dic = [[NSMutableDictionary alloc] init];
        [dic setObject:[timeDataArr objectAtIndex:1] forKey:@"code"];
        [dic setObject:[timeDataArr objectAtIndex:2] forKey:@"nationality"];
        [arr addObject:dic];
    }
    [arr writeToFile:docs atomically:YES];

image.png