Difference between revisions of "Component: CSV Read/Write (File)"
Line 22: | Line 22: | ||
==Detailed description== | ==Detailed description== | ||
+ | |||
+ | |||
Line 46: | Line 48: | ||
==Examples== | ==Examples== | ||
+ | |||
+ | |||
Line 69: | Line 73: | ||
==Macro reference== | ==Macro reference== | ||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''CloseFile''' | ||
+ | |- | ||
+ | | colspan="2" | Closes the file and finishes off any pending writes ready for use in an external application. | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-void-icon.png]] - VOID | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''SequentialReadString''' | ||
+ | |- | ||
+ | | colspan="2" | Reads the contents of a cell as a string. Automatically moved to the next data cell after a read. | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-string-icon.png]] - STRING | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''AddString''' | ||
+ | |- | ||
+ | | colspan="2" | Adds a string to the CSV followed by a comma. This will form a single column of data in the CSV file. | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-string-icon.png]] - STRING | ||
+ | | width="90%" | data | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-void-icon.png]] - VOID | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''ReadAsString''' | ||
+ | |- | ||
+ | | colspan="2" | Reads the contents of a cell as a string | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-u16-icon.png]] - UINT | ||
+ | | width="90%" | Column | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-u16-icon.png]] - UINT | ||
+ | | width="90%" | Row | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-string-icon.png]] - STRING | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''SequentialReadNumber''' | ||
+ | |- | ||
+ | | colspan="2" | Reads the contents of a cell as a number. Automatically moved to the next data cell after a read. | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-f32-icon.png]] - FLOAT | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''AddNumber''' | ||
+ | |- | ||
+ | | colspan="2" | Adds a number to the CSV followed by a comma. This will form a single column of data in the CSV file. | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-f32-icon.png]] - FLOAT | ||
+ | | width="90%" | data | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-void-icon.png]] - VOID | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''ReadAsNumber''' | ||
+ | |- | ||
+ | | colspan="2" | Reads the contents of a cell as a number. | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-u16-icon.png]] - UINT | ||
+ | | width="90%" | Column | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-u16-icon.png]] - UINT | ||
+ | | width="90%" | Row | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-f32-icon.png]] - FLOAT | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''SetSequentialIndex''' | ||
+ | |- | ||
+ | | colspan="2" | Sets the index for sequential reads. Index is automatically reset to 0 after a file open. | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-u16-icon.png]] - UINT | ||
+ | | width="90%" | Index | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-void-icon.png]] - VOID | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''OpenFile''' | ||
+ | |- | ||
+ | | colspan="2" | Creates or opens a file ready for streaming data. If the file already exists then the contents will be deleted and the file started again from scratch. Returns 1 if file found and opened. | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-string-icon.png]] - STRING | ||
+ | | width="90%" | Filename | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-bool-icon.png]] - BOOL | ||
+ | | width="90%" | Erase | ||
+ | |- | ||
+ | | colspan="2" | 0=Append existing data, 1=Reset file data | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-bool-icon.png]] - BOOL | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''NextRow''' | ||
+ | |- | ||
+ | | colspan="2" | Move to the next row in the file | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-void-icon.png]] - VOID | ||
+ | | width="90%" style="border-top: 2px solid #000;" | ''Return'' | ||
+ | |} | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ==Property reference== | ||
+ | |||
+ | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" | ||
+ | |- | ||
+ | | width="10%" align="center" style="background-color:#D8C9D8;" | [[File:Fc9-prop-icon.png]] | ||
+ | | width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''Properties''' | ||
+ | |- | ||
+ | |- | ||
+ | | width="10%" align="center" | [[File:Fc9-type-16-icon.png]] | ||
+ | | width="90%" | LinkTo | ||
+ | |- | ||
+ | | colspan="2" | | ||
+ | |}==Macro reference== | ||
{| class="wikitable" style="width:60%; background-color:#FFFFFF;" | {| class="wikitable" style="width:60%; background-color:#FFFFFF;" |
Revision as of 09:55, 27 January 2023
Author | Matrix TSL |
Version | 1.0 |
Category | File |
Contents
CSV Read/Write component
A component to simplify the task of creating and dumping data to a CSV file that can be loaded into Microcoft Excel or LibreOffice Math to create nice charts and graphs. Requires one of the File components to provide access to the file system.
Component Source Code
Please click here to download the component source project: FC_Comp_Source_CSV_Writer.fcfx
Please click here to view the component source code (Beta): FC_Comp_Source_CSV_Writer.fcfx
Detailed description
No detailed description exists yet for this component
Examples
Simple example file to generate a two column CSV file that can be loaded into Microsoft Excel or LibreOffice Math.
CSV Component used with Embedded -> File SD component: CSV Test
CSV Component used with Embedded -> File RPI component: CSV Test RPI
CSV Component used with App Developer -> File component: CSV Test AD
The component requires linking to a File component to provide access to the file system for simulation and runtime, this could be the File SD, File RPI or File AppDeveloper components.
Macro reference
CloseFile | |
Closes the file and finishes off any pending writes ready for use in an external application. | |
- VOID | Return |
SequentialReadString | |
Reads the contents of a cell as a string. Automatically moved to the next data cell after a read. | |
- STRING | Return |
AddString | |
Adds a string to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- STRING | data |
- VOID | Return |
ReadAsString | |
Reads the contents of a cell as a string | |
- UINT | Column |
- UINT | Row |
- STRING | Return |
SequentialReadNumber | |
Reads the contents of a cell as a number. Automatically moved to the next data cell after a read. | |
- FLOAT | Return |
AddNumber | |
Adds a number to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- FLOAT | data |
- VOID | Return |
ReadAsNumber | |
Reads the contents of a cell as a number. | |
- UINT | Column |
- UINT | Row |
- FLOAT | Return |
SetSequentialIndex | |
Sets the index for sequential reads. Index is automatically reset to 0 after a file open. | |
- UINT | Index |
- VOID | Return |
NextRow | |
Move to the next row in the file | |
- VOID | Return |
Property reference
Properties | |
LinkTo | |
==Macro reference==
CloseFile | |
Closes the file and finishes off any pending writes ready for use in an external application. | |
- VOID | Return |
SequentialReadString | |
Reads the contents of a cell as a string. Automatically moved to the next data cell after a read. | |
- STRING | Return |
AddString | |
Adds a string to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- STRING | data |
- VOID | Return |
ReadAsString | |
Reads the contents of a cell as a string | |
- UINT | Column |
- UINT | Row |
- STRING | Return |
SequentialReadNumber | |
Reads the contents of a cell as a number. Automatically moved to the next data cell after a read. | |
- FLOAT | Return |
AddNumber | |
Adds a number to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- FLOAT | data |
- VOID | Return |
ReadAsNumber | |
Reads the contents of a cell as a number. | |
- UINT | Column |
- UINT | Row |
- FLOAT | Return |
SetSequentialIndex | |
Sets the index for sequential reads. Index is automatically reset to 0 after a file open. | |
- UINT | Index |
- VOID | Return |
NextRow | |
Move to the next row in the file | |
- VOID | Return |
Property reference
Properties | |
LinkTo | |
==Macro reference==
CloseFile | |
Closes the file and finishes off any pending writes ready for use in an external application. | |
- VOID | Return |
SequentialReadString | |
Reads the contents of a cell as a string. Automatically moved to the next data cell after a read. | |
- STRING | Return |
AddString | |
Adds a string to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- STRING | data |
- VOID | Return |
ReadAsString | |
Reads the contents of a cell as a string | |
- UINT | Column |
- UINT | Row |
- STRING | Return |
SequentialReadNumber | |
Reads the contents of a cell as a number. Automatically moved to the next data cell after a read. | |
- FLOAT | Return |
AddNumber | |
Adds a number to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- FLOAT | data |
- VOID | Return |
ReadAsNumber | |
Reads the contents of a cell as a number. | |
- UINT | Column |
- UINT | Row |
- FLOAT | Return |
SetSequentialIndex | |
Sets the index for sequential reads. Index is automatically reset to 0 after a file open. | |
- UINT | Index |
- VOID | Return |
NextRow | |
Move to the next row in the file | |
- VOID | Return |
Property reference
Properties | |
LinkTo | |
==Macro reference==
CloseFile | |
Closes the file and finishes off any pending writes ready for use in an external application. | |
- VOID | Return |
SequentialReadString | |
Reads the contents of a cell as a string. Automatically moved to the next data cell after a read. | |
- STRING | Return |
AddString | |
Adds a string to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- STRING | data |
- VOID | Return |
ReadAsString | |
Reads the contents of a cell as a string | |
- UINT | Column |
- UINT | Row |
- STRING | Return |
SequentialReadNumber | |
Reads the contents of a cell as a number. Automatically moved to the next data cell after a read. | |
- FLOAT | Return |
AddNumber | |
Adds a number to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- FLOAT | data |
- VOID | Return |
ReadAsNumber | |
Reads the contents of a cell as a number. | |
- UINT | Column |
- UINT | Row |
- FLOAT | Return |
SetSequentialIndex | |
Sets the index for sequential reads. Index is automatically reset to 0 after a file open. | |
- UINT | Index |
- VOID | Return |
NextRow | |
Move to the next row in the file | |
- VOID | Return |
Property reference
Properties | |
LinkTo | |
==Macro reference==
CloseFile | |
Closes the file and finishes off any pending writes ready for use in an external application. | |
- VOID | Return |
SequentialReadString | |
Reads the contents of a cell as a string. Automatically moved to the next data cell after a read. | |
- STRING | Return |
AddString | |
Adds a string to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- STRING | data |
- VOID | Return |
ReadAsString | |
Reads the contents of a cell as a string | |
- UINT | Column |
- UINT | Row |
- STRING | Return |
SequentialReadNumber | |
Reads the contents of a cell as a number. Automatically moved to the next data cell after a read. | |
- FLOAT | Return |
AddNumber | |
Adds a number to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
- FLOAT | data |
- VOID | Return |
ReadAsNumber | |
Reads the contents of a cell as a number. | |
- UINT | Column |
- UINT | Row |
- FLOAT | Return |
SetSequentialIndex | |
Sets the index for sequential reads. Index is automatically reset to 0 after a file open. | |
- UINT | Index |
- VOID | Return |
NextRow | |
Move to the next row in the file | |
- VOID | Return |
Property reference
Properties | |
LinkTo | |