Csv Tcl Reference Documentation

Csv

Object Creation

set myCsv [new CkCsv]

Properties

AutoTrim (boolean 1/0)

set boolVal [CkCsv_get_AutoTrim $myCsv]
CkCsv_put_AutoTrim $myCsv $boolVal

If 1, then the strings returned by GetCell and GetCellByName are auto-trimmed of whitespace from both ends.

Crlf (boolean 1/0)

set boolVal [CkCsv_get_Crlf $myCsv]
CkCsv_put_Crlf $myCsv $boolVal

If 1, then CRLF line endings are used when saving the CSV to a file or to a string (i.e. for the methods SaveFile, SaveFile2, SaveToString). If 0 then bare LF line-endings are used.

DebugLogFilePath (string)

# ckStr is a CkString
CkCsv_get_DebugLogFilePath $myCsv $ckStr
set strVal [CkCsv_get_debugLogFilePath $myCsv]
CkCsv_put_DebugLogFilePath $myCsv $strVal

If set to a file path, causes each Chilkat method or property call to automatically append it's LastErrorText to the specified log file. The information is appended such that if a hang or crash occurs, it is possible to see the context in which the problem occurred, as well as a history of all Chilkat calls up to the point of the problem. The VerboseLogging property can be set to provide more detailed information.

This property is typically used for debugging the rare cases where a Chilkat method call hangs or generates an exception that halts program execution (i.e. crashes). A hang or crash should generally never happen. The typical causes of a hang are:

  1. a timeout related property was set to 0 to explicitly indicate that an infinite timeout is desired,
  2. the hang is actually a hang within an event callback (i.e. it is a hang within the application code), or
  3. there is an internal problem (bug) in the Chilkat code that causes the hang.

Delimiter (string)

# ckStr is a CkString
CkCsv_get_Delimiter $myCsv $ckStr
set strVal [CkCsv_get_delimiter $myCsv]
CkCsv_put_Delimiter $myCsv $strVal

The character that separates fields in a record. It is a comma by default. If the Delimiter property is not explicitly set, the CSV component will detect the delimiter when loading a CSV. (Semicolons are typically used in locales where the comma is used as a decimal point.)

EnableQuotes (boolean 1/0)

set boolVal [CkCsv_get_EnableQuotes $myCsv]
CkCsv_put_EnableQuotes $myCsv $boolVal

Introduced in version 9.5.0.71

If 1, then the double-quote characters cause the quoted content, including CR's, LF's, and delimiter chars to be treated as normal text when reading/writing CSVs. The default is 1.

EscapeBackslash (boolean 1/0)

set boolVal [CkCsv_get_EscapeBackslash $myCsv]
CkCsv_put_EscapeBackslash $myCsv $boolVal

Introduced in version 9.5.0.44

If 1, then the backslash character is treated as an escape character when reading/writing CSVs. The default is 0.

HasColumnNames (boolean 1/0)

set boolVal [CkCsv_get_HasColumnNames $myCsv]
CkCsv_put_HasColumnNames $myCsv $boolVal

Set to 1 prior to loading a CSV if the 1st record contains column names. This allows the CSV parser to correctly load the column names and not treat them as data.

LastErrorHtml (string)

# ckStr is a CkString
CkCsv_get_LastErrorHtml $myCsv $ckStr
set strVal [CkCsv_get_lastErrorHtml $myCsv]

Provides information in HTML format about the last method/property called. If a method call returns a value indicating failure, or behaves unexpectedly, examine this property to get more information.

LastErrorText (string)

# ckStr is a CkString
CkCsv_get_LastErrorText $myCsv $ckStr
set strVal [CkCsv_get_lastErrorText $myCsv]

Provides information in plain-text format about the last method/property called. If a method call returns a value indicating failure, or behaves unexpectedly, examine this property to get more information.

Concept of LastErrorText

LastErrorText Standard Information

LastErrorXml (string)

# ckStr is a CkString
CkCsv_get_LastErrorXml $myCsv $ckStr
set strVal [CkCsv_get_lastErrorXml $myCsv]

Provides information in XML format about the last method/property called. If a method call returns a value indicating failure, or behaves unexpectedly, examine this property to get more information.

LastMethodSuccess (boolean 1/0)

set boolVal [CkCsv_get_LastMethodSuccess $myCsv]
CkCsv_put_LastMethodSuccess $myCsv $boolVal

Introduced in version 9.5.0.52

Indicate whether the last method call succeeded or failed. A value of 1 indicates success, a value of 0 indicates failure. This property is automatically set for method calls. It is not modified by property accesses. The property is automatically set to indicate success for the following types of method calls:

  • Any method that returns a string.
  • Any method returning a Chilkat object, binary bytes, or a date/time.
  • Any method returning a standard boolean status value where success = 1 and failure = 0.
  • Any method returning an integer where failure is defined by a return value less than zero.

Note: Methods that do not fit the above requirements will always set this property equal to 1. For example, a method that returns no value (such as a "void" in C++) will technically always succeed.

NumColumns (integer)

set intVal [CkCsv_get_NumColumns $myCsv]

The number of columns in the 1st row, which may be the row containing column names if HasColumnNames is 1.

NumRows (integer)

set intVal [CkCsv_get_NumRows $myCsv]

The number of data rows. If the CSV has column names, the 1st row is not included in the count. Also, empty lines containing only whitespace characters that follow the last non-empty row are not included.

Utf8 (boolean 1/0)

set boolVal [CkCsv_get_Utf8 $myCsv]
CkCsv_put_Utf8 $myCsv $boolVal

When set to 1, all "const char *" arguments are interpreted as utf-8 strings. If set to 0 (the default), then "const char *" arguments are interpreted as ANSI strings. Also, when set to 1, and Chilkat method returning a "const char *" is returning the utf-8 representation. If set to 0, all "const char *" return values are ANSI strings.

VerboseLogging (boolean 1/0)

set boolVal [CkCsv_get_VerboseLogging $myCsv]
CkCsv_put_VerboseLogging $myCsv $boolVal

If set to 1, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. The default value is 0. Verbose logging should only be used for debugging. The potentially large quantity of logged information may adversely affect peformance.

Version (string)

# ckStr is a CkString
CkCsv_get_Version $myCsv $ckStr
set strVal [CkCsv_get_version $myCsv]

Version of the component/library, such as "9.5.0.63"

Methods

# index is an integer
set status [CkCsv_DeleteColumn $index]

Deletes the Nth column. (The 1st column is at index 0.)

Returns 1 for success, 0 for failure.

# columnName is a string
set status [CkCsv_DeleteColumnByName $columnName]

Deletes a column specified by name.

Returns 1 for success, 0 for failure.

# index is an integer
set status [CkCsv_DeleteRow $index]

Deletes the entire Nth row. (The 1st row is at index 0.)

Returns 1 for success, 0 for failure.

# row is an integer
# col is an integer
# outStr is a CkString (output)
set status [CkCsv_GetCell $row $col $outStr]
set retStr [CkCsv_getCell $myCsv $row $col]

Returns the contents of the cell at row, col. Indexing begins at 0. (The topmost/leftmost cell is at 0,0)

Returns 1 for success, 0 for failure.

# rowIndex is an integer
# columnName is a string
# outStr is a CkString (output)
set status [CkCsv_GetCellByName $rowIndex $columnName $outStr]
set retStr [CkCsv_getCellByName $myCsv $rowIndex $columnName]

The same as GetCell, but the column is specified by name instead of by index.

Returns 1 for success, 0 for failure.

# index is an integer
# outStr is a CkString (output)
set status [CkCsv_GetColumnName $index $outStr]
set retStr [CkCsv_getColumnName $myCsv $index]

Returns the name of the Nth column.

Returns 1 for success, 0 for failure.

# columnName is a string
set retInt [CkCsv_GetIndex $columnName]

Returns the column index for a given column.

# row is an integer
set retInt [CkCsv_GetNumCols $row]

Returns the number of columns for a specific row. If the row is larger than the number of rows in the CSV, a zero is returned.

# path is a string
set status [CkCsv_LoadFile $path]

Loads a CSV from a file. It is assumed that the CSV file contains ANSI characters.

Returns 1 for success, 0 for failure.

# filename is a string
# charset is a string
set status [CkCsv_LoadFile2 $filename $charset]

Loads a CSV from a file. The charset specifies the character encoding of the CSV file. A list of supported character encodings may be found on this page: Supported Charsets.

Returns 1 for success, 0 for failure.

Read Japanese utf-8 CSV File

# csvData is a string
set status [CkCsv_LoadFromString $csvData]

Loads a CSV document from an in-memory string variable.

Returns 1 for success, 0 for failure.

# rowIndex is an integer
# matchPattern is a string
# caseSensitive is a boolean
set retBool [CkCsv_RowMatches $rowIndex $matchPattern $caseSensitive]

Compares the contents of an entire row to a wildcarded match pattern where "*" can be used any number of times to match 0 or more of any character. Returns 1 if a match was found, otherwise returns 0. If caseSensitive is 1, then the pattern match is case sensitive, otherwise it is case insensitive.

# path is a string
set status [CkCsv_SaveFile $path]

Saves a CSV to a file. The output file is written using the ANSI character encoding.

Returns 1 for success, 0 for failure.

# filename is a string
# charset is a string
set status [CkCsv_SaveFile2 $filename $charset]

Saves a CSV to a file. The charset specifies the character encoding to use for the CSV file. The text data is converted to this charset when saving. A list of supported character encodings may be found on this page: Supported Charsets.

Returns 1 for success, 0 for failure.

# path is a string
set status [CkCsv_SaveLastError $path]

Saves the last-error information (the contents of LastErrorXml) to an XML formatted file.

Returns 1 for success, 0 for failure.

# outStr is a CkString (output)
set status [CkCsv_SaveToString $outStr]
set retStr [CkCsv_saveToString $myCsv]

Writes the entire CSV document to a string variable.

Returns 1 for success, 0 for failure.

# row is an integer
# col is an integer
# content is a string
set status [CkCsv_SetCell $row $col $content]

Sets the contents for a single cell in the CSV. The content may include any characters including CRLF's, double-quotes, and the delimiter character. The Save* methods automatically double-quote fields with special chars when saving. The Load* methods automatically parse double-quoted and/or escaped fields correctly when loading.

Returns 1 for success, 0 for failure.

# rowIndex is an integer
# columnName is a string
# contentStr is a string
set status [CkCsv_SetCellByName $rowIndex $columnName $contentStr]

The same as SetCell, except the column is specified by name instead of by index.

Returns 1 for success, 0 for failure.

# index is an integer
# columnName is a string
set status [CkCsv_SetColumnName $index $columnName]

Sets the name of the Nth column. The first column is at index 0. This method would only return 0 if an invalid index is passed (such as a negative number).

Returns 1 for success, 0 for failure.

# columnName is a string
# ascending is a boolean
# caseSensitive is a boolean
set status [CkCsv_SortByColumn $columnName $ascending $caseSensitive]

Sorts the rows in the CSV by the contents of a specific column. If ascending is 1, the sort is in ascending order, otherwise descending order. If caseSensitive is 1 then the sorting is case sensitive.

Returns 1 for success, 0 for failure.