Excel Automation using Openpyxl

[pradyumnajpn]

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:

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

[Larz60+]

what have you tried so far?
Please show code working or not.