vexcel − Convert an excel file to VisionX format

vexcel [if=infile] [of=ofile] [-ft] [-fv] [-fx] [-nh] [-v] [-i] [-f] [-t]

Vexcel converts a comma separated text file (csv) or tab separated text file into a VisionX file.

By default, text files are converted into VisionX files with VisionX text elements representing comma-separated data (VX_CTABLE) or tab-separated data (VX_TTABLE). These elements store the data as in the same representation as in the text file (for example, a CSV file will be stored in a VX_CTABLE element). Other formats include a vector format (-fv), which stores each line in the file as a floating point vector (VX_GFLOAT), or a text format, which stores the file in a VisionX text file.

The first line is assumed to be a header line unless otherwise specified. This is stored in a generic text (VX_GTEXT) element.

The inverse operation (-i) will convert a VisionX file with VX_CTABLE, VX_TTABLE, VX_V2D, VX_V3D, and VX_GFLOAT elements to a comma-separated (default) or tab-separated (-t) file. VisionX 2D and 3D vectors are treated as 1D arrays when output.

-ft

Output to a VisionX file containing text table elements (default)

-fv

Output to a VisionX file containing floating point vectors

-fx

Output to a VisionX text file

-nh

File does not contain a header

-f

Inserts frame markers (not very useful, but included for compatibility)

-v

The -v flag selects the verbose option.

-i

Performs the inverse operation (converts VisionX file to excel format). Does not work with VisionX text files.

-t

The -t flag, when the inverse operation is selected, generates a tab separated file instead of the default CSV file when the input file is a VisionX vector format file. If the -i flag is not specified, this does nothing. This also does not alter data in VisionX table format files.

if=input file

The input file is either a text table as generated by excel using the csv or tab separated output option, or a VisionX table file.

of=

The of= parameter specifies the output file which is a set of feature vectors containing with an optional header, or a comma or tab separated file.

To convert from a csv or tab-separated file to a VisionX file with text table elements:

vexcel if=<csv or tsv file> -ft of=<VisionX file>

To invert the above operation (VisionX to csv or tab-separated file):

vexcel if=<VisionX file> -i of=<csv or tsv file>

A. P. Reeves and A. Jirapatnakul

vxltovf(1), vxlplot(1)