Class SheetsTable

Namespace

SunamoGoogleSheets

Assembly

SunamoGoogleSheets.dll

Represents a table parsed from Google Sheets with support for sections

public class SheetsTable

Inheritance

object

SheetsTable

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

FuncExtensions.AsFuncFast<T>(T)

FuncExtensions.AsFunc<T>(T)

ObjectExtensions.GetStackTrace(object)

ReClasser.FixMeUp(object)

Constructors

SheetsTable(ILogger)

Represents a table parsed from Google Sheets with support for sections

public SheetsTable(ILogger logger)

Parameters

logger ILogger

Properties

ColumnCount

Gets the number of columns in the table

public int ColumnCount { get; }

Property Value

int

RowsCount

Gets the number of rows in the table

public int RowsCount { get; }

Property Value

int

SectionRanges

Gets the section ranges (from-to) for each section identified by section name

public Dictionary<string, FromToTGoogleSheets<int>> SectionRanges { get; }

Property Value

Dictionary<string, FromToTGoogleSheets<int>>

Table

Gets the parsed data table

public DataTable Table { get; }

Property Value

DataTable

Methods

DeleteColumn(int)

Deletes a column from the table at the specified index

public void DeleteColumn(int columnIndex)

Parameters

columnIndex int

The zero-based index of the column to delete

ParseRows(string)

Parses rows from Google Sheets clipboard format into the table

public void ParseRows(string input)

Parameters

input string

The text content from Google Sheets clipboard

ParseRowsOfSections(string)

Parses rows and identifies sections (sections are identified by a colon at the end of the first cell) Returns rows that belong to each section

public void ParseRowsOfSections(string input)

Parameters

input string

The text content from Google Sheets clipboard

RowsFromColumn(int, FromToTGoogleSheets<int>?)

Returns values from a specific column, optionally filtered to a specific section

public List<string> RowsFromColumn(int columnIndex, FromToTGoogleSheets<int>? sectionRange = null)

Parameters

columnIndex int

The zero-based index of the column to retrieve values from

sectionRange FromToTGoogleSheets<int>

Optional section range to filter rows; if null, returns all rows

Returns

List<string>

List of string values from the specified column