PhoenixKitCatalogue.Import.Parser (PhoenixKitCatalogue v0.1.8)

Parses XLSX and CSV files into structured row data.

Returns a map with headers, rows, sheet names, and row count. Uses no external dependencies beyond what phoenix_kit already provides:

Summary

parsed_file()

Detects file format from the filename extension.

Lists sheet names from an XLSX file.

Parses a file binary into structured data.

@type parsed_file() :: %{
  sheets: [String.t()],
  headers: [String.t()],
  rows: [[String.t()]],
  row_count: non_neg_integer()
}

@spec detect_format(String.t()) :: :xlsx | :csv | {:error, :unsupported}

Detects file format from the filename extension.

@spec list_sheets(binary()) :: {:ok, [String.t()]} | {:error, String.t()}

Lists sheet names from an XLSX file.

@spec parse(binary(), String.t(), keyword()) ::
  {:ok, parsed_file()} | {:error, String.t()}

Parses a file binary into structured data.