Hi Experts,
Very new to python specially excel automation. Please suggest
I ve an excel template having a header and a sample data. Now depending on the hostname
input it should create a new row(next to sample data row) containing the same sample data along with the updated hostname. In the below example it Column B(abcd1234) and Column C(UXT_abcd1234) only update the hostname and the rest data should be as it is. Once it is created delete the sample data row and send the email.
For Ex:
Input File:
Very new to python specially excel automation. Please suggest
I ve an excel template having a header and a sample data. Now depending on the hostname
input it should create a new row(next to sample data row) containing the same sample data along with the updated hostname. In the below example it Column B(abcd1234) and Column C(UXT_abcd1234) only update the hostname and the rest data should be as it is. Once it is created delete the sample data row and send the email.
For Ex:
Input File:
Output:Col A | Col B | Col C | Col D | Col E
--------------------------------------------------------------------------------------------
Request | Hostname |Acct Name | Account Owner | Domain name
Createhostgroup | xyz1234 |UXT_xyz1234 | x123456 | XYZ.com
Output File:Output:Col A | Col B | Col C | Col D | Col E
--------------------------------------------------------------------------------------------
Request | Hostname |Acct Name | Account Owner | Domain name
Createhostgroup | abcd1234 |UXT_abcd1234 | x123456 | XYZ.com