title: Create an excel file using xlsxwriter and save the excel file into PDF
body: <p>I manage to create many excel files by extracting the relevant data from MySQL tables and populating these data into Excel using Xlsxwriter. The number of created Excel files may exceed 100s at the point of data generation, and I need each excel file to be converted into PDF before I email out the files. </p>
  
  <p>Manually converting each Excel file takes a few minutes, but just imagine doing for hundreds of files. I want to avoid using com32 or comtypes, and just through Xlsxwriter or VBA to get the conversion done. I have written some codes for Xlsxwriter, but somehow, this didn't work. Can someone advise, please. Thanks. </p>
  
  <pre><code>VBA_worksheet=current_workbook.add_worksheet()
  current_workbook.add_vba_project('printPDF')
  VBA_worksheet.write_formula('A1', 'ThisWorkbook.ExportAsFixedFormat Type:=xlTypePDF')
  VBA_worksheet.activate()
  VBA_worksheet.hide()
  </code></pre>