Opening Excel Sheets in ARCO - Revision history

Admin: The LinkTitles extension automatically added links to existing pages (https://github.com/bovender/LinkTitles).

2021-02-12T09:43:09Z

The LinkTitles extension automatically added links to existing pages (<a rel="nofollow" class="external free" href="https://github.com/bovender/LinkTitles">https://github.com/bovender/LinkTitles</a>).

Slia at 07:44, 14 June 2018

2018-06-14T07:44:48Z

Admin: 1 revision imported

2017-10-24T17:15:28Z

1 revision imported

Admin: Created page with "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..."

2016-09-10T18:32:38Z

Created page with "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..."

New page

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. 
[[File:ReadMe_image043.jpg]] 

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

[[File:ReadMe_image044.jpg|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: 
[[File:ReadMe_image045.jpg]]

Set the current sheet: [[File:ReadMe_image046.jpg]] 
Set the cell in which to write as an absolute position: [[File:ReadMe_image047.jpg]] 
Set the cell in which to write as a relative position: [[File:ReadMe_image048.jpg]] 
Set the auto-increment of the position: [[File:ReadMe_image049.jpg]] 
Save the file: [[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: 
[[File:ReadMe_image051.jpg]] 
Files can be saved at the end of execution: 

[[File: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. 
[[File:ReadMe_image053.png]]

[[Category:ReadMe3.5.100]]

← Older revision		Revision as of 09:43, 12 February 2021
Line 26:		Line 26:


−	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.<br />	+	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\|control panel]].<br />
	[[File:ReadMe_image053.png]]		[[File:ReadMe_image053.png]]

@@ Line 28: / Line 28: @@
 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.<br />
 [[File:ReadMe_image053.png]]
 [[Category:ReadMe3.5.100]]

← Older revision	Revision as of 17:15, 24 October 2017
(No difference)

Opening Excel Sheets in ARCO - Revision history

Admin: The LinkTitles extension automatically added links to existing pages (https://github.com/bovender/LinkTitles).

Slia at 07:44, 14 June 2018

Admin: 1 revision imported

Admin: Created page with "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..."

Admin: Created page with "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..."