How to Convert an XLS Workbook to CSV in Go

CSV files are frequently the chosen format for developers who need to organize data in a straightforward and simple manner. If you receive a data file in the old Excel (97–2003) format, you will most likely want to switch it to a more convenient and compatible format as soon as possible. In this quick tutorial, we will demonstrate how you can use an API in Go to automatically convert an XLS file to CSV — no hassle needed.

We can simply input the XLS file into the following example code to call the conversion function:

package main
import (
     "fmt"
     "bytes"
     "mime/multipart"
     "os"
     "path/filepath"
     "io"
     "net/http"
     "io/ioutil"
)
func main() {
url := "https://api.cloudmersive.com/convert/xls/to/csv"
     method := "POST"
payload := &bytes.Buffer{}
     writer := multipart.NewWriter(payload)
     file, errFile1 := os.Open("/path/to/file")
     defer file.Close()
     part1,
         errFile1 := writer.CreateFormFile("inputFile",filepath.Base("/path/to/file"))
     _, errFile1 = io.Copy(part1, file)
     if errFile1 != nil {
          fmt.Println(errFile1)
          return
     }
     err := writer.Close()
     if err != nil {
          fmt.Println(err)
          return
     }
client := &http.Client {
     }
     req, err := http.NewRequest(method, url, payload)
if err != nil {
          fmt.Println(err)
          return
     }
     req.Header.Add("Content-Type", "multipart/form-data")
     req.Header.Add("Apikey", "YOUR-API-KEY-HERE")
req.Header.Set("Content-Type", writer.FormDataContentType())
     res, err := client.Do(req)
     if err != nil {
          fmt.Println(err)
          return
     }
     defer res.Body.Close()
body, err := ioutil.ReadAll(res.Body)
     if err != nil {
          fmt.Println(err)
          return
     }
     fmt.Println(string(body))
}

And we’re done! Nothing to it.