Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


osirisja
2012-08-28T13:59:58Z
Hi Henrik

Further to my email. Had a thought about enhancing the Excel Get Cell task to allow importing of multiple records for both Excel files and text based delimited files.

1. Option to define whether files is an XLS or a CSV/Delimitted file
2. Option to use xls/csv header record fields as VC User Variables and exclude from Get Cells
3. Ability to set variable in 'Excel Count Rows' task and use the user variable in the END ROW field of the GET CELLS task (currently this is not possible as there is an Error converting value to chosen data type - i.e. STDOUT is CHAR, END ROW requires INT32 and there is no obvious way to convert them)

Cheers

Andy

Sponsor
Forum information
Scroll to Top