csvxl

Documentation

Index

• Constants
• func AppendCsvToExcel(csvFiles []string, sheetNames []string, existingFile string, ...)
• func CsvToExcel(csvFiles []string, sheetNames []string, output string, csvEncoding ...string)
• func ExcelToCsv(excelFile string, outputDir string, csvNames []string, ...)

Constants

const (
	UTF8 = "utf-8"
	Big5 = "big5"
)

CsvEncoding Options

Functions

func AppendCsvToExcel

func AppendCsvToExcel(csvFiles []string, sheetNames []string, existingFile string, csvEncoding ...string)

Append CSV files to an existing Excel file, supporting custom sheet names. If the sheet name is not specified, the file name of the CSV file will be used. If the sheet is exists, it will be overwritten.

func CsvToExcel

func CsvToExcel(csvFiles []string, sheetNames []string, output string, csvEncoding ...string)

Convert multiple CSV files to an Excel file, supporting custom sheet names. If the sheet name is not specified, the file name of the CSV file will be used.

func ExcelToCsv

func ExcelToCsv(excelFile string, outputDir string, csvNames []string, onlyContainSheets ...string)

ExcelToCsv splits an Excel file into multiple CSV files, one per sheet. If customNames is provided, it uses them as CSV filenames; otherwise, it uses the sheet names.