...
| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| heading | 0 |
|---|
| columnTypes | s,s,s,s |
|---|
| 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.
Parameters
| 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.
Examples
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 |
|---|
|