In my current project I have requirement to upload an excel file, parse it and send the data to a third party system. I have no need to persist the file either in SharePoint or on disk and I don't need to keep the data in SharePoint since it's immediately sent the the 3rd party system. Since the site is hosted in SharePoint I'd like to take advantage of whatever I can from it.
Using a third party component like Aspose.Cells I can do most of that in a few lines of code but I'd rather not introduce another dependency or go through the licensing hassle. Is there a (easy) way I can do this with Excel services? I've looked at the SOAP and REST APIs and nothing really jumps out at me other than dropping the file somewhere, upload it, access it via the API, and then delete the file and destroy the old data in SP. Is there a way to handle a stream of an Excel file directly or handle a file without persisting it?
Any suggestions welcome,