Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/

API Reference

Class

ProjectDataWorkflow

Namespace OfficeIMO.Workflows
Assembly OfficeIMO.Workflows
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) #
Returns: CsvDocument

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 requiredposition: 0
cancellationToken System.Threading.CancellationToken = default optionalposition: 1
public static ExcelDocument CreateExcel(ProjectDataExportResult export, CancellationToken cancellationToken = default) #
Returns: ExcelDocument

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 requiredposition: 0
cancellationToken System.Threading.CancellationToken = default optionalposition: 1
public static ProjectDataTable ReadCsv(CsvDocument csv, Int32 maxRows = 100000, Int32 maxCells = 2000000, CancellationToken cancellationToken = default) #
Returns: ProjectDataTable

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

Parameters

csv OfficeIMO.CSV.CsvDocument requiredposition: 0
maxRows System.Int32 = 100000 optionalposition: 1
maxCells System.Int32 = 2000000 optionalposition: 2
cancellationToken System.Threading.CancellationToken = default optionalposition: 3
public static ProjectDataTable ReadExcel(ExcelSheet sheet, Int32 dataRowCount, Int32 columnCount, Int32 headerRow = 1, Int32 firstColumn = 1, Int32 maxRows = 100000, Int32 maxCells = 2000000, CancellationToken cancellationToken = default) #
Returns: ProjectDataTable

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 requiredposition: 0
dataRowCount System.Int32 requiredposition: 1
columnCount System.Int32 requiredposition: 2
headerRow System.Int32 = 1 optionalposition: 3
firstColumn System.Int32 = 1 optionalposition: 4
maxRows System.Int32 = 100000 optionalposition: 5
maxCells System.Int32 = 2000000 optionalposition: 6
cancellationToken System.Threading.CancellationToken = default optionalposition: 7