| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| heading | 0 |
|---|
| columnTypes | s,s,s,s |
|---|
| heading | 0 |
|---|
| multiple | false |
|---|
| columnAttributes | style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold, |
|---|
| enableSorting | false |
|---|
|
Syntax | readFromCSVFile(path, hasHeader [, charset]) | Package | file | Alias |
| Pkg Usage | readCSV(path, hasHeader [, charset]) |
|
Description
| Excerpt |
|---|
|
Reads the values from the CSV file, returning them to an array, of N rows * M columns values. |
Reads the values from the CSV file, returning them to an array, of N rows * M columns values.
...
| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| columnTypes | s,s,s,s |
|---|
| heading | 0 |
|---|
| multiple | false |
|---|
| enableSorting | false |
|---|
|
Parameter name | Type | Required | Description |
|---|
path | String | Yes | Specifies the file name to read from. | hasHeader | Boolean | Yes | Specifies if the file has header. | charset | String | No | Specifies the charset used to read that file. |
|
Return Type
String []
The values from the file, as a string array.
...
The basic form will look like this:
| Code Block |
|---|
|
string [] fileContent = readFromCSVFile("C:/test.csv", true); |
However it is hardly usable. A better form will look like this:
| Code Block |
|---|
|
//Suppose we have a CSV file with 3 columns, First Name, Last Name, Age
struct Emp {
string fName;
string
lName;
number age;
}
Emp [] fileContent = readFromCSVFile("C:/test.csv", true);
for(Emp e in fileContent) {
//we can address them now in a better way.... so process row after row
string s = e.fName + " " + e.lName + " / " + e.age;
//do smth with that 's'
} |
Unless calendar dates are in formats SIL can understand, dates should be imported as strings and further parsed afterwards in your SIL program.
| Note |
|---|
You can use absolute paths and relative paths to "sil.home". If the header exist, it must not have duplicated columns, otherwise you need to skip it manually. If the file is not found, an error will be raised.
|
See also
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 25 |
|---|
| showSpace | false |
|---|
| cql | label = "file_routine" and space = currentSpace ( ) |
|---|
| labels | array_routines |
|---|
|
We've encountered an issue exporting this macro. Please try exporting this page again later.