在ARCO中打開Excel表格

出自 ArcoWiki
於 2018年6月14日 (四) 07:45 由 Slia (對話 | 貢獻) 所做的修訂 (创建页面,内容为“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 /> Opening…”)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
前往: 導覽搜尋

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