Page 1 of 1
CSV File
Posted: 12 Nov 2012, 17:59
by cdorai
Hello,
Is it possible to read data from a CSV file on Ventuz?
I know it is possible to read data in a table XLS.
can you help me?
thank you
cordially
Re: CSV File
Posted: 12 Nov 2012, 20:48
by joysprod
A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.
My solution would be to read into an XL spreadsheet and use the various Excel nodes in Ventuz to get to your data using the following..
Excel Workbook: This node provides access to the Microsoft Excel files.
Excel Cell (Row,Column): This node reads Excel cell data specified by a row and column index.
Excel Cell (Name): This node reads Excel cell data specified by the cell name.
Excel Range Array: This node reads a range of cells containing numbers and provides them as a float array.
Excel Custom Range: This node reads a range of cells and fills a user defined data structure.
Regards
Peter