Skip to main content

How to Create .csv File in iPhone Programmatically - Tutorial - Objective C

 Create .csv File in iPhone ProgrammaticallyCreate CSV file in IOS SDK - Tutorial (Objcetive C)




Introduction to how to create .csv file in iPhone programmatically

Creating CSV (Comma Separated Values) or Excel file in IOS SDK is very easy. In this post, I am sharing a demo code for creating CSV (Comma Separated Values) or Excel file in IOS programmatically.

Tutorial is updated to swift: Click here for swift version

Jump to code

First, we will create our data with the help of NSMutableArray and NSMutableDictionary. Below is the code for creating dummy data for our CSV or Excel file.
    

    employeeInfoArray  = [[NSMutableArray alloc]initWithCapacity:0];    

    for (int i = 0;i<10;i++)
    {
        NSMutableDictionary *dict = [[NSMutableDictionary alloc]initWithCapacity:0];
        [dict setValue:[NSString stringWithFormat:@"IDEMP%d",i+1] forKey:@"EMPID"];
        [dict setValue:[NSString stringWithFormat:@"NameEMP%d",i+1] forKey:@"EMPNAME"];
        [dict setValue:[NSString stringWithFormat:@"DEPP%d",i+1] forKey:@"EMPDEP"];
        
        [employeeInfoArray addObject:dict];
        
    }
         
       [self createCSV];





NOTE: employeeInfoArray is declared in .h file.

In order to create CSV or excel file, we will use NSMutableString in which values are separated by     ' , '  values. Then we, will save our file to document directory.

Code for creating CSV or excel file:


-(void)createCSV
{
    NSMutableString *csvString = [[NSMutableString alloc]initWithCapacity:0];
    [csvString appendString:@"ID, NAME, DEPARTMENT\n\n\n"];
    
    for (NSDictionary *dct in employeeInfoArray)
    {
        [csvString appendString:[NSString stringWithFormat:@"%@, %@, %@\n",                  [dct valueForKey:@"EMPID"],[dctvalueForKey:@"EMPNAME"],[dct valueForKey:@"EMPDEP"]]];
    }
    
    
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSString *filePath = [NSString stringWithFormat:@"%@/%@", documentsDirectory, @"EmployeeRecords.csv"];
    [csvString writeToFile:filePath atomically:YES encoding:NSUTF8StringEncoding error:nil];

}



OutPut:

CSV file created programmatically and then uploaded to Google drive
CSV file created programmatically and then uploaded to Google drive

CSV file created programmatically and then uploaded to Google drive and shown in Spreadsheet
CSV file created programmatically,  shown in Spreadsheet
  

Source Code:  Download

Note: Remove commas , so that accurate CSV can be generated.

Where to go from here 

In this post we learned how to create .csv file in iPhone programmatically in iOS SDK. If you have any questions then feel free to ask. Happy coding :)

Comments

Post a Comment

Thank You.

Popular Posts

React Native - Text Input

In this chapter, we will show you how to work with  TextInput  elements in React Native. The Home component will import and render inputs. App.js import React from 'react' ; import Inputs from './inputs.js' const App = () => { return ( < Inputs /> ) } export default App Inputs We will define the initial state. After defining the initial state, we will create the  handleEmail  and the  handlePassword  functions. These functions are used for updating state. The  login()  function will just alert the current value of the state. We will also add some other properties to text inputs to disable auto capitalisation, remove the bottom border on Android devices and set a placeholder. inputs.js import React , { Component } from 'react' import { View , Text , TouchableOpacity , TextInput , StyleSheet } from 'react-native' class Inputs extends Component { state = { ...
Post a Comment
Read more

An introduction to Size Classes for Xcode 8

Introduction to Size Classes for Xcode In iOS 8, Apple introduced  size classes , a way to describe any device in any orientation. Size classes rely heavily on auto layout. Until iOS 8, you could escape auto layout. IN iOS8, Apple changed several UIKit classes to depend on size classes. Modal views, popovers, split views, and image assets directly use size classes to determine how to display an image. Identical code to present a popover on an iPad  causes a iPhone to present a modal view. Different Size Classes There are two sizes for size classes:  compact , and  regular . Sometime you’ll hear about any.  Any  is the generic size that works with anything. The default Xcode layout, is  width:any height:any . This layout is for all cases. The Horizontal and vertical dimensions are called  traits , and can be accessed in code from an instance of  UITraitCollection . The  compact  size descr...
Post a Comment
Read more

What are the Alternatives of device UDID in iOS? - iOS7 / iOS 6 / iOS 5 – Get Device Unique Identifier UDID

Get Device Unique Identifier UDID Following code will help you to get the unique-device-identifier known as UDID. No matter what iOS user is using, you can get the UDID of the current iOS device by following code. - ( NSString *)UDID { NSString *uuidString = nil ; // get os version NSUInteger currentOSVersion = [[[[[UIDevice currentDevice ] systemVersion ] componentsSeparatedByString: @" . " ] objectAtIndex: 0 ] integerValue ]; if (currentOSVersion <= 5 ) { if ([[ NSUserDefaults standardUserDefaults ] valueForKey: @" udid " ]) { uuidString = [[ NSUserDefaults standardDefaults ] valueForKey: @" udid " ]; } else { CFUUIDRef uuidRef = CFUUIDCreate ( kCFAllocatorDefault ); uuidString = ( NSString *) CFBridgingRelease ( CFUUIDCreateString ( NULL ,uuidRef)); CFRelease (uuidRef); [[ NSUserDefaults standardUserDefaults ] setObject: uuidString ForKey: @" udid " ]; [[ NSUserDefaults standardUserDefaults ] synchro...
Post a Comment
Read more