Question: What activity can you use to read an entire sheet from an entire excel file?

  •   Get Value
  •   Read Cell
  •   Read Range
  •   Writeln

Answer

Option C is correct.

The read range will get the entire excel file if the range extends to all the excel file. If the range is left blank then by default it will get the entire workbook regardless of how many spreadsheets there are within the workbook.

Typically this is hard to work with and unwieldy when it comes to practical use. You have to ensure the data is all the same for all sheets since it will all get put into a DataTable variable. It is always better to read in either one datasheet at a time or use the Get Workbook sheets activity and run them through a for each loop.

More details can be found on the official site. You can also follow the example they have here.

For completeness, Option A does not exist as an activity. Option B, Read Cell activity reads the specified cell and Option D is used to write a line to the output panel, it does not touch the spreadsheet.