Go Programming CSV Reader

Go Programming CSV Reader

CSV means comma separated values and it is one of the most common format to import and export in spreadsheets and databases.

encoding/csv module has the functionalities to read or write the CSV format data.

Let us consider example csv file ‘test-file.csv’ and has the below content.

id,name,class                                                                   
1,student1,VII                                                                  
2,student2,XI                                                                   
3,student3,VIII 

This Go program is used to read the existing csv file and provides the list of Student objects to consume in the Go programming.

package main            

import (                               
    "fmt"                                             
    "os"                                
    "encoding/csv"             
)                                                                               

                                                                                
func main() {             
    // Create struct to hold the CSV row data                                                      
    type Student struct {                                                       
        Id string                                                               
        Name string                                                             
        Class string                                                            
    }                                                                 

    // Open csv file using Open function importing os module          
    csvFile, err := os.Open("test-file.csv")                                    
    if err!=nil {                                                               
        fmt.Println(err)                                                        
    }                                                                           
    defer csvFile.Close()                                         

    // Create CSV reader              
    csvReader := csv.NewReader(csvFile)                                         
    // Specify number of columns per row
    csvReader.FieldsPerRecord = 3                      
    // Specify delimiter                         
    csvReader.Comma = ','                                                      
                                     

    // Read all the csv rows as csvData object     
    csvData, err := csvReader.ReadAll()                                         
    if err != nil {                                                             
        fmt.Println(err)                                                        
        os.Exit(1)                                                              
    }                                                                           
                                                   
    var stu Student                                                             
    var students []Student                                                      

     // Parses csvData object and create array of Student objects     
    for _, row := range csvData {                                               
        stu.Id = row[0]                                                         
        stu.Name = row[1]                                                       
        stu.Class = row[2]                                                      
        students = append(students, stu)                                        
    }                                            

    // Prints the data                               
    fmt.Println("All Students")                                                 
    fmt.Println(students)              
} 

Output:
$ go build csv-reader.go
$ ./csv-reader
All Students
[{id name class} {1 student1 VII} {2 student2 XII} {3 student3 VIII}]
Java Programming Examples

GCD and Rational Number Java Program

Java Queue Program using exception

Java Stack Program using exception

Addition of three integers java program

Biggest of three integers java program

Fibonacci numbers java program

Arithmetic Operations Menu java program

Second Smallest Element In Array Java Program

Transpose Of A Matrix Java Program

Java Program to Display triangle of stars (*)

Java Programming Prints Product Tables

Java Program to Display triangle of numbers

Java Programming Gets Current Date

Java Programming Finds Character Vowel or Consonent

Java Programming HCF and LCM Computation

Java Programming Sum of Command Line Integer Arguments

Java Programming Multiplication of Command Line Integer Arguments

Java Programming Multiplication of Command Line Floating Point Numeric Arguments

Java Programming String Contains or Not

Java Programming Gets Grade Description using Switch

Java Programming CSV File Reader

Java Programming Character Frequency Count in String using for each

Java Programming Finds Min from Integer Array by Passing Array to Method

Java Programming Linear Search

Java Programming Binary Search

Java Programming Ternary Search

Java Programming Generates Range of Numbers

Java Programming Generates Range of Characters

Java Programming Computes Square Root Value

Java Programming Checks Number is Positive or Negative

Java Programming Checks Number is Odd or Even

Java Programming Computes Plot Area

Java Programming Convert Number of Days into Years

Java Programming Checks a Year is Leap Year, Century Year or Not

Java Programming Checks a Character is Digit, Letter or neither digit nor letter

Java Programming Checks a Number is Palindrome or not

Java Programming Sum of Two Matrix

Java Programming Power Computation

Java Programming Checks Number is an Armstrong Number or not

Java Programming Temperature Unit Conversions

Java Programming Generates Random Numbers in Specified Range

Java Programming Computes Sum of Digits and Product of Digits

Java Programming Computes Reverse Number

Java Programming Computes Factorial Value

Java Programming Checks Prime Number or not

Java Programming Computes Harmonic Series

Java Programming Generates Floyd's Triangle

Java Programming Reverses String

Java Programming Checks Palindrome String or not

Java Programming Opens Notepad

Java Programming Searches String using RegEx Pattern

Java Programming Searches Word in String

Java Programming Gets System Environment Variables

Java Programming Gets IP Address of Server Name

Java Programming Arrays Sort and Reverse using sort method

Java Programming Bubble Sorting

Java Programming Selection Sorting

Java Programming Insertion Sorting

Java Programming Merge Sorting

Java Programming Quick Sorting

Java Programming Counting Sort

Java Programming Radix Sorting

Java Programming Sorting Array of Strings

Java Programming String Characters Sorting

Java Programming Sum of First N Numbers

Java Programming Product of First N Numbers

Privacy Policy  |  Copyright@2017 - All Rights Reserved.  |  Contact us   |  Report website issues in Github   |  Facebook page   |  Google+ page

Free online programming tutorials

Email Facebook Google LinkedIn Twitter
^