csvx

package module

Go to main page

Versions in this module

v0

v0.1.15

Oct 6, 2026

v0.1.14

Oct 5, 2026

v0.1.13

Oct 5, 2026

Changes in this version

+ type CSVExportOptions struct

+ Delimiter rune

+ Display bool

+ Formulas string

+ NoHeader bool

+ Sheet string

+ type ExportWarning struct

+ Feature string

+ Location string

+ Message string

+ func ExportCSV(workbook *Workbook, options CSVExportOptions) (string, []ExportWarning, error)

v0.1.12

Oct 4, 2026

Changes in this version

+ const HeaderRow

+ func CanonicalCellText(v Value) string

+ func CoordinateFor(columnIndex, rowIndex int) string

+ func FormatSheetName(name string) string

+ func IndicesForCoordinate(coordinate string) (column, row int, ok bool)

+ func RawCellText(sheet *Sheet, row, column int) string

+ func RecalculateCells(cells CellMap, options RecalculateOptions) map[string]Value

+ func RecalculateSheets(sheets map[string]CellMap, external func(name string) CellMap, ...) map[string]map[string]Value

+ func RewriteFormulaForAxisEdit(formula, ownSheet, targetSheet string, edit AxisEdit) string

+ func RewriteFormulaForSheetChange(formula, oldName, newName string, deleted bool) string

+ func RowIndexFor(rowNumber int) int

+ func RowNumberFor(rowIndex int) int

+ func TranslateFormula(formula string, rows, columns int) string

+ func UsedRange(sheet *Sheet, styles []Style) (rows, columns int)

+ func WritePackageTo(workbook *Workbook, file io.Writer) error

+ type AxisEdit struct

+ Axis string

+ Deleted map[int]bool

+ Map func(index int) int

+ type CellMap map[string]FormulaCellInput

+ func BuildCellMap(sheet *Sheet, styles []Style) CellMap

+ type CellRef struct

+ Column string

+ HasSht bool

+ Row int

+ Sheet string

+ type EditOptions struct

+ From string

+ SkipRecalculate bool

+ type FormulaCellInput struct

+ Formula string

+ Value Value

+ type FormulaNode struct

+ Args []*FormulaNode

+ Bool bool

+ End *FormulaNode

+ Kind NodeKind

+ Left *FormulaNode

+ Operand *FormulaNode

+ Operator string

+ Ref CellRef

+ Right *FormulaNode

+ Start *FormulaNode

+ Text string

+ func ParseFormula(source string) (*FormulaNode, error)

+ type FormulaParseError struct

+ Message string

+ func (e *FormulaParseError) Error() string

+ type InvalidEditError struct

+ Message string

+ func (e *InvalidEditError) Error() string

+ type InvalidNamedRangeError struct

+ Diagnostics []NamedRangeDiagnostic

+ func (e *InvalidNamedRangeError) Error() string

+ type NamedRange schema.CSVXWorkbookNamedRangesElem

+ func (n *NamedRange) UnmarshalJSON(data []byte) error

+ func (n NamedRange) MarshalJSON() ([]byte, error)

+ type NamedRangeDiagnostic struct

+ Code string

+ Message string

+ Name string

+ func ValidateNamedRanges(namedRanges []NamedRange) []NamedRangeDiagnostic

+ type NodeKind int

+ const NodeBinary

+ const NodeBoolean

+ const NodeCall

+ const NodeName

+ const NodeNumber

+ const NodePercent

+ const NodeRange

+ const NodeRefError

+ const NodeReference

+ const NodeString

+ const NodeUnary

+ type Page struct

+ Columns []string

+ Number int

+ Rows []int

+ type Pagination struct

+ Area string

+ Pages []Page

+ PrintableHeight float64

+ PrintableWidth float64

+ Scale float64

+ func Paginate(sheet *Sheet, styles []Style) Pagination

+ type RecalculateOptions struct

+ ResolveSheet func(name string) CellMap

+ type ReferenceRequest struct

+ Column string

+ HasSheet bool

+ Row int

+ Sheet string

+ type ReferenceResolver func(ReferenceRequest) Value

type Style

+ func (s *Style) UnmarshalJSON(data []byte) error

type ValidationResult

+ func ValidateWorkbook(workbook *Workbook) ValidationResult

type Value

+ func EvaluateFormula(formula string, resolve ReferenceResolver, namedRanges []NamedRange) Value

type Workbook

+ NamedRanges []NamedRange

+ func AddSheet(workbook *Workbook, options EditOptions) *Workbook

+ func ApplyStyle(workbook *Workbook, sheet string, coordinates []string, patch map[string]any, ...) (*Workbook, error)

+ func ClearStyle(workbook *Workbook, sheet string, coordinates []string, options EditOptions) (*Workbook, error)

+ func DeleteColumns(workbook *Workbook, sheet string, columns []string, options EditOptions) (*Workbook, error)

+ func DeleteRows(workbook *Workbook, sheet string, rows []int, options EditOptions) (*Workbook, error)

+ func DeleteSheet(workbook *Workbook, sheet string, options EditOptions) (*Workbook, error)

+ func InsertColumns(workbook *Workbook, sheet, at string, count int, options EditOptions) (*Workbook, error)

+ func InsertRows(workbook *Workbook, sheet string, at, count int, options EditOptions) (*Workbook, error)

+ func Paste(workbook *Workbook, sheet, anchor string, rows [][]string, options EditOptions) (*Workbook, error)

+ func RecalculateWorkbook(workbook *Workbook) *Workbook

+ func RenameSheet(workbook *Workbook, sheet, name string, options EditOptions) (*Workbook, error)

+ func SetCell(workbook *Workbook, sheet, coordinate, text string, options EditOptions) (*Workbook, error)

+ func SetPrint(workbook *Workbook, sheet string, patch map[string]any, options EditOptions) (*Workbook, error)

type WorkbookDocument

+ NamedRanges []NamedRange

type XLSXDiagnostic

+ func ExportXLSX(workbook *Workbook, output string) ([]XLSXDiagnostic, error)

+ func ExportXLSXTo(workbook *Workbook, out io.Writer) ([]XLSXDiagnostic, error)

v0.1.11

Oct 2, 2026

v0.1.10

Oct 2, 2026

Changes in this version

+ func ChangeCase(text string, mode TextCaseMode, declaredType, formula string) string

+ func IsCaseEligible(text, declaredType, formula string) bool

+ type TextCaseMode string

+ const CaseLower

+ const CaseTitle

+ const CaseUpper

v0.1.5

Oct 2, 2026

Changes in this version

+ func ImportCSV(data []byte, options CSVImportOptions) (*Workbook, []ImportWarning, error)

+ func ImportCSVFile(filename string, options CSVImportOptions) (*Workbook, []ImportWarning, error)

+ type CSVImportOptions struct

+ Delimiter rune

+ Infer bool

+ Name string

+ NoHeader bool

+ type CSVSyntaxError struct

+ Err error

+ Line int

+ func (e *CSVSyntaxError) Error() string

+ func (e *CSVSyntaxError) Unwrap() error

+ type ImportWarning struct

+ Location string

+ Reason string

v0.1.4

Oct 2, 2026

v0.1.3

Oct 2, 2026

Changes in this version

+ type PrintSettings schema.Print

+ func (p *PrintSettings) UnmarshalJSON(data []byte) error

+ func (p PrintSettings) MarshalJSON() ([]byte, error)

type Sheet

+ Print *PrintSettings

v0.1.2

Oct 2, 2026

Changes in this version

+ func ColumnWidthToPixels(width float64) int

+ func PixelsToColumnWidth(pixels float64) float64

+ func PixelsToRowHeight(pixels float64) float64

+ func RowHeightToPixels(points float64) int

v0.1.1

Oct 1, 2026

Changes in this version

+ func FormatValue(value Value, numberFormat string) string

type CellMetadata

+ func NextCellMetadata(existing CellMetadata, formula string) (CellMetadata, bool)

type Value

+ func ParseFormattedLiteral(text string, numberFormat string) (Value, bool)

+ func ResolveCellValue(raw string, declaredType string, numberFormat string) Value

v0.1.0

Sep 30, 2026

Changes in this version

+ func Convert(input, output string) error

+ func ExtractPackage(filename, directory string) error

+ func PackageDirectory(directory, output string) error

+ func WritePackage(workbook *Workbook, output string) error

+ type Calculation struct

+ Iteration bool

+ Mode string

+ type CellMetadata struct

+ Cached *Value

+ Formula string

+ Style string

+ Type string

+ Validation json.RawMessage

+ type Column struct

+ ID string

+ Name string

+ Type string

+ Width float64

+ type Diagnostic struct

+ Code string

+ Message string

+ Path string

+ Severity string

+ type Manifest struct

+ Files []string

+ Format string

+ Version string

+ Workbook string

+ type Sheet struct

+ Cells map[string]CellMetadata

+ Columns []Column

+ Extra map[string]json.RawMessage

+ ID string

+ MetadataPath string

+ Name string

+ Path string

+ Records [][]string

+ RowHeights map[int]float64

+ type SheetEntry struct

+ ID string

+ Metadata string

+ Name string

+ Path string

+ type SourceMetadata struct

+ Authority string

+ Features XLSXFeatureCounts

+ Filename string

+ Format string

+ ImportedAt string

+ Importer string

+ SHA256 string

+ Warnings []XLSXDiagnostic

+ type Style schema.CSVXStylesStylesElem

+ func (s Style) MarshalJSON() ([]byte, error)

+ type ValidationResult struct

+ Errors []Diagnostic

+ Valid bool

+ Warnings []Diagnostic

+ func Validate(filename string) ValidationResult

+ type Value struct

+ Code string

+ Message string

+ Type string

+ Value any

+ type Workbook struct

+ Calculation Calculation

+ ID string

+ Sheets []*Sheet

+ Source *SourceMetadata

+ SourceBytes []byte

+ Styles []Style

+ Version string

+ func Load(reader io.ReaderAt, size int64) (*Workbook, error)

+ func Open(filename string) (*Workbook, error)

+ func OpenDirectory(directory string) (*Workbook, error)

+ type WorkbookDocument struct

+ Calculation Calculation

+ ID string

+ Sheets []SheetEntry

+ Source *SourceMetadata

+ Styles string

+ Version string

+ type XLSXDiagnostic struct

+ Feature string

+ Message string

+ Path string

+ Severity string

+ type XLSXFeatureCounts struct

+ Charts int

+ Comments int

+ Drawings int

+ Images int

+ Macros int

+ NumberFormats int

+ Persons int

+ Relationships int

+ SharedStrings int

+ Styles int

+ type XLSXInspection struct

+ Features XLSXFeatureCounts

+ Filename string

+ Format string

+ Resources []string

+ SHA256 string

+ Sheets []XLSXSheet

+ Warnings []XLSXDiagnostic

+ func InspectXLSX(filename string) (*XLSXInspection, error)

+ type XLSXSheet struct

+ CachedValues int

+ Cells int

+ Formulas int

+ Name string

+ Path string

+ SharedStrings int

+ StyledCells int

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL