How to export to CSV directly from a query using golang

Question

I have a java script that exports website html table contents to CSV from a Web Application. I would like to bypass that and when a button is pressed it runs a query and downloads it to CSV without first loading it to the html table. Does anyone have anything like that?

This is useful for printing out reports. Some big reports that i have since they have to load in the website first cause too much lag.

dave · Accepted Answer · 2019-01-01 01:39:51Z

1

You would just do something like:

func(w http.ResponseWriter, r *http.Request)
    var data = [][]string{{"Line1", "Hello"}, {"Line2", "World"}}
    buffer := &bytes.Buffer{} // creates IO Writer

    writer := csv.NewWriter(buffer)

    for _, value := range data {
        err := writer.Write(value)
        checkError("Cannot write to buffer", err)
    }

    writer.Flush()

    w.Header().Set("Content-Type", "text/csv") // setting the content type header to text/csv
    w.Header().Set("Content-Disposition", "attachment;filename=TheCSVFileName.csv")
    w.Write(buffer.Bytes())
}

answered Jan 1, 2019 at 1:39

dave

65.1k6 gold badges81 silver badges98 bronze badges

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

Collectives™ on Stack Overflow

How to export to CSV directly from a query using golang

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related