Difference between revisions of "Component: CSV Read/Write (File)"
Line 14: | Line 14: | ||
==CSV Read/Write component== | ==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. | 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. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
==Detailed description== | ==Detailed description== | ||
Line 79: | Line 73: | ||
==Macro reference== | ==Macro reference== | ||
+ | |||
+ | ===AddInteger=== | ||
+ | {| 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;" | '''AddInteger''' | ||
+ | |- | ||
+ | | colspan="2" | Adds an integer 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-s32-icon.png]] - LONG | ||
+ | | 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'' | ||
+ | |} | ||
+ | |||
===AddNumber=== | ===AddNumber=== | ||
Line 278: | Line 291: | ||
| colspan="2" | | | colspan="2" | | ||
|} | |} | ||
+ | |||
+ | ==Component Source Code== | ||
+ | |||
+ | Please click here to download the component source project: [https://www.flowcode.co.uk/wiki/componentsource/FC_Comp_Source_CSV_Writer.fcfx FC_Comp_Source_CSV_Writer.fcfx] | ||
+ | |||
+ | Please click here to view the component source code (Beta): [https://www.flowcode.co.uk/FlowchartView/?wfile=componentsource/FC_Comp_Source_CSV_Writer.fcfx FC_Comp_Source_CSV_Writer.fcfx] |
Latest revision as of 09:14, 16 July 2024
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.
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.
The CSV Read/Write component is for simulation or App Developer.
For an embedded CSV read write see the File component
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
AddInteger
![]() |
AddInteger |
Adds an integer number to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
![]() |
data |
![]() |
Return |
AddNumber
![]() |
AddNumber |
Adds a number to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
![]() |
data |
![]() |
Return |
AddString
![]() |
AddString |
Adds a string to the CSV followed by a comma. This will form a single column of data in the CSV file. | |
![]() |
data |
![]() |
Return |
CloseFile
![]() |
CloseFile |
Closes the file and finishes off any pending writes ready for use in an external application. | |
![]() |
Return |
NextRow
![]() |
NextRow |
Move to the next row in the file | |
![]() |
Return |
OpenFile
ReadAsNumber
![]() |
ReadAsNumber |
Reads the contents of a cell as a number. | |
![]() |
Column |
![]() |
Row |
![]() |
Return |
ReadAsString
![]() |
ReadAsString |
Reads the contents of a cell as a string | |
![]() |
Column |
![]() |
Row |
![]() |
Return |
SequentialReadNumber
![]() |
SequentialReadNumber |
Reads the contents of a cell as a number. Automatically moved to the next data cell after a read. | |
![]() |
Return |
SequentialReadString
![]() |
SequentialReadString |
Reads the contents of a cell as a string. Automatically moved to the next data cell after a read. | |
![]() |
Return |
SetSequentialIndex
![]() |
SetSequentialIndex |
Sets the index for sequential reads. Index is automatically reset to 0 after a file open. | |
![]() |
Index |
![]() |
Return |
Property reference
![]() |
Properties |
![]() |
LinkTo |
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