PDF Read - Reads the data from an Excel Sheet

1. Choose File type either - Internal/External
2. 
3. For Internal, Choose Upload File from your local system
4. Key in the Sheet Name & Column Name of Excel
5. In the description box, you can give a short description for your reference
6. Click the Save button to save this event
7. For External, Choose Method either - SFTP/FTP and mention the IP Address & Port number of the external system from where you are going to access the file
8. Mention the Remote Path of the file & File Name
9. Choose Authentication Type from any of these - No Authentication/Username and Password/Username and Key
10. For Username and Password, key in the Username and Password
11. For Username and Key, key in the Username and Password and Private Key
12. In the description box, you can give a short description for your reference
13. Click the Save button to save this event
14. In Assign Value To, key in the Value

PDF Write

1. If the Artifact button is enabled, the file will be saved both locally & within the application
2. 
3. If the Time Stamp button is enabled, the file will be saved with the corresponding Date and Time
4. Choose File type either - Internal/External
5. For Internal, Choose Upload File from your local system
6. Key in the Sheet name of Excel where the data has to be written
7. Key in the path from where the data has to be fetched
8. In the description box, you can give a short description for your reference
9. Click the Save button to save this event
10. For External, Choose Method either - SFTP/FTP and mention the IP Address & Port number of the external system from where you are going to access the file
11. Mention the Remote Path of the file & File Name
12. Choose Authentication Type from any of these - No Authentication/Username and Password/Username and Key
13. For Username and Password, key in the Username and Password
14. For Username and Key, key in the Username and Password and Private Key
15. Key in the Sheet name of Excel where the data has to be written
16. Key in the path from where the data has to be fetched
17. In the description box, you can give a short description for your reference
18. Click the Save button to save this event

CSV Read - Reads the data from an Excel Sheet

1. Choose File type either - Internal/External
2. 
3. For Internal, Choose Upload File from your local system
4. Key in the Sheet Name & Column Name of Excel
5. In the description box, you can give a short description for your reference
6. Click the Save button to save this event
7. For External, Choose Method either - SFTP/FTP and mention the IP Address & Port number of the external system from where you are going to access the file
8. Mention the Remote Path of the file & File Name
9. Choose Authentication Type from any of these - No Authentication/Username and Password/Username and Key
10. For Username and Password, key in the Username and Password
11. For Username and Key, key in the Username and Password and Private Key
12. In the description box, you can give a short description for your reference
13. Click the Save button to save this event
14. In Assign Value To, key in the Value

CSV Write - Writes the data into an Excel Sheet

1. If the Artifact button is enabled, the file will be saved both locally & within the application
2. 
3. If the Time Stamp button is enabled, the file will be saved with the corresponding Date and Time
4. Choose File type either - Internal/External
5. For Internal, Choose Upload File from your local system
6. Key in the Sheet name of Excel where the data has to be written
7. Key in the path from where the data has to be fetched
8. In the description box, you can give a short description for your reference
9. Click the Save button to save this event
10. For External, Choose Method either - SFTP/FTP and mention the IP Address & Port number of the external system from where you are going to access the file
11. Mention the Remote Path of the file & File Name
12. Choose Authentication Type from any of these - No Authentication/Username and Password/Username and Key
13. For Username and Password, key in the Username and Password
14. For Username and Key, key in the Username and Password and Private Key
15. Key in the Sheet name of Excel where the data has to be written
16. Key in the path from where the data has to be fetched
17. In the description box, you can give a short description for your reference
18. Click the Save button to save this event

Excel Read - Reads the data from an Excel Sheet

1. Choose File type either - Internal/External
2. 
3. For Internal, Choose Upload File from your local system
4. Key in the Sheet Name & Column Name of Excel
5. In the description box, you can give a short description for your reference
6. Click the Save button to save this event
7. For External, Choose Method either - SFTP/FTP and mention the IP Address & Port number of the external system from where you are going to access the file
8. Mention the Remote Path of the file & File Name
9. Choose Authentication Type from any of these - No Authentication/Username and Password/Username and Key
10. For Username and Password, key in the Username and Password
11. For Username and Key, key in the Username and Password and Private Key
12. In the description box, you can give a short description for your reference
13. Click the Save button to save this event
14. In Assign Value To, key in the Value

Excel Write - Writes the data into an Excel Sheet

1. If the Artifact button is enabled, the file will be saved both locally & within the application
2. 
3. If the Time Stamp button is enabled, the file will be saved with the corresponding Date and Time
4. Choose File type either - Internal/External
5. For Internal, Choose Upload File from your local system
6. Key in the Sheet name of Excel where the data has to be written
7. Key in the path from where the data has to be fetched
8. In the description box, you can give a short description for your reference
9. Click the Save button to save this event
10. For External, Choose Method either - SFTP/FTP and mention the IP Address & Port number of the external system from where you are going to access the file
11. Mention the Remote Path of the file & File Name
12. Choose Authentication Type from any of these - No Authentication/Username and Password/Username and Key
13. For Username and Password, key in the Username and Password
14. For Username and Key, key in the Username and Password and Private Key
15. Key in the Sheet name of Excel where the data has to be written
16. Key in the path from where the data has to be fetched
17. In the description box, you can give a short description for your reference
18. Click the Save button to save this event

Text Read - Reads the data from an Excel Sheet

1. Choose File type either - Internal/External
2. 
3. For Internal, Choose Upload File from your local system
4. Key in the Sheet Name & Column Name of Excel
5. In the description box, you can give a short description for your reference
6. Click the Save button to save this event
7. For External, Choose Method either - SFTP/FTP and mention the IP Address & Port number of the external system from where you are going to access the file
8. Mention the Remote Path of the file & File Name
9. Choose Authentication Type from any of these - No Authentication/Username and Password/Username and Key
10. For Username and Password, key in the Username and Password
11. For Username and Key, key in the Username and Password and Private Key
12. In the description box, you can give a short description for your reference
13. Click the Save button to save this event
14. In Assign Value To, key in the Value

Text Write - Writes the data into an Excel Sheet

1. If the Artifact button is enabled, the file will be saved both locally & within the application
2. 
3. If the Time Stamp button is enabled, the file will be saved with the corresponding Date and Time
4. Choose File type either - Internal/External
5. For Internal, Choose Upload File from your local system
6. Key in the Sheet name of Excel where the data has to be written
7. Key in the path from where the data has to be fetched
8. In the description box, you can give a short description for your reference
9. Click the Save button to save this event
10. For External, Choose Method either - SFTP/FTP and mention the IP Address & Port number of the external system from where you are going to access the file
11. Mention the Remote Path of the file & File Name
12. Choose Authentication Type from any of these - No Authentication/Username and Password/Username and Key
13. For Username and Password, key in the Username and Password
14. For Username and Key, key in the Username and Password and Private Key
15. Key in the Sheet name of Excel where the data has to be written
16. Key in the path from where the data has to be fetched
17. In the description box, you can give a short description for your reference
18. Click the Save button to save this event