Öffnen von Excel-Tabellen in ARCO

Aus ArcoWiki
Version vom 14. Juni 2018, 07:45 Uhr von Slia (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „It was introduced the ability to open, into ARCO, Excel sheets for output management.<br /> To use this feature you must have installed Excel package.<br /> Op…“)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche

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.
ReadMe image043.jpg

The Excel file can be displayed both in the interface of ARCO and in a floating Excel window.

ReadMe_image044.jpg

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:
ReadMe image045.jpg

Set the current sheet: ReadMe image046.jpg
Set the cell in which to write as an absolute position: ReadMe image047.jpg
Set the cell in which to write as a relative position: ReadMe image048.jpg
Set the auto-increment of the position: ReadMe image049.jpg
Save the file:
ReadMe image050.png

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:
ReadMe image051.jpg
Files can be saved at the end of execution:

ReadMe image052.jpg


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.
ReadMe image053.png