Format excel from code

Vote count:

0

I am writing content to excel as follows :

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSString *filePath = [NSString stringWithFormat:@"%@/%@", documentsDirectory, @"myData.xls"];
    NSLog(@"filePath %@", filePath);

    if (![[NSFileManager defaultManager] fileExistsAtPath:filePath]) { // if file is not exist, create it.
        NSString *finalString = [self prepareText];
        NSError *error;
        [finalString writeToFile:filePath atomically:YES encoding:NSUTF8StringEncoding error:&error];
    }

    if ([[NSFileManager defaultManager] isWritableFileAtPath:filePath]) {
        NSLog(@"Writable");
    }else {
        NSLog(@"Not Writable");
    }  

Following is prepareText :

-(NSString*)prepareText
{
    NSString *maineString = [NSString stringWithFormat:@"%@\n%@\n\n",lblTitle.text, lblSubtitle.text];
    NSMutableDictionary *dict;
    for(NSString *tag in dictTextTableOne.allKeys)
    {
        dict = [dictTextTableOne objectForKey:tag];
        if((int)tag % 2 != 0)
        {
            maineString = [maineString stringByAppendingString:[NSString stringWithFormat:@"\n%@", [[dict allKeys]objectAtIndex:0]]];
        }
        else
        {
            maineString = [maineString stringByAppendingString:[NSString stringWithFormat:@"\%@", [dict objectForKey:[[dict allKeys]objectAtIndex:0]]]];
        }
    }

    for(NSString *tag in dictTextTableTwo.allKeys)
    {
        dict = [dictTextTableTwo objectForKey:tag];
        if((int)tag % 2 != 0)
        {
            maineString = [maineString stringByAppendingString:[NSString stringWithFormat:@"\n%@", [[dict allKeys]objectAtIndex:0]]];
        }
        else
        {
            maineString = [maineString stringByAppendingString:[NSString stringWithFormat:@"\%@", [dict objectForKey:[[dict allKeys]objectAtIndex:0]]]];
        }
    }

    return maineString;
}  

This creates excel in following format :

And what I want is as follows :

So there are three challenges I am facing :

• 
  

  Merge cells for headings

  
  


• 
  

  Centre align the text for heading

  
  


• 
  

  Go to next column

  
  

asked 43 secs ago

Nitish

3,933

Format excel from code