R=255,G=0,B=0 for bright red background.Ĭomment: use this property to add, update, verify, or perform other operations on the Excel Comment associated with a particular cell.įont: set or verify the name of the font used for the cell, e.g. Special Technical Properties of Excel CellsĮxcel table cells have some special technical properties which you can use to automate some features in Microsoft Excel:īackgroundColor: set or verify background color using the format R=,G=,B=, e.g. You move the worksheet, so it's the second sheet in the Excel file. In this example, you perform the following actions for a worksheet named JAN_summary in the workbook MyWorkbook: The value last, a number greater than the total number of existing worksheets or a blank value to create the worksheet as the last sheet in the Excel file. The value first, 0, or a negative number to create the worksheet as the first sheet in the Excel file. For instance, enter 3 to create the worksheet as the third sheet in the Excel file. The new name you want to give to the worksheet.ĭefine where the Excel Engine 3.0 should move the worksheet to. Name of the worksheet that you want to update. The Module TBox Update Excel Worksheet allows you to update a worksheet in an existing Excel file. The range starts with cell A2 and ends with cell T982. You assign the name JanuarySales to the data range. This data range is located in the Excel sheet January. In this example, you define a data range in the workbook MyWorkbook. Start cell of the data range that you want to steer.Įnd cell of the data range that you want to steer. The Excel Engine 3.0 uses it to identify the data range you want to steer in other Excel Engine 3.0 TestSteps. Specify a name for the data range that you want to steer. This name must be an exact match for the worksheet within the workbook. Name of the Excel worksheet that contains the data. The Module has the following ModuleAttributes: This step is mandatory for every TestCase in which you want to manipulate a particular data range. The Module TBox Define Excel Range allows you to define a data range that you want to steer. Since the file is password protected, enter the password and then open the file in read-only mode. You assign the name MyWorkbook to the workbook that you want to steer. ![]() In this example, you open the Excel file sales_data.xlsx, located at C:\Temp. Specify whether you want to open the file in read-only mode. ![]() Optional password for password-protected workbooks. You can save the file later with the TBox Close Excel Workbook Module. The Excel Engine 3.0 creates the file in memory. You can use the following values:įalse: don't create a new file. Specify whether you want to create a new Excel file. The Excel Engine 3.0 uses it to identify the file you want to steer in other Excel Engine 3.0 TestSteps.įull path to the Excel file that you want to open, including the file name and extension. The Module TBox Open Excel Workbook has the following ModuleAttributes: You do not actually see the file opening in Excel. The Excel Engine 3.0 opens the file in the background. This step is mandatory for every Excel Engine 3.0 TestCase. Every workbook can contain several worksheets. The Module TBox Open Excel Workbook allows you to open an Excel file, i.e. The folder TBox XEngines ->Excel in the Standard subset contains Modules that perform specific tasks for the Excel Engine 3.0.
0 Comments
Leave a Reply. |