Jun-10-2018, 01:17 AM
(Jun-09-2018, 08:56 PM)ljmetzger Wrote: Your code worked OK as is. I tested the code on Windows 10 with Python 3.6.5
NOTES:
a. Constants should be all CAPS (e.g. SKEL)
b. There should be a space after the '#' in comments
c. All 'import' statements should be at the top of the file
d. Create the 'SubFolder' if necessary
e. Create a function that reads and processes the Excel File (replaces original code)
f. Process all .xlsx files (CASE INSENSITIVE) in the Data Folder
g.if __name__ == '__main__':
Every module in python has a special attribute called __name__ . The value of the __name__ attribute is set to '__main__' when a module is run as the main program. Otherwise the value of __name__ is set to contain the name of the module.
Thank you! Lewis! The code works well!!! I will keep your notes in mind as I continue to learn how to code in Python!