title: Without first parsing, convert Excel file to Json string
body: <p>Okay, this is different than other posts I'm seeing.  I'm not trying to first open an Excel file and parse the contents into a Json object.  I'm trying to take the file and convert it to a stream object of some sort or byte[] and then convert that to Json so I can use it as an input parameter to a POST method for a WebAPI.</p>
  
  <p>Here is the full scenario.</p>
  
  <p>I have clients that will use an internal-only website to select one or more Excel files.  The workstations the users work on may or may not have Excel installed, thus, all of my Excel processing has to be done on the server.  Once the Excel files are processed, they are combined into a System.Data.DataTable and the values are aggregated into one master report.  This aggregated report needs to be returned to the client system so it can be saved.</p>
  
  <p>I currently have this site working just fine in ASP.NET using C#.  However, I need the "guts" of the website to be a WebAPI so that automation programs I have can make calls directly to the WebAPI and accomplish the same task that the internal-only website does.  This will allow all processing for this sort of task to run through one code base (right now, there are about 4 versions of this task and they all behave differently, providing differing output).</p>
  
  <p>The way I thought to do this was to, from the client, convert the Excel files to an array of System.IO.MemoryStream objects, then serialize the full array as a Json.NET stream and upload the stream to the webserver where it will be deserialized back into an array of MemoryStream.  Once that is done, I can iterate the array and process each Excel file by the MemoryStream.</p>
  
  <p>My problem is I can't figure out how to convert the MemoryStream[] into Json and then deserialize that up on the server.</p>