How to export SQLite file into CSV file with table format (excel sheet style)

Question

in iphone app, I want to export a SQLite database file to CSV file. (later i attach this file in mail)

that too in a table format ( or exel-sheet format)

I have tried the following logic but it is not like a table format and huge differences in column alignments.

storedataBaseArray = [DataBase selectAllFromDB];

  NSString *CSVstring=@"SNO \t\t\t Index \t\t\t  Definition\n" ;

  NSString *CSVPath,*record;;

   NSString  *temporayCSV= @"" ;

  for(int i=0;i<storedataBaseArray.count ;i++)
  {


        record = [NSString stringWithFormat:@"%@, \t\t\t %@, \t\t\t %@, [ [storedContactsArray objectAtIndex:i] objectForKey"id"] ,  [ [storedContactsArray objectAtIndex:i] objectForKey"title"],  [ [storedContactsArray objectAtIndex:i] objectForKey"Definition"]];

   // NSString *role =[storedContactsArray objectAtIndex:i]  ;

    NSLog(@"%d",i);

    temporayCSV = [NSString stringWithFormat:@"%d  %@  \n ",(i+1),record];

       CSVstring = [CSVstring stringByAppendingFormat:temporayCSV];       
     NSLog(@"%@",CSVstring);

}

  CSVPath = [documentsDirectory stringByAppendingPathComponent:[NSString stringWithFormat:@"%@.csv", @"CSV_FormatedTable"]];

  //add our file to the path
  [fileManager createFileAtPath:CSVPath contents:[CSVstring dataUsingEncoding:NSUTF8StringEncoding] attributes:nil];

  NSData *rolesCSVData =[NSData dataWithContentsOfFile:CSVPath];
  [mailpage addAttachmentData:rolesCSVData mimeType:@"text/csv" fileName:@"CSV_FormatedTable.csv"];

DataBase File:

enter image description here

Required Format:

enter image description here

My Out Put CSV file:

enter image description here

Could any one suggest me how to do this

CSV mail attachments won't display in a tabular format. Generate an additional html attachment with tables done using <table> tags. — melfar
– melfar, Commented Sep 12, 2012 at 11:15

sergio · Accepted Answer · 2012-09-12 10:14:30Z

1

There is no need for using multiple \ts and ,s at the same time.

You can simplify your format like this:

    record = [NSString stringWithFormat:@"%@, %@, %@", [ [storedContactsArray objectAtIndex:i] objectForKey"id"] ,  [ [storedContactsArray objectAtIndex:i] objectForKey"title"],  [ [storedContactsArray objectAtIndex:i] objectForKey"Definition"]];

In any case, you will see a correct alignment only if you open the resulting file in a suitable program, e.g., Excel (and also choose the correct import options). A text editor will not usually display your CSV data in a tabular format. Aside from the way your text editor displays it, the file format is fine.

answered Sep 12, 2012 at 10:14

sergio

69.1k11 gold badges105 silver badges123 bronze badges

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

1 Comment

Anju Over a year ago

yes, you are correct .I have also did with the help of above code. but here I have a question if we have large string in any column then how can we mange it to come in next row with same column. actually i am stuck in this problem. any idea?

Collectives™ on Stack Overflow

How to export SQLite file into CSV file with table format (excel sheet style)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related