Lesson 9 - Excel & Data Tables

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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


Kaugnay na mga set ng pag-aaral

Chapter 6: Values, Ethics, and Advocacy

View Set

Chapter 6: Childhood Communicable and Infectious Diseases

View Set

TXQTKD01- Quản trị chiến lược-one43

View Set

Mark Twain Information for the Huck Finn Test

View Set

Chapter Quiz: Health & Accident Insurance Regulation

View Set