Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, CLI, Studio and browser tools 573 stars PSWriteOfficePowerShell module 165 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/

API Reference

Class

IWorkTableData

Edit on GitHub
Namespace OfficeIMO.IWork
Assembly OfficeIMO.IWork
Source IWorkTableData.cs:20
Modifiers sealed

Mutable sparse scalar data for a newly created iWork table.

Inheritance

  • Object
  • IWorkTableData

Remarks

Coordinates are one-based. Each axis supports 1–256 positions. Unset positions are empty; text is stored as text even when it begins with an equals sign. Instances are not thread safe.

Usage

Explore 8 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by 5

Accepted by parameters 3

Methods

public IWorkTableData ClearCell(Int32 row, Int32 column) #
IWorkTableData.cs:46
Returns: IWorkTableData

Returns a position to an unset empty cell.

Parameters

row System.Int32 requiredposition: 0
column System.Int32 requiredposition: 1
public static IWorkTableData Create(Int32 rows, Int32 columns) #
IWorkTableData.cs:20
Returns: IWorkTableData

Creates an empty table with fixed row and column counts.

Parameters

rows System.Int32 requiredposition: 0
columns System.Int32 requiredposition: 1
public IWorkTableCell GetCell(Int32 row, Int32 column) #
IWorkTableData.cs:50
Returns: IWorkTableCell

Gets the scalar at a position, or an empty cell when it has not been set.

Parameters

row System.Int32 requiredposition: 0
column System.Int32 requiredposition: 1
public IWorkTableData SetBoolean(Int32 row, Int32 column, Boolean value) #
IWorkTableData.cs:42
Returns: IWorkTableData

Sets a boolean value, retaining its type rather than a text label.

Parameters

row System.Int32 requiredposition: 0
column System.Int32 requiredposition: 1
value System.Boolean requiredposition: 2
SetNumber 2 overloads
public IWorkTableData SetNumber(Int32 row, Int32 column, Double value) #
IWorkTableData.cs:28
Returns: IWorkTableData

Sets a finite IEEE-754 double as a numeric value.

Parameters

row System.Int32 requiredposition: 0
column System.Int32 requiredposition: 1
value System.Double requiredposition: 2
public IWorkTableData SetNumber(Int32 row, Int32 column, Double value, IWorkNumberFormat numberFormat) #
IWorkTableData.cs:35
Returns: IWorkTableData

Sets a finite number with an immutable explicit decimal, percentage or scientific format.

Parameters

row System.Int32 requiredposition: 0
column System.Int32 requiredposition: 1
value System.Double requiredposition: 2
numberFormat OfficeIMO.IWork.IWorkNumberFormat requiredposition: 3
public IWorkTableData SetText(Int32 row, Int32 column, String text) #
IWorkTableData.cs:24
Returns: IWorkTableData

Sets text, normalizing CR/CRLF to LF and rejecting other controls and invalid UTF-16.

Parameters

row System.Int32 requiredposition: 0
column System.Int32 requiredposition: 1
text System.String requiredposition: 2

Properties

public Int32 RowCount { get; } #
IWorkTableData.cs:16

Gets the number of rows, including unset empty positions.

public Int32 ColumnCount { get; } #
IWorkTableData.cs:18

Gets the number of columns, including unset empty positions.