lease Program in python and leave comments to help explain here is the google drive with the Test.xlsm file: https://drive.google.com/drive/folders/16utzb5_h7yMCN8_13E_JqasfcpykZOYr?usp=sharing The objective is to create a code in Python that can extract the columns highlighted in blue and output them to a .txt file. The code should be able to generate the text file with the columns that are highlighted in blue and store them on a seperate folder. Below shows how the Test.xlsm file looks like as well as how the text file should look like when the code extracts and outputs it. The attached images is how we want to format the text file when/after extracting the columns highlighted in blue. The code should name the output text file according to the sheet name
Please Program in python and leave comments to help explain
here is the google drive with the Test.xlsm file: https://drive.google.com/drive/folders/16utzb5_h7yMCN8_13E_JqasfcpykZOYr?usp=sharing
The objective is to create a code in Python that can extract the columns highlighted in blue and output them to a .txt file. The code should be able to generate the text file with the columns that are highlighted in blue and store them on a seperate folder. Below shows how the Test.xlsm file looks like as well as how the text file should look like when the code extracts and outputs it.
The attached images is how we want to format the text file when/after extracting the columns highlighted in blue. The code should name the output text file according to the sheet name " Correct-L.txt " and its header should contain " Band Group Number Time " just so we know where it begins or when the next column is.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images