


I am new to go language. I have a requirement where an application will read an excel file and convert it into a json string without relying on any defined structure. I explored a few libraries where either this structure definition is required or at least there must be excel column headers. For example,
github.com/xuri/excelize github.com/onkarvhanumante/Excel2JsonTree github.com/FerdinaKusumah/excel2json
However, I can't find anywhere that can handle raw excel data and convert it to json.
Please give me some guidance, thank you!
Correct answer
If you can treat all values as strings, then you can do it as shown in the code snippet below. The script reads all worksheets (tabs) and creates json files in two formats (with and without headers).
package main import ( "encoding/json" "fmt" "os" "github.com/xuri/excelize/v2" ) func main() { f, err := excelize.OpenFile("test.xlsx") if err != nil { fmt.Println(err) return } defer func() { if err := f.Close(); err != nil { fmt.Println(err) } }() // could have multiple sheets sheets := f.GetSheetList() for _, sheetName := range sheets { d, err := f.GetRows(sheetName) if err != nil { fmt.Println("error reading sheet", sheetName, ":", err) return } saveAsJSON(d, sheetName+".json") saveAsJSONWithHeaders(d, sheetName+"_with_headers.json") } } func saveAsJSONWithHeaders(rows [][]string, filename string) error { data := make([]map[string]string, len(rows)-1) headers := rows[0] // excluding header row for i, row := range rows[1:] { data[i] = make(map[string]string) for j, cellValue := range row { data[i][headers[j]] = cellValue } } return saveAsJSON(data, filename) } func saveAsJSON(data interface{}, filename string) error { file, err := os.Create(filename) if err != nil { return err } defer file.Close() encoder := json.NewEncoder(file) if err := encoder.Encode(data); err != nil { return err } return nil }
The above is the detailed content of Convert Excel file data to JSON string in Go without any struct definition. For more information, please follow other related articles on the PHP Chinese website!

Golang is more suitable for high concurrency tasks, while Python has more advantages in flexibility. 1.Golang efficiently handles concurrency through goroutine and channel. 2. Python relies on threading and asyncio, which is affected by GIL, but provides multiple concurrency methods. The choice should be based on specific needs.

The performance differences between Golang and C are mainly reflected in memory management, compilation optimization and runtime efficiency. 1) Golang's garbage collection mechanism is convenient but may affect performance, 2) C's manual memory management and compiler optimization are more efficient in recursive computing.

ChooseGolangforhighperformanceandconcurrency,idealforbackendservicesandnetworkprogramming;selectPythonforrapiddevelopment,datascience,andmachinelearningduetoitsversatilityandextensivelibraries.

Golang and Python each have their own advantages: Golang is suitable for high performance and concurrent programming, while Python is suitable for data science and web development. Golang is known for its concurrency model and efficient performance, while Python is known for its concise syntax and rich library ecosystem.

In what aspects are Golang and Python easier to use and have a smoother learning curve? Golang is more suitable for high concurrency and high performance needs, and the learning curve is relatively gentle for developers with C language background. Python is more suitable for data science and rapid prototyping, and the learning curve is very smooth for beginners.

Golang and C each have their own advantages in performance competitions: 1) Golang is suitable for high concurrency and rapid development, and 2) C provides higher performance and fine-grained control. The selection should be based on project requirements and team technology stack.

Golang is suitable for rapid development and concurrent programming, while C is more suitable for projects that require extreme performance and underlying control. 1) Golang's concurrency model simplifies concurrency programming through goroutine and channel. 2) C's template programming provides generic code and performance optimization. 3) Golang's garbage collection is convenient but may affect performance. C's memory management is complex but the control is fine.

Goimpactsdevelopmentpositivelythroughspeed,efficiency,andsimplicity.1)Speed:Gocompilesquicklyandrunsefficiently,idealforlargeprojects.2)Efficiency:Itscomprehensivestandardlibraryreducesexternaldependencies,enhancingdevelopmentefficiency.3)Simplicity:


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

SublimeText3 Chinese version
Chinese version, very easy to use

SublimeText3 Linux new version
SublimeText3 Linux latest version

Zend Studio 13.0.1
Powerful PHP integrated development environment