Abrindo Folhas do Excel no ARCO
It was introduced the ability to open, into ARCO, Excel sheets for output management.
To use this feature you must have installed Excel package.
Opening the files is through the panel "Input/Output -> Extended", choosing the file and setting the report format "EXCEL"; it is important to select the file in mode APPEND or OVERWRITE.
The Excel file can be displayed both in the interface of ARCO and in a floating Excel window.
In both cases you see a Toolbar dedicated to Excel functionality that allows you to create instructions for management of the writing on Excel file.
The interaction with Excel allows:
Set the current sheet:
Set the cell in which to write as an absolute position:
Set the cell in which to write as a relative position:
Set the auto-increment of the position:
Save the file:
The items are sent to the Excel sheet with the instructions of standard ouput.
If it required to send to the file only measured data, ARCO allows the creation, from the DB Viewer, specific instructions for the selection of the attributes:
Files can be saved at the end of execution:
To decide if Excel is opened from within the ARCO interface or on a floating sheet (useful in case of dual monitor), it is possible to make the selection from the control panel.