title: Extract gz and convert csv to xlsx
body: <p>I hope someone can help me with this issue. I tried to Google something that do what I need but there isn't any of specific or easy to adapt and I'm a dud with programming and coding...</p>
  
  <p>An application I use everyday produces several gz files containing one csv file each. With the aim to simplify a bit my life I wish run a script that do this work:</p>
  
  <ol>
  <li>Extract the csv files from any gz in the current folder </li>
  <li>Save any extracted csv  file as xlsx files in the same folder</li>
  <li>Rename the xlsx file properly</li>
  <li>Delete any gz and csv files from the current folder</li>
  </ol>
  
  <p>Here some more details about the environment and requirements:</p>
  
  <ul>
  <li>Running OS is Windows 7 Enterprise (Powershell is installed)</li>
  <li>Office 2010 is installed</li>
  <li>I can't install any additional software or library (it's a corporate laptop)</li>
  <li><p>Any csv file has the following naming convention:</p>
  
  <p><code>
  CheeseFile_YellowCheese_yyyy_mm_dd-randomnumber_othersnumber.csv
  CheeseFile_BlueCheese_yyyy_mm_dd-randomnumber_othersnumber.csv
  HamFile_RawHam_yyyy_mm_dd-randomnumber_othersnumber.csv
  HamFile_CookedHam_yyyy_mm_dd-randomnumber_othersnumber.csv</code></p></li>
  <li><p>And should be respectively saved as:</p>
  
  <p><code>
  OutputFile - CheeseFile_mmddyyyy_Yellow Cheese.xlsx
  OutputFile - CheeseFile_mmddyyyy_Blue Cheese.xlsx
  OutputFile - HamFile_mmddyyyy_Raw Ham.xlsx
  OutputFile - HamFile_mmddyyyy_Coocked Ham.xlsx</code></p></li>
  <li><p>The date in the original file name has to be kept in the output xlsx file</p></li>
  <li>Cheese files are in their folder and Ham files are in a separate folder so I can adapt the script as I need.</li>
  </ul>
  
  <p>Please let me know if you need further details and thank you in advance for any appreciated help :)</p>