name the command option you will use when you need a title or heading to span multiple cells
Answers
Answer:
plz mark me as a brainliest
Explanation:
The Contains Header option enables you to configure the command parameters to include or exclude headers.
Overview
When using the Excel command to retrieve data from an Excel spreadsheet that has its first row defined as a heading, you need to specify the rows and columns in a manner that they take those headings into consideration.
Contains Headers in Excel operations
Contains Header allows you to retrieve/fetch data from the active spreadsheet that has its first row defined as a header. You can define the option in Open Spreadsheet for a particular session. It is applicable to Excel operations Get Cells, Set Cell, Go to Cell, Find/Replace and Delete Cell for that particular session.
Also, in cases where one or more columns of the target Excel spreadsheet change position due to any update (i.e. introducing new columns/deleting existing columns), the corresponding automation TaskBot / MetaBot Logic has to be updated to accommodate the change. Using 'Contains Header' you can enable the TaskBot / MetaBot Logic to automatically map re-positioned columns of the target Excel spreadsheet