title: Is there a way to export a dataframe of multiple column index without the row index?
body: <p>When saving a dataframe to csv or excel, pandas will automatically add a first column as row index. I know there's a <code>index=False</code> argument to avoid this. However, if my dataframe have multiple column index, the error shows:</p>
  <blockquote>
  <p>NotImplementedError: Writing to Excel with MultiIndex columns and no index ('index'=False) is not yet implemented.</p>
  </blockquote>
  <p>Is there another way to skip this first column while keeping the multi-level column name for the header rows inside the excel file?</p>
  <p>An example code to generate the dataframe:</p>
  <pre><code>import pandas as pd
  import numpy as np
  
  col = pd.MultiIndex.from_arrays([['one', 'one', 'one', 'two', 'two', 'two'],
                                  ['a', 'b', 'c', 'a', 'b', 'c']])
  data = pd.DataFrame(np.random.randn(4, 6), columns=col)
  data.to_excel('test.xlsx')
  </code></pre>
  <p>And open the excel file you'll see:
  <a href="https://i.stack.imgur.com/pWNJa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pWNJa.png" alt="enter image description here" /></a></p>
  <p>I would like to keep <code>B1:G2</code> as my column name structure and drop the <code>A:A</code> (and also <code>A3:G3</code>). Thank you for any help~.</p>