Video lessons

  • 1

    Microsoft Excel automation activities

    • How to read the content of an Excel file?

    • How to write some data to an Excel file?

    • How to add a row to the end of the Excel file?

    • How to get the value of the range from an Excel file?

    • How to write the specified values to a specified range in an Excel file?

    • How to get the particular row value from an Excel file?

    • How to update the particular row value in an Excel file?

    • How to get the value of the specified cell from an Excel file?

    • How to update the content of the specified cell in an Excel file?

    • How to execute a .vbs-macro in the selected Excel file?
  • 2

    Check-up

    • Quick resume

    • Check your understanding