Demo Project using Excel Activities (Part 1)

The URL of the demo project is given below where users can learn about these activities in a better manner. 

Steps:

1. Create a test Excel file on the desktop. 
2. Open the website – ‘https://crypto.com/price/‘ which consists of different cryptocurrencies and their details in a table format. 
3. Extract the table from the website using the “Extract Data Table” activity and assign it to a variable of DataTable type. 
4. Open the previously created Excel file using the “Open Excel Application” activity. 
5. Create a new sheet in the Excel file using the “Set Active Sheet” activity. 
6. Write the extracted DataTable to the Excel file using the “Write Range” activity. 
7. Write a value to a specific cell in the Excel file. 
8. Remove the data from the Excel file using the “Delete Range” activity.