在mac環(huán)境中將上面的excel轉(zhuǎn)成plist:

1.將表格拷貝到文本編輯器中,去除掉第一行的Countries and Regions,?國家或地區(qū),?國際域名縮寫,電話代碼,時差等文字(注意,最后一行也不能留空白,否則代碼轉(zhuǎn)換會讀取不到,發(fā)生崩潰)

2.在文本編輯器中按下快捷鍵:shift?+command?+T.

再保存的時候就會出現(xiàn)(轉(zhuǎn)換成utf-8編碼):

3.將保存的文件加入工程中,并使用如下代碼進行轉(zhuǎn)換

NSString*alarmPath = [[NSBundlemainBundle]pathForResource:@"countrycode"ofType:@"txt"];

//NSLog(@"%@",alarmPath);

//嘗試更換文件編碼，失敗

//NSStringEncoding gbk = CFStringConvertEncodingToNSStringEncoding(kCFStringEncodingGB_18030_2000);

NSString*alarmContent = [[NSStringalloc]initWithContentsOfFile:alarmPathencoding:NSUTF8StringEncodingerror:nil];

//NSLog(@"%@",alarmContent);

NSArray*alarmArray = [alarmContentcomponentsSeparatedByCharactersInSet:[NSCharacterSetnewlineCharacterSet]];

//NSLog(@"%@",alarmArray);

NSString*docuPath = [NSHomeDirectory()stringByAppendingPathComponent:@"Documents"];

NSString*plistPath = [docuPathstringByAppendingPathComponent:@"countryCode.plist"];

NSLog(@"%@",plistPath);

NSMutableArray*resultsArr = [NSMutableArrayarray];

for(NSIntegerj =0; j < alarmArray.count; j++){

NSString*alarmStr = [alarmArrayobjectAtIndex:j];

//NSLog(@"%@",alarmStr);

NSArray*alarmArr = [alarmStrcomponentsSeparatedByString:@"\t"];

[resultsArraddObject:@{@"country":[alarmArrobjectAtIndex:0],@"Chinese":[alarmArrobjectAtIndex:1],@"abbr":[alarmArrobjectAtIndex:2],@"code":[alarmArrobjectAtIndex:3],@"jetLag":[alarmArrobjectAtIndex:4]}];

}

[resultsArrwriteToFile:plistPathatomically:YES];

結(jié)束;