iOS开发excel转plist文件

将excel用Numbers打开,删除表头等多余的行/列,转换成CSV,然后新建一个工程,使用模拟器运行起来，找到打印的路径：docs，前往文件夹，将该路径复制进去，即可找到转换后的plist文件

1. - (void)viewDidLoad {
2. [super viewDidLoad];
3. [self writeToPlist];
4. }
6. - (void)writeToPlist {
7. NSString *path = [[NSBundle mainBundle] pathForResource:@"高德地图API 城市编码表 2" ofType:@"csv"];
8. NSString *contents = [[NSString alloc] initWithContentsOfFile:path encoding:NSUTF8StringEncoding error:nil];
9. NSLog(@"%@",contents);
11. NSArray *contentsArray = [contents componentsSeparatedByString:@"\r\n"];
12. NSString *docs = [NSHomeDirectory() stringByAppendingPathComponent:@"shortcuts.plist"];
13. NSLog(@"路径：%@", docs);
14. NSMutableArray *arr = [[NSMutableArray alloc] init];
15. for (NSInteger idx = 0 ; idx < contentsArray.count; idx++) {
16. NSString* currentContent = [contentsArray objectAtIndex:idx];
17. if(currentContent.length > 0) {
18. NSArray *timeDataArr = [currentContent componentsSeparatedByCharactersInSet:[NSCharacterSet characterSetWithCharactersInString:@","]];
19. NSMutableDictionary *dic = [[NSMutableDictionary alloc] init];
20. [dic setObject:[timeDataArr objectAtIndex:0] forKey:@"postCode"];
21. [dic setObject:[timeDataArr objectAtIndex:1] forKey:@"locationName"];
22. [dic setObject:[timeDataArr objectAtIndex:2] forKey:@"phoneCode"];
23. [arr addObject:dic];
24. }
25. }
26. [arr writeToFile:docs atomically:YES];
27. }

部分操作图：