title: Using VB.NET to create a Pivot Table on an Exported Document
body: <p>I have a pipe-delimited text file that I need to read, turn into a pre-formatted Excel document - complete with separate pivot table sheet - and save.</p>
  
  <p>Reading the file and saving it as an Excel document are solved, but I can't seem to get the pivot table to work.  I've found a variety of tutorials online, but none are actually working for me.</p>