Difference between revisions of "Component: CSV Read/Write (File)"
Line 67: | Line 67: | ||
Simple example file to generate a two column CSV file that can be loaded into Microsoft Excel or LibreOffice Math. | 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 [[Component:_Embed_File_(File)|File component]] | ||
CSV Component used with App Developer -> File component: {{Fcfile|CSVTestAD.fcsx|CSV Test AD}} | CSV Component used with App Developer -> File component: {{Fcfile|CSVTestAD.fcsx|CSV Test AD}} |
Revision as of 10:01, 29 March 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.
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
AddNumber
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 |
AddString
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 |
CloseFile
CloseFile | |
Closes the file and finishes off any pending writes ready for use in an external application. | |
- VOID | Return |
NextRow
NextRow | |
Move to the next row in the file | |
- VOID | Return |
OpenFile
ReadAsNumber
ReadAsNumber | |
Reads the contents of a cell as a number. | |
- UINT | Column |
- UINT | Row |
- FLOAT | Return |
ReadAsString
ReadAsString | |
Reads the contents of a cell as a string | |
- UINT | Column |
- UINT | Row |
- STRING | Return |
SequentialReadNumber
SequentialReadNumber | |
Reads the contents of a cell as a number. Automatically moved to the next data cell after a read. | |
- FLOAT | Return |
SequentialReadString
SequentialReadString | |
Reads the contents of a cell as a string. Automatically moved to the next data cell after a read. | |
- STRING | Return |
SetSequentialIndex
SetSequentialIndex | |
Sets the index for sequential reads. Index is automatically reset to 0 after a file open. | |
- UINT | Index |
- VOID | Return |
Property reference
Properties | |
LinkTo | |