This activity includes the four options below that can format an Excel document:<ol><li>Print Area - Specifies the range of print area for all of target sheets. eg. A1:L10</li><li>Selected Cell - Specifies the range of cells to be selected in all of target sheets. eg. A1</li><li>Selected Sheet Number - Specifies the number of sheet to be selected when the document be next opened. eg. 1,2,3</li><li>Zoom - Specifies the number between 10 and 400 as a percentage to be zoomed in all of target sheets. eg. 70,85,100</li></ol>If an option value is empty or unreasonable, it will be ignored.Sheet filter input can limit target sheets. eg. Sheet1All the options are available only for the displayed sheets, so if the sheet number is 2, the second displayed sheet will be selected.

This activity enables you to format cells, areas or sheets in an Excel document

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

RPA Program Manager

Hy :) sorry but I dont understand what this activity is for, could you be more explicit ? regards

Hi Siyang Wu i am trying to install Format Excel Document  activity  but  i am getting this error Cannot load assembly: C:\Users\username\.nuget\packages\microsoft.office.interop.excel/15.0.4795.1000\lib/net20/Microsoft.Office.Interop.Excel.dll : System.IO.FileNotFoundException: Could not load file or assembly 'office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

Format Excel Document

Format Excel Document

Help

How To