ProjectDataWorkflow
OfficeIMO.Workflows
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
- cancellationToken System.Threading.CancellationToken = default
Returns
CsvDocumentpublic 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
- cancellationToken System.Threading.CancellationToken = default
Returns
ExcelDocumentpublic 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
- maxRows int = 100000
- maxCells int = 2000000
- cancellationToken System.Threading.CancellationToken = default
Returns
ProjectDataTablepublic 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
- dataRowCount int
- columnCount int
- headerRow int = 1
- firstColumn int = 1
- maxRows int = 100000
- maxCells int = 2000000
- cancellationToken System.Threading.CancellationToken = default
Returns
ProjectDataTable