1.將excel內(nèi)容拷貝到txt文件里,將txt文件的格式轉(zhuǎn)換為純文本格式

轉(zhuǎn)換為純文本.png
2.將該txt文件真正的拖入工程, 不然會(huì)選取不到路徑。
拖入的時(shí)候選取124?;蛘?add file。
3.代碼存儲(chǔ)。
NSURL *path = [[NSBundle mainBundle] URLForResource:@"city" withExtension:@"txt"];
NSString *contents = [[NSString alloc] initWithContentsOfURL:path encoding:NSUTF8StringEncoding error:nil];
NSArray *contentsArray = [contents componentsSeparatedByCharactersInSet:[NSCharacterSet newlineCharacterSet]];
NSString *docs = [NSHomeDirectory() stringByAppendingPathComponent:@"city.plist"] ;
NSLog(@"%@",docs);
// 定義數(shù)組
NSMutableArray *arr = [NSMutableArray array];
NSInteger idx;
for (idx = 0; idx < contentsArray.count; idx++) {
NSString* currentContent = [contentsArray objectAtIndex:idx];
// 字符串拆分 制表符
NSArray* timeDataArr = [currentContent componentsSeparatedByCharactersInSet:[NSCharacterSet characterSetWithCharactersInString:@"\t"]];
NSMutableDictionary *dic = [NSMutableDictionary dictionary];
[dic setObject:[timeDataArr objectAtIndex:0] forKey:@"ID"];
[dic setObject:[timeDataArr objectAtIndex:1] forKey:@"Code"];
[dic setObject:[timeDataArr objectAtIndex:2] forKey:@"Name"];
[dic setObject:[timeDataArr objectAtIndex:3] forKey:@"Initials"];
[dic setObject:[timeDataArr objectAtIndex:4] forKey:@"Pinyin"];
[dic setObject:[timeDataArr objectAtIndex:5] forKey:@"AreaCode"];
[arr addObject:dic];
}
// 數(shù)據(jù)寫(xiě)入plist文件
[arr writeToFile:docs atomically:YES];
4.參考文章
http://blog.csdn.net/wildfireli/article/details/7989840