Bug Fixes: Read Ranges activity was returning the full data range irrespective of the specified input range. 

For example, if there is data in the sheet starting from A1:F15 and if the input range is defined as A1:B14. All data from A1:F15 was returned. This is now fixed.

Additionally, when the input range was defined in lower case the activity did not work and this is also fixed now.

Read Workbook activity has been updated to return sheet names from password protected excel file.

Write Ranges activity was skipping rows and was not writing as per the specified input range.

For example, if we have data from A1:A15 and we use the write ranges with input range as A7. Then data in rows starting from A1 to A6 is skipped and returned. This is now fixed and all rows from A1 to A15 will be printed in the output sheet.

Bug in writing from data table because of missing support for generating dynamic ranges is now fixed so this error. The source contains no DataRows will not appear during execution.

Bug in Excel to Data table activity is fixed which was causing Specified argument was out of the range of valid values. Parameter name: Start cell Address must be less or equal to End cell address.

 

Excel Automation
5.1.0