fromCsv | @sheetwrite/core

@sheetwrite/corefunction

Parse CSV into ColumnarData. The first record is consumed as a positional header. Input fields project onto declared visible columns; hidden declared columns are initialized to null, matching the visible-column CSV export. Extra fields are ignored and missing fields become null. The returned columnar table is fully materialized in memory.

Package: @sheetwrite/core
Source: packages/core/src/export.ts#L151

Declaration

function fromCsv(
  text: string,
  columns: readonly Columninterface Column {
  key: string;
  header: string;
  width: number;
  type: CellFormat;
  numberFormat?: string;
  numberLocale?: string;
  headerStyle?: CellStyle;
  cellStyle?: CellStyle;
  visible?: boolean;
  renderer?: string;
}interface Column {
  key: string;
  header: string;
  width: number;
  type: CellFormat;
  numberFormat?: string;
  numberLocale?: string;
  headerStyle?: CellStyle;
  cellStyle?: CellStyle;
  visible?: boolean;
  renderer?: string;
}interface Column {
  key: string;
  header: string;
  width: number;
  type: CellFormat;
  numberFormat?: string;
  numberLocale?: string;
  headerStyle?: CellStyle;
  cellStyle?: CellStyle;
  visible?: boolean;
  renderer?: string;
}Schema and default presentation for one workbook column.API reference →[],
  options?: DelimitedTextOptionsinterface DelimitedTextOptions {
  resourceLimits?: Partial<DelimitedTextResourceLimits>;
}interface DelimitedTextOptions {
  resourceLimits?: Partial<DelimitedTextResourceLimits>;
}interface DelimitedTextOptions {
  resourceLimits?: Partial<DelimitedTextResourceLimits>;
}Optional resource ceilings for an in-memory delimited-text operation.API reference →,
): ColumnarDatainterface ColumnarData {
  rowCount: number;
  columns: Record<string, ArrayLike<CellScalar | CellValue>>;
}interface ColumnarData {
  rowCount: number;
  columns: Record<string, ArrayLike<CellScalar | CellValue>>;
}interface ColumnarData {
  rowCount: number;
  columns: Record<
    string,
    ArrayLike<
      CellScalar | CellValue
    >
  >;
}Eager column-oriented values used to initialize a sheet.API reference →