mir.xlsx

Undocumented in source.

Members

Aliases

Cell
alias Cell = SparseCell
Undocumented in source.
ColHeight
alias ColHeight = ColumnHeight
Undocumented in source.
ColOffset
alias ColOffset = ColumnOffset
Undocumented in source.
Data
alias Data = Value

Cell value with null state.

Length
alias Length = uint

Row width or column height precision.

Offset
alias Offset = uint

Row or column offset precision.

RelationshipsById
alias RelationshipsById = Relationships[string]
Undocumented in source.
SILdoc
alias SILdoc = ReflectDoc!"SIL"
Undocumented in source.
SILignore
alias SILignore = reflectIgnore!"SIL"
Undocumented in source.
Start
alias Start = Algebraic!(Address, Position)

Excel table start position/address.

Value
alias Value = Variant!(IonNull, bool, TimeOfDay, Date, DateTime, double, long, string)

Cell value with null state.

Functions

convertTo
T convertTo(string var)
Undocumented in source. Be warned that the author may not have intended to support it.
convertToString
string convertToString(inout(ubyte)[] d)

Strip BOM and convert ubyte[] to a string.

dateToLong
long dateToLong(Date d)
Undocumented in source. Be warned that the author may not have intended to support it.
datetimeToDouble
double datetimeToDouble(DateTime dt)
Undocumented in source. Be warned that the author may not have intended to support it.
doubleToDateTime
DateTime doubleToDateTime(double d)
Undocumented in source. Be warned that the author may not have intended to support it.
doubleToTimeOfDay
TimeOfDay doubleToTimeOfDay(double s)
Undocumented in source. Be warned that the author may not have intended to support it.
eatXlPrefix
string eatXlPrefix(string fn)
Undocumented in source. Be warned that the author may not have intended to support it.
elementMax
Position elementMax(Position a, Position b)
Undocumented in source. Be warned that the author may not have intended to support it.
extractData
string extractData(DOMEntity!string si)
Undocumented in source. Be warned that the author may not have intended to support it.
insertValueIntoCell
Cell[] insertValueIntoCell(Cell[] cells, string[] ss)

Param: ss is the shared string (table)

longToDate
Date longToDate(long d)
Undocumented in source. Be warned that the author may not have intended to support it.
parseRelationships
deprecated RelationshipsById parseRelationships(ZipArchive za, ArchiveMember am)
Undocumented in source. Be warned that the author may not have intended to support it.
readCells
Cell[] readCells(ZipArchive za, ArchiveMember am)
Undocumented in source. Be warned that the author may not have intended to support it.
readSharedEntries
string[] readSharedEntries(ZipArchive za, ArchiveMember am)
Undocumented in source. Be warned that the author may not have intended to support it.
readSheet
Sheet readSheet(string filename, string sheetName)

Read sheet named sheetName from filename.

readSheetImpl
deprecated Sheet readSheetImpl(string filename, string rid, string sheetName)
Undocumented in source. Be warned that the author may not have intended to support it.
removeSpecialCharacter
deprecated string removeSpecialCharacter(string s)
Undocumented in source. Be warned that the author may not have intended to support it.
sheetNames
deprecated SheetNameId[] sheetNames(string filename)

Read sheet names stored in filename.

specialCharacterReplacement
deprecated string specialCharacterReplacement(string s)
Undocumented in source. Be warned that the author may not have intended to support it.
specialCharacterReplacementReverse
deprecated string specialCharacterReplacementReverse(string s)
Undocumented in source. Be warned that the author may not have intended to support it.
stringToDate
Date stringToDate(string s)
Undocumented in source. Be warned that the author may not have intended to support it.
timeOfDayToDouble
double timeOfDayToDouble(TimeOfDay tod)
Undocumented in source. Be warned that the author may not have intended to support it.
toPos
Position toPos(string s)
Undocumented in source. Be warned that the author may not have intended to support it.
tryConvertTo
bool tryConvertTo(S var)
Undocumented in source. Be warned that the author may not have intended to support it.
tryConvertToImpl
Nullable!(T) tryConvertToImpl(Data var)
Undocumented in source. Be warned that the author may not have intended to support it.

Manifest constants

runCount
enum runCount;
Undocumented in source.
runCount
enum runCount;
Undocumented in source.
tme
enum tme;
Undocumented in source.
tme
enum tme;
Undocumented in source.

Structs

Address
struct Address

Excel cell address in the format "A1", "A2", ....

ColumnHeight
struct ColumnHeight

Column height in number of columns.

ColumnOffset
struct ColumnOffset

Column offset, starting at 0 for left-most column.

ColumnRange
struct ColumnRange
DenseCell
struct DenseCell

Sheet cell that doesn’t need to hold position in dense table storage.

DenseTable
struct DenseTable

Excel jaggedTable as a multidimensional array.

Extent
struct Extent

Excel table extents as width * height.

JaggedTable
struct JaggedTable

Excel table as a jagged array.

Position
struct Position

Cell position offset, starting at [0,0] for top-left cell. See: https://support.socrata.com/hc/en-us/articles/115005306167-Limitations-of-Excel-and-CSV-Downloads

Region
struct Region

Excel sheet region.

Relationships
struct Relationships
Undocumented in source.
RowOffset
struct RowOffset

Row offset, starting at 0 for top-most row.

RowRange
struct RowRange
RowWidth
struct RowWidth

Row width in number of rows.

Sheet
struct Sheet

Sheet.

SheetNameId
struct SheetNameId

Sheet name, id and rid.

SparseCell
struct SparseCell

Sheet cell that holds position for use in sparse table storage.

Workbook
struct Workbook

Workbook.

Meta