mir.xlsx

Undocumented in source.

Members

Aliases

ColHeight
alias ColHeight = ColumnHeight
Undocumented in source.
ColOffset
alias ColOffset = ColumnOffset
Undocumented in source.
DenseValue
alias DenseValue = Variant!(typeof(null), bool, Timestamp, double, long, string)

SparseCell 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.
SparseValue
alias SparseValue = Variant!(bool, Timestamp, double, long, string)

SparseCell value without null state.

Start
alias Start = Algebraic!(Address, Position)

Excel table start position/address.

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
SparseCell[] insertValueIntoCell(SparseCell[] 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.
readCells
SparseCell[] 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.

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(DenseValue 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 table as a 2-dimensional dense array.

Extent
struct Extent

Excel table extents as width * height.

Position
struct Position

SparseCell 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