Component: CSV Read/Write (File)

Author	Matrix TSL
Version	1.0
Category	File

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

	CloseFile
Closes the file and finishes off any pending writes ready for use in an external application.
- VOID	Return

SequentialReadString

	SequentialReadString
Reads the contents of a cell as a string. Automatically moved to the next data cell after a read.
- STRING	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

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

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

ReadAsNumber

	ReadAsNumber
Reads the contents of a cell as a number.
- UINT	Column
- UINT	Row
- FLOAT	Return

SetSequentialIndex

	SetSequentialIndex
Sets the index for sequential reads. Index is automatically reset to 0 after a file open.
- UINT	Index
- VOID	Return

OpenFile

	OpenFile
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.
- STRING	Filename
- BOOL	Erase
0=Append existing data, 1=Reset file data
- BOOL	Return

NextRow

	NextRow
Move to the next row in the file
- VOID	Return

Property reference

	Properties
	LinkTo