stephen999uk
New Member
I'm using the following code, to create an *.xls file on my iOS App. Everything is going right. I can open it with Microsoft Excel but, if I would like to open it with Apple Numbers, it doesn't work.\[code\]- (void)exportToExcel{ NSManagedObjectContext *context = [self managedObjectContext]; NSFetchRequest *request = [[NSFetchRequest alloc] init]; NSError *error; NSString *header = @"<?xml version=\"1.0\"?>\n<Workbook xmlns=\"urn:schemas-microsoft-com
ffice:spreadsheet\"\nxmlns=\"urn:schemas-microsoft-comfficeffice\"\nxmlns:x=\"urn:schemas-microsoft-comffice:excel\"\nxmlns:ss=\"urn:schemas-microsoft-comffice:spreadsheet\"\nxmlns:html=\"http://www.w3.org/TR/REC-html40\">\n<Worksheet ss:Name=\"Sheet1\">\n<Table ss:ExpandedColumnCount=\""; NSString *columncount = @"\" ss:ExpandedRowCount=\""; NSString *rowcount = @"\" x:FullColumns=\"1\"x:FullRows=\"1\">\n"; NSString *rowStart = @"<Row>\n"; NSString *rowEnde = @"\n</Row>\n"; NSString *stringStart = @"<Cell><Data ss:Type=\"String\">"; NSString *stringEnde = @"</Data></Cell>"; NSString *numberStart = @"<Cell><Data ss:Type=\"Number\">"; NSString *numberEnde = @"</Data></Cell>"; NSString *footer = @"</Table>\n</Worksheet>\n</Workbook>"; NSString *xlsstring = @""; NSEntityDescription *entity = [NSEntityDescription entityForName
"Form" inManagedObjectContext:context]; [request setEntity:entity]; NSArray *arr = [context executeFetchRequest:request error:&error]; int numberOfRows = 1; int numberOfCols = 2; for (Form *form in arr) { numberOfRows = numberOfRows + 1; } xlsstring = [NSString stringWithFormat"%@%i%@%i%@", header, numberOfCols, columncount, numberOfRows, rowcount]; xlsstring = [xlsstring stringByAppendingFormat"%@%@Patient number%@%@Name%@%@", rowStart, stringStart, stringEnde, stringStart, stringEnde, rowEnde]; for (Form *form in arr) { xlsstring = [xlsstring stringByAppendingFormat"%@%@%@%@%@%@%@%@", rowStart, numberStart, form.pnumber, numberEnde, stringStart, form.name, stringEnde, rowEnde]; } xlsstring = [xlsstring stringByAppendingFormat"%@", footer]; [xlsstring writeToFile"/Users/***/Desktop/form.xls" atomically:YES encoding:NSISOLatin1StringEncoding error:nil];}\[/code\]Does anyone have any idea why this might be so, or even a solution for this error?Many thanks for every answer.
ffice:spreadsheet\"\nxmlns=\"urn:schemas-microsoft-comfficeffice\"\nxmlns:x=\"urn:schemas-microsoft-comffice:excel\"\nxmlns:ss=\"urn:schemas-microsoft-comffice:spreadsheet\"\nxmlns:html=\"http://www.w3.org/TR/REC-html40\">\n<Worksheet ss:Name=\"Sheet1\">\n<Table ss:ExpandedColumnCount=\""; NSString *columncount = @"\" ss:ExpandedRowCount=\""; NSString *rowcount = @"\" x:FullColumns=\"1\"x:FullRows=\"1\">\n"; NSString *rowStart = @"<Row>\n"; NSString *rowEnde = @"\n</Row>\n"; NSString *stringStart = @"<Cell><Data ss:Type=\"String\">"; NSString *stringEnde = @"</Data></Cell>"; NSString *numberStart = @"<Cell><Data ss:Type=\"Number\">"; NSString *numberEnde = @"</Data></Cell>"; NSString *footer = @"</Table>\n</Worksheet>\n</Workbook>"; NSString *xlsstring = @""; NSEntityDescription *entity = [NSEntityDescription entityForName"Form" inManagedObjectContext:context]; [request setEntity:entity]; NSArray *arr = [context executeFetchRequest:request error:&error]; int numberOfRows = 1; int numberOfCols = 2; for (Form *form in arr) { numberOfRows = numberOfRows + 1; } xlsstring = [NSString stringWithFormat"%@%i%@%i%@", header, numberOfCols, columncount, numberOfRows, rowcount]; xlsstring = [xlsstring stringByAppendingFormat"%@%@Patient number%@%@Name%@%@", rowStart, stringStart, stringEnde, stringStart, stringEnde, rowEnde]; for (Form *form in arr) { xlsstring = [xlsstring stringByAppendingFormat"%@%@%@%@%@%@%@%@", rowStart, numberStart, form.pnumber, numberEnde, stringStart, form.name, stringEnde, rowEnde]; } xlsstring = [xlsstring stringByAppendingFormat"%@", footer]; [xlsstring writeToFile"/Users/***/Desktop/form.xls" atomically:YES encoding:NSISOLatin1StringEncoding error:nil];}\[/code\]Does anyone have any idea why this might be so, or even a solution for this error?Many thanks for every answer.