Lesson 9 - Excel & Data Tables
How do you specify the Excel file to read from, in a Read Cell activity?
- In the WorkbookPath property, provide the full path of the workbook. - In the WorkbookPath property, provide a relative path, if the workbook is in the project folder.
What activity should you use if you want to add data to an existing .xlsx document?
- Workbook Append Range - Excel Append Range
If you need to sort a table from an .xlsx file, what should you use?
An Excel Sort data table activity.
You have an Excel table with two columns named "PersonName" and "Age". What happens if you use the activity Insert Column with the Column Name property set to "Age"?
An exception is thrown.
What activity should you use to read all the data from a .xlsx file?
Excel Read Range
What activity you should use if you want to calculate a sum into a cell using Excel formulas?
Excel Write Cell
In order to loop through all the rows of a datatable , which activity should be used?
For Each Row
What activity can you use to create a DataTable from an input string?
Generate Data Table
What happens if you try to use a Write Range activity to a . xlsx file that does not exist?
It will create that file for you and write the data in it.
What happens if you use the Write Range activity with the Range property set to "" to write a database to an excel file that already contains data?
It will overwrite the existing data.
What happens if you use the Excel Read Range activity to read a .xlsx file that is already opened?
It will read the document successfully.
What activity can you use to create a DataTable from an input string?
Output Data Table
What should you use if you want to get the value of a specific cell from a row in a datatable?
Output Data Table (maybe)
What activity can be used to read an entire sheet from a excel file?
Read Range
What happens if you use a Read Range activity with the Range property set to "" (an empty string)?
Reads all the information from the specified sheet
What is the Output Data Table activity used for?
Saves all data from the Data Table to a string variable.
What happens if the AddHeaders option is checked for Read Range activity?
The first row form the specified range is considered to be the column names
What is the best approach to filter data from a data table based on a condition?
Using the 'Select' method.
You need to read from an Excel sheet and you don't know the range. What do you write in the "Range" property of the Read Range Activity?
Write an empty string
Can Excel related activities be used without having the Excel Application installed?
Yes but only for xlsx files