title: Write to an excel file in HDFS using python
body: <p>Trying to write a dataframe to an excel workbook using Openpyxl on an HDFS using a zeppelin notebook.</p>
  
  <p>My code below - </p>
  
  <pre><code>with pd.ExcelWriter('hdfs:///ip/docs/excel_files/ds.xlsx', engine="openpyxl", mode="w") as writer:
      df.to_excel(writer, sheet_name='Sheet3') 
  </code></pre>
  
  <p>The Error -</p>
  
  <pre><code>Fail to execute line 2:      df.to_excel(writer, sheet_name='Sheet3')
  Traceback (most recent call last):
    File "/tmp/zeppelin_pyspark-8199079202247699001.py", line 380, in &lt;module&gt;
      exec(code, _zcUserQueryNameSpace)
    File "&lt;stdin&gt;", line 2, in &lt;module&gt;
    File "/opt/anaconda3/lib/python3.7/site-packages/pandas/io/excel.py", line 1191, in __exit__
      self.close()
    File "/opt/anaconda3/lib/python3.7/site-packages/pandas/io/excel.py", line 1195, in close
      return self.save()
    File "/opt/anaconda3/lib/python3.7/site-packages/pandas/io/excel.py", line 1228, in save
      return self.book.save(self.path)
    File "/opt/anaconda3/lib/python3.7/site-packages/openpyxl/workbook/workbook.py", line 396, in save
      save_workbook(self, filename)
    File "/opt/anaconda3/lib/python3.7/site-packages/openpyxl/writer/excel.py", line 292, in save_workbook
      archive = ZipFile(filename, 'w', ZIP_DEFLATED, allowZip64=True)
    File "/opt/anaconda3/lib/python3.7/zipfile.py", line 1204, in __init__
      self.fp = io.open(file, filemode)
  
  FileNotFoundError: [Errno 2] No such file or directory: 'hdfs:///ip/docs/excel_files/ds.xlsx'
  </code></pre>