Home > Task Builder > Actions & Activities > Excel > Excel - Close workbook
|
Excel - Close workbook |
| <AMEXCEL ACTIVITY="close_workbook" SESSION="text" SAVETYPE="text (options)" DESTINATION="text" OVERWRITEDESTINATION="YES/NO" /> |
Closes the workbook previously opened or created by the Open/Create workbook activity and ends the associated session. Unless specified, any changes made to the document will be automatically saved when closed.
IMPORTANT: AutoMate's Excel activities use Microsoft's Excel automation engine to perform their work, therefore, Excel must be installed and licensed on the computer to ensure proper functionality. |
Mainly used to save and close an Excel document that was modified with prior AutoMate Excel steps and ends the associated session.
Property |
Type |
Required |
Default |
Markup |
Description |
Session Name |
Text |
Yes |
ExcelSess1 |
SESSION="ExcelSess7" |
The session name to identify which document should be closed from prior Excel steps. Numerous sessions can exist within a single task allowing several Excel documents to be open simultaneously. |
Do not save changes |
Yes/No |
No |
No |
RESULTDATASET="datasetname" |
If set to YES, the document should be closed but not saved. The default behavior is to save the document when it is closed. |
NOTE: The sample AML code below can be copied and pasted directly into the Steps panel of the Task Builder. |
This sample task demonstrates the use of various Excel actions. Below describes each step of the task, including the action used and details about that action.
Create Workbook Action - Create new Excel workbook "C:\Temp\sampledoc.xls". Overwrite file if it already exists.
Add Worksheet Action - Add new Excel worksheet "My New Sheet" to workbook open in session "ExcelSess1". New worksheet will be the last one of the workbook.
Activate Worksheet Action - Activate Excel worksheet "My New Sheet" in workbook open in session "ExcelSess1".
Set Cell Action - Write text "Set this data here" in Excel cell located at row:1 and column:1.
Pause Task Action - Pause task for 3 seconds.
Set Cell Action - Write text "and this here" in Excel cell located at row:2 and column:1.
Pause Task Action - Pause task for 3 seconds.
Close Workbook Action - Close Excel workbook. Do not save workbook before closing.
<AMEXCELCREATEWORKBOOK WORKBOOK="c:\sampledoc.xls" OVERWRITE="YES" /> <AMEXCELADDWORKSHEET WORKSHEETNAME="My New Sheet" LASTWORKSHEET="YES" /> <AMEXCELACTIVATEWORKSHEET WORKSHEET="My New Sheet" /> <AMEXCELSETCELL NEWVALUE="Set this data here" CELLROW="1" CELLCOLUMN="1" /> <AMPAUSE ACTION="waitfor" SCALAR="3" /> <AMEXCELSETCELL NEWVALUE="and this here" CELLROW="2" CELLCOLUMN="1" /> <AMPAUSE ACTION="waitfor" SCALAR="3" /> <AMEXCELCLOSEWORKBOOK SAVE="NO" /> |