Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

ProjectDataWorkflow

OfficeIMO.Workflows

Namespace
OfficeIMO.Workflows
Assembly
OfficeIMO.Workflows
Source revision
ba882f6b0d07 with working tree changes
Modifiers
static

CSV and Excel transport for explicit Project field maps. Parsing and package handling remain in their owning libraries.

Inheritance

  • object
  • ProjectDataWorkflow

Methods

public static CsvDocument CreateCsv(ProjectDataTable table, CancellationToken cancellationToken = default) #

Creates a CSV document containing the exact table text. Save/load settings, quoting and delimiter handling belong to OfficeIMO.CSV.

Parameters

table OfficeIMO.Project.ProjectDataTable required
cancellationToken System.Threading.CancellationToken = default optional

Returns

CsvDocument
public static ExcelDocument CreateExcel(ProjectDataExportResult export, CancellationToken cancellationToken = default) #

Creates a workbook with one worksheet per mapped table and a separate sheet describing projection losses. Values remain literal text to preserve precision and prevent formula execution.

Parameters

export OfficeIMO.Project.ProjectDataExportResult required
cancellationToken System.Threading.CancellationToken = default optional

Returns

ExcelDocument
public static ProjectDataTable ReadCsv(CsvDocument csv, int maxRows = 100000, int maxCells = 2000000, CancellationToken cancellationToken = default) #

Copies a parsed CSV table without reflection or culture-dependent value conversion.

Parameters

csv OfficeIMO.CSV.CsvDocument required
maxRows int = 100000 optional
maxCells int = 2000000 optional
cancellationToken System.Threading.CancellationToken = default optional

Returns

ProjectDataTable
public static ProjectDataTable ReadExcel(ExcelSheet sheet, int dataRowCount, int columnCount, int headerRow = 1, int firstColumn = 1, int maxRows = 100000, int maxCells = 2000000, CancellationToken cancellationToken = default) #

Reads an explicitly bounded worksheet rectangle with headers in its first row. Formula and error cells are rejected; numeric/date cells use invariant underlying values.

Parameters

sheet OfficeIMO.Excel.ExcelSheet required
dataRowCount int required
columnCount int required
headerRow int = 1 optional
firstColumn int = 1 optional
maxRows int = 100000 optional
maxCells int = 2000000 optional
cancellationToken System.Threading.CancellationToken = default optional

Returns

ProjectDataTable