title: Pandas: Remove aggfun np.sum labels and value labels from pivot table
body: <p>I have created a pandas pivot table, and I am trying to remove the 'sum' and 'LENGTH' rows from the output xlsx.</p>
  
  <p>So far I have tried to remove the two rows upon exporting the pivot table to xlsx.
  I have tried to read in the exported pivot table and DataFrame.drop the two rows and re-export.</p>
  
  <p>I am not having much luck. Thanks all in advance!</p>
  
  <p>Link to pic:
  <a href="http://i.stack.imgur.com/AmjFy.png" rel="nofollow">http://i.stack.imgur.com/AmjFy.png</a></p>