Skip to main content

OpenTD .NET4 reference 2025 R2

OpenTD.Results.Dataset.SpreadsheetDataFile Class Reference

Last update: 16.07.2025

Dataset representing data stored in a csv-style file. Each column is a series, while each row is a record. The first row contains DataItemIdentifiers. The second row contains units. Third and subsequent rows contain data. "NaN" or empty cells are treated as NaN. Default delimiters are comma and tab. All registers (except TIMEN) are considered dimensionless and their units are ignored. The name "time" (case-insensitive) can also be used for TIMEN. More...

Inheritance diagram for OpenTD.Results.Dataset.SpreadsheetDataFile:
OpenTD.Results.Dataset.SimpleDatasetOpenTD.Results.Dataset.ISimpleDatasetOpenTD.Results.Dataset.IDatasetOpenTD.Results.Dataset.DatasetOpenTD.Results.Dataset.ISimpleDatasetOpenTD.Results.Dataset.IDatasetOpenTD.Results.Dataset.IAutoNameOpenTD.Results.Dataset.IDatasetOpenTD.Results.Dataset.IAutoNameOpenTD.Results.Dataset.IAutoCommentOpenTD.Results.Dataset.IAutoNameOpenTD.Results.Dataset.IAutoName

Public Member Functions

 SpreadsheetDataFile (string pathname)
 
override DataArrayCollection GetAllData (bool includeXDataAsFirstArray=true)
 
override List< long > GetConductorIds (string submodel)
 
override List< string > GetFluidSubmodels ()
 
override List< long > GetFtieIds (string submodel)
 
override List< long > GetIfaceIds (string submodel)
 
override List< long > GetLumpIds (string submodel)
 
override List< long > GetNodeIds (string submodel)
 
override List< long > GetPathIds (string submodel)
 
override List< long > GetRecordNumbers ()
 SpreadsheetDataFiles don't have record numbers, so this returns a list of sequential integers starting at 0.
 
override List< string > GetThermalSubmodels ()
 
override List< long > GetTieIds (string submodel)
 
override DataArray GetTimes ()
 
override List< string > GetRegisterNames ()
 
override DataArray GetRegisterData (string registerName, DataSubtype subtype=null, UnitsData units=null)
 
override DataArray GetRegisterDataAtRecord (long recordNum, DataSubtype subtype=null, UnitsData units=null)
 
override List< string > GetUdcaDataAtRecord (DataSubtype subtype, long recordNum)
 
override DataArray GetDataAtRecord (DataSubtype subtype, long recordNum)
 
override long GetInternalIndex (DataTypes dataType, string submodel, long id)
 
override Dimensional< Temp > GetAbszro ()
 
override DataArray GetConstraintData (long constraintNumber, DataSubtype subtype=null, UnitsData units=null)
 
override List< long > GetLoopcoData ()
 
override List< long > GetLoopctData ()
 
override long GetNamedInt (string name)
 
override List< long > GetNamedIntArray (string name)
 
override long GetNpcsrec (long recordNum)
 
override long GetNsol (long recordNum)
 
override Dimensional< Pressure > GetPatmos ()
 
override DataArray GetReliabilityData (long reliabilityNumber, DataSubtype subtype=null, UnitsData units=null)
 
override Dimensional< StefanBoltzmann > GetSigma ()
 
override List< string > GetRecordNames ()
 
override List< DataSubtype > GetUdfasAtRecord (long recordNum)
 
override DataArrayCollection GetData (DataItemIdentifierCollection dataItems)
 
virtual DataArrayCollection GetData (params string[] sindaNames)
 
virtual DataArrayCollection GetData (ItemIdentifierCollection itemIds, DataSubtype subtype, UnitsData units=null)
 
override List< List< string > > GetUdcaData (DataItemIdentifierCollection dataItems)
 
override void Close ()
 
override void ReOpen ()
 
DataArray GetRecordNumbersAsDataArray ()
 
DataArray GetTimesOrRecordNumbers ()
 
long GetNamedInt (IntegerNames name)
 
List< long > GetNamedIntArray (ArrayIntegerNames name)
 
virtual long GetInternalIndex (string registerName)
 The 0-indexed position of the given register in arrays returned by GetRegisterDataAtRecord. Returns -1 if registerName can't be found.
 
override string ToString ()
 

Public Attributes

readonly char[] DisallowedDelimiters = new char[] { '/', '-', '(', ')', '^', ' ' }
 

Protected Member Functions

override string GetSelfSuggestedName ()
 
bool UnitsChangedSinceLastRead ()
 
virtual string GetSelfSuggestedComment ()
 
List< T_item > Relay< T_collection, T_item > (T_collection x)
 
List< T_item > Relay< T_item > (List< T_item > x)
 

Properties

string Pathname [get]
 
char[] Delimiters [get, set]
 An array of delimiters to use when parsing the input file. Defaults to comma and tab, i.e., either of those characters will be treated as a column delimiter when found in the input file. Cannot be any of the following since they're used for units expressions: /-()^ or space.
 
UnitsData Units [get, set]
 The unit system of the dataset.
 
virtual string Source [get, protected set]
 The name of the source of the data.
 
IUDFAManager UDFAManager = null [get, set]
 
AutoNamer AutoNamer [get, set]
 
string Name [get, set]
 
string InternalSuggestedName [get, set]
 
AutoCommenter AutoCommenter [get, set]
 
string Comment [get, set]
 
string InternalSuggestedComment [get, set]
 

Detailed Description

Dataset representing data stored in a csv-style file. Each column is a series, while each row is a record. The first row contains DataItemIdentifiers. The second row contains units. Third and subsequent rows contain data. "NaN" or empty cells are treated as NaN. Default delimiters are comma and tab. All registers (except TIMEN) are considered dimensionless and their units are ignored. The name "time" (case-insensitive) can also be used for TIMEN.

Constructor & Destructor Documentation

◆ SpreadsheetDataFile()

OpenTD.Results.Dataset.SpreadsheetDataFile.SpreadsheetDataFile ( string pathname)
inline

Member Function Documentation

◆ Close()

override void OpenTD.Results.Dataset.SimpleDataset.Close ( )
inlineinherited

◆ GetAbszro()

override Dimensional< Temp > OpenTD.Results.Dataset.SpreadsheetDataFile.GetAbszro ( )
inline

◆ GetAllData()

override DataArrayCollection OpenTD.Results.Dataset.SpreadsheetDataFile.GetAllData ( bool includeXDataAsFirstArray = true)
inline

◆ GetConductorIds()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetConductorIds ( string submodel)
inline

◆ GetConstraintData()

override DataArray OpenTD.Results.Dataset.SpreadsheetDataFile.GetConstraintData ( long constraintNumber,
DataSubtype subtype = null,
UnitsData units = null )
inline

◆ GetData() [1/3]

virtual DataArrayCollection OpenTD.Results.Dataset.Dataset.GetData ( ItemIdentifierCollection itemIds,
DataSubtype subtype,
UnitsData units = null )
inlinevirtualinherited

◆ GetData() [2/3]

virtual DataArrayCollection OpenTD.Results.Dataset.Dataset.GetData ( params string[] sindaNames)
inlinevirtualinherited

◆ GetData() [3/3]

override DataArrayCollection OpenTD.Results.Dataset.SimpleDataset.GetData ( DataItemIdentifierCollection dataItems)
inlineinherited

◆ GetDataAtRecord()

override DataArray OpenTD.Results.Dataset.SpreadsheetDataFile.GetDataAtRecord ( DataSubtype subtype,
long recordNum )
inline

◆ GetFluidSubmodels()

override List< string > OpenTD.Results.Dataset.SpreadsheetDataFile.GetFluidSubmodels ( )
inline

◆ GetFtieIds()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetFtieIds ( string submodel)
inline

◆ GetIfaceIds()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetIfaceIds ( string submodel)
inline

◆ GetInternalIndex() [1/2]

virtual long OpenTD.Results.Dataset.Dataset.GetInternalIndex ( string registerName)
inlinevirtualinherited

The 0-indexed position of the given register in arrays returned by GetRegisterDataAtRecord. Returns -1 if registerName can't be found.

See also
OpenTD.Results.Dataset.Dataset.GetRegisterDataAtRecord

Implements OpenTD.Results.Dataset.IDataset.

◆ GetInternalIndex() [2/2]

override long OpenTD.Results.Dataset.SpreadsheetDataFile.GetInternalIndex ( DataTypes dataType,
string submodel,
long id )
inline

◆ GetLoopcoData()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetLoopcoData ( )
inline

◆ GetLoopctData()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetLoopctData ( )
inline

◆ GetLumpIds()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetLumpIds ( string submodel)
inline

◆ GetNamedInt() [1/2]

long OpenTD.Results.Dataset.Dataset.GetNamedInt ( IntegerNames name)
inlineinherited

◆ GetNamedInt() [2/2]

override long OpenTD.Results.Dataset.SpreadsheetDataFile.GetNamedInt ( string name)
inline

◆ GetNamedIntArray() [1/2]

List< long > OpenTD.Results.Dataset.Dataset.GetNamedIntArray ( ArrayIntegerNames name)
inlineinherited

◆ GetNamedIntArray() [2/2]

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetNamedIntArray ( string name)
inline

◆ GetNodeIds()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetNodeIds ( string submodel)
inline

◆ GetNpcsrec()

override long OpenTD.Results.Dataset.SpreadsheetDataFile.GetNpcsrec ( long recordNum)
inline

◆ GetNsol()

override long OpenTD.Results.Dataset.SpreadsheetDataFile.GetNsol ( long recordNum)
inline

◆ GetPathIds()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetPathIds ( string submodel)
inline

◆ GetPatmos()

override Dimensional< Pressure > OpenTD.Results.Dataset.SpreadsheetDataFile.GetPatmos ( )
inline

◆ GetRecordNames()

override List< string > OpenTD.Results.Dataset.SpreadsheetDataFile.GetRecordNames ( )
inline

◆ GetRecordNumbers()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetRecordNumbers ( )
inline

SpreadsheetDataFiles don't have record numbers, so this returns a list of sequential integers starting at 0.

Implements OpenTD.Results.Dataset.IDataset.

◆ GetRecordNumbersAsDataArray()

DataArray OpenTD.Results.Dataset.Dataset.GetRecordNumbersAsDataArray ( )
inlineinherited

◆ GetRegisterData()

override DataArray OpenTD.Results.Dataset.SpreadsheetDataFile.GetRegisterData ( string registerName,
DataSubtype subtype = null,
UnitsData units = null )
inline

◆ GetRegisterDataAtRecord()

override DataArray OpenTD.Results.Dataset.SpreadsheetDataFile.GetRegisterDataAtRecord ( long recordNum,
DataSubtype subtype = null,
UnitsData units = null )
inline

◆ GetRegisterNames()

override List< string > OpenTD.Results.Dataset.SpreadsheetDataFile.GetRegisterNames ( )
inline

◆ GetReliabilityData()

override DataArray OpenTD.Results.Dataset.SpreadsheetDataFile.GetReliabilityData ( long reliabilityNumber,
DataSubtype subtype = null,
UnitsData units = null )
inline

◆ GetSelfSuggestedComment()

virtual string OpenTD.Results.Dataset.Dataset.GetSelfSuggestedComment ( )
inlineprotectedvirtualinherited

◆ GetSelfSuggestedName()

override string OpenTD.Results.Dataset.SpreadsheetDataFile.GetSelfSuggestedName ( )
inlineprotectedvirtual

Reimplemented from OpenTD.Results.Dataset.Dataset.

◆ GetSigma()

override Dimensional< StefanBoltzmann > OpenTD.Results.Dataset.SpreadsheetDataFile.GetSigma ( )
inline

◆ GetThermalSubmodels()

override List< string > OpenTD.Results.Dataset.SpreadsheetDataFile.GetThermalSubmodels ( )
inline

◆ GetTieIds()

override List< long > OpenTD.Results.Dataset.SpreadsheetDataFile.GetTieIds ( string submodel)
inline

◆ GetTimes()

override DataArray OpenTD.Results.Dataset.SpreadsheetDataFile.GetTimes ( )
inline

◆ GetTimesOrRecordNumbers()

DataArray OpenTD.Results.Dataset.Dataset.GetTimesOrRecordNumbers ( )
inlineinherited

◆ GetUdcaData()

override List< List< string > > OpenTD.Results.Dataset.SimpleDataset.GetUdcaData ( DataItemIdentifierCollection dataItems)
inlineinherited

◆ GetUdcaDataAtRecord()

override List< string > OpenTD.Results.Dataset.SpreadsheetDataFile.GetUdcaDataAtRecord ( DataSubtype subtype,
long recordNum )
inline

◆ GetUdfasAtRecord()

override List< DataSubtype > OpenTD.Results.Dataset.SpreadsheetDataFile.GetUdfasAtRecord ( long recordNum)

◆ Relay< T_collection, T_item >()

List< T_item > OpenTD.Results.Dataset.Dataset.Relay< T_collection, T_item > ( T_collection x)
inlineprotectedinherited
Type Constraints
T_collection :System.Collections.IEnumerable 

◆ Relay< T_item >()

List< T_item > OpenTD.Results.Dataset.Dataset.Relay< T_item > ( List< T_item > x)
inlineprotectedinherited

◆ ReOpen()

override void OpenTD.Results.Dataset.SimpleDataset.ReOpen ( )
inlineinherited

◆ ToString()

override string OpenTD.Results.Dataset.Dataset.ToString ( )
inlineinherited

◆ UnitsChangedSinceLastRead()

bool OpenTD.Results.Dataset.Dataset.UnitsChangedSinceLastRead ( )
inlineprotectedinherited

Member Data Documentation

◆ DisallowedDelimiters

readonly char [] OpenTD.Results.Dataset.SpreadsheetDataFile.DisallowedDelimiters = new char[] { '/', '-', '(', ')', '^', ' ' }

Property Documentation

◆ AutoCommenter

AutoCommenter OpenTD.Results.Dataset.Dataset.AutoCommenter
getsetprotectedinherited

◆ AutoNamer

AutoNamer OpenTD.Results.Dataset.Dataset.AutoNamer
getsetprotectedinherited

◆ Comment

string OpenTD.Results.Dataset.Dataset.Comment
getsetinherited

◆ Delimiters

char [] OpenTD.Results.Dataset.SpreadsheetDataFile.Delimiters
getset

An array of delimiters to use when parsing the input file. Defaults to comma and tab, i.e., either of those characters will be treated as a column delimiter when found in the input file. Cannot be any of the following since they're used for units expressions: /-()^ or space.

◆ InternalSuggestedComment

string OpenTD.Results.Dataset.Dataset.InternalSuggestedComment
getsetinherited

◆ InternalSuggestedName

string OpenTD.Results.Dataset.Dataset.InternalSuggestedName
getsetinherited

◆ Name

string OpenTD.Results.Dataset.Dataset.Name
getsetinherited

◆ Pathname

string OpenTD.Results.Dataset.SpreadsheetDataFile.Pathname
get

◆ Source

virtual string OpenTD.Results.Dataset.Dataset.Source
getprotected setinherited

The name of the source of the data.

Implements OpenTD.Results.Dataset.IDataset.

◆ UDFAManager

IUDFAManager OpenTD.Results.Dataset.Dataset.UDFAManager = null
getsetprotectedinherited

◆ Units

UnitsData OpenTD.Results.Dataset.Dataset.Units
getsetinherited

The unit system of the dataset.

Implements OpenTD.Results.Dataset.IDataset.


The documentation for this class was generated from the following file:
  • C:/Users/mgarrett/source/repos/BuildsTdSuite/builds/TDDEV_ALPHA/buildXX/OpenTD.Results/Dataset/SpreadsheetDataFile.cs

Connect with Ansys