最近做一個項(xiàng)目,需要把時延以表格的形式輸出信认,方便后續(xù)的數(shù)據(jù)可視化串稀。
```objectivec
-(void)xlsData{
? ? NSUserDefaults *userDef = [NSUserDefaults standardUserDefaults];
? ? NSMutableArray? *xlsDataMuArr = [[NSMutableArray alloc] init];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? [xlsDataMuArr addObject:@" "];
? ? for (int i = 1; i < 100; i++) {
? ? ? ? [xlsDataMuArr addObject:@"0"];
? ? ? ? [xlsDataMuArr addObject:@"1"];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? ? ? [xlsDataMuArr addObject:@" "];
? ? }
? ? NSString *fileContent = [xlsDataMuArr componentsJoinedByString:@"\t"];
? ? NSMutableString *muStr = [fileContent mutableCopy];
? ? NSMutableArray *subMuArr = [NSMutableArray array];
? ? for (int i = 0; i < muStr.length; i ++) {
? ? ? ? NSRange range = [muStr rangeOfString:@"\t" options:NSBackwardsSearch range:NSMakeRange(i, 1)];
? ? ? ? if (range.length == 1) {
? ? ? ? ? ? [subMuArr addObject:@(range.location)];
? ? ? ? }
? ? }
? ? for (NSUInteger i = 0; i < subMuArr.count; i ++) {
? ? ? ? if ( i > 0 && (i%16 == 0) ) {
? ? ? ? ? ? [muStr replaceCharactersInRange:NSMakeRange([[subMuArr objectAtIndex:i-1] intValue], 1) withString:@"\n"];
? ? ? ? }
? ? }
? ? NSFileManager *fileManager = [[NSFileManager alloc]init];
? ? NSData *fileData = [muStr dataUsingEncoding:NSUTF16StringEncoding];
? //? NSString *path = NSHomeDirectory();
? ? NSString *filePath = @"/Users/zags k/Desktop/exportVideo.xls";
? ? NSLog(@"文件路徑:\n%@",filePath);
? ? [fileManager createFileAtPath:filePath contents:fileData attributes:nil];
}
```
這個代碼太好用了,直接粘貼就可以狮杨,內(nèi)容自己填母截!再也不用手動輸入數(shù)據(jù)了。