text wrap when creating .csv file with NSMutableArray

Question

I am creating .csv file with following code

-(NSString *)dataFilePath {

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask, YES);
documentsDirectory = [paths objectAtIndex:0];
return [documentsDirectory stringByAppendingPathComponent:@"myfile.csv"];

}
-(void)createfile{

if (![[NSFileManager defaultManager] fileExistsAtPath:[self dataFilePath]]) {
    [[NSFileManager defaultManager] createFileAtPath: [self dataFilePath] contents:nil attributes:nil];
 }
 for (int i=0; i<[arr count]; i++) {
      NSString *_amnt = [[self.reversedArr objectAtIndex:i]  valueForKey:@"amount"];
     writeString = [NSString stringWithFormat:@"%@,%@,%@", [[arr objectAtIndex:i] valueForKey:@"date"], [[arr objectAtIndex:i] valueForKey:@"particular", [NSString stringWithFormat:@"%@\n", _amnt]];


    }
    NSFileHandle *handle;
    handle = [NSFileHandle fileHandleForWritingAtPath: [self dataFilePath] ];
    //say to handle where's the file fo write
    [handle truncateFileAtOffset:[handle seekToEndOfFile]];
    //position handle cursor to the end of file
    [handle writeData:[writeString dataUsingEncoding:NSUTF8StringEncoding]];

}

I am successful to create csv file but I am having a problem when I am opening the .csv file in excel sheet then any row who having more characters , extending its column width according to characters but I need to wrap text with fixed column width , row height should be extend. So what should I do for this task. can any one give suggestion .

Your problem is excel formatting, but you want to handle that by adding carriage returns to your exported data? — Wain
– Wain, Commented Aug 1, 2013 at 6:14
I am using this .csv file in uiwebview and then take printout but when characters is more then column is going more and my .csv is cutting in A4 size paper so In need text wrap of more characters in same row. — Anju
– Anju, Commented Aug 1, 2013 at 6:25
Then you need to add a new line character in your csv for some places where you want to wrap the text. — Dinesh Raja
– Dinesh Raja, Commented Aug 1, 2013 at 6:34

Wain · Accepted Answer · 2013-08-01 06:36:50Z

1

Process each string that is going into your format parameters separately. Check the length. If it is greater than your required length, do something to insert carriage returns (like loop and insert characters in a range stringByReplacingCharactersInRange:withString: or NSMutableString insertString:atIndex:).

answered Aug 1, 2013 at 6:36

Wain

119k15 gold badges132 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

text wrap when creating .csv file with NSMutableArray

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related