Uipath - Quis_Lesson9
Study online at https://quizlet.com/_i21aod
1. Write an empty string: 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?
2. Using the 'Select' method: What is the best approach to filter data from a data table based on a
condition?
3. It will create that file for you and write the data in it.: What happens if you try to use a
Write Range activity to a .xlsx file that does not exist?
4. Saves all data from the Data Table to a string variable.: What is the Output Data Table
activity used for?
5. For Each Row: In order to loop through all the rows of a data table, which activity should be used?
6. It will read the document successfully.: What happens if you use the Excel Read Range activity to
read a .xlsx file that is already opened?
7. Read Range: What activity can be used to read an entire sheet from a excel file?
8. Yes, but only for xlsx files: Can Excel related activities be used without having the Excel Application
installed?
9. The first row from the specified range is considered to be the column names-
: What happens if the AddHeaders option is checked for Read Range Activity?
10. It will overwrite the existing data.: What happens if you use the Write Range activity with the Range
property set to "" to write a datatable to an excel file that already contains data?
11. Lookup data table: What should you use if you want to get the value of a specific cell from a row in a
datatable?
12. Excel Append Range & Workbook Append Range: What activity should you use if you want
to add data to an existing .xlsx document without overwrite existing data?
1/1
Study online at https://quizlet.com/_i21aod
1. Write an empty string: 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?
2. Using the 'Select' method: What is the best approach to filter data from a data table based on a
condition?
3. It will create that file for you and write the data in it.: What happens if you try to use a
Write Range activity to a .xlsx file that does not exist?
4. Saves all data from the Data Table to a string variable.: What is the Output Data Table
activity used for?
5. For Each Row: In order to loop through all the rows of a data table, which activity should be used?
6. It will read the document successfully.: What happens if you use the Excel Read Range activity to
read a .xlsx file that is already opened?
7. Read Range: What activity can be used to read an entire sheet from a excel file?
8. Yes, but only for xlsx files: Can Excel related activities be used without having the Excel Application
installed?
9. The first row from the specified range is considered to be the column names-
: What happens if the AddHeaders option is checked for Read Range Activity?
10. It will overwrite the existing data.: What happens if you use the Write Range activity with the Range
property set to "" to write a datatable to an excel file that already contains data?
11. Lookup data table: What should you use if you want to get the value of a specific cell from a row in a
datatable?
12. Excel Append Range & Workbook Append Range: What activity should you use if you want
to add data to an existing .xlsx document without overwrite existing data?
1/1
