VSTO is Free But Aspose is Speed

I’ve taken over the completion, deployment, and maintenance of an ASP.NET Web site that generates Office documents using VSTO. VSTO’s a decent concept and works fine for small-scale scenarios like a desktop app or small intranet. However, with multiple simultaneous requests via ASP.NET, we found the Web server performance suffered badly.

To spread out the server’s workload, I implemented MSMQ task queuing via a WCF Windows service.  That helped a lot. IIS didn’t drag with only one VSTO/Office instance running. But I  still found it taking too long to produce a single report. A nicely formatted VSTO Excel document was taking 45 minutes.  (The client  didn’t know any better and therefore considered 45 minutes tolerable.)

On my own time, I pulled out an old copy of Aspose.Total for .NET. Within an hour, I had converted the VSTO Excel C# code to Aspose Cells code.

The improvement was astonishing: Instead of the 45-minutes, the report took under a minute! I’ve pasted the client’s exact chat response after he tried the speedy Aspose version:

“WWWWWOOOOOOOOWWWWWWWW!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!”

Microsoft’s VSTO is a free product while the Aspose components cost $$$.  Certainly, it can be a tough call when budgets are tight. If you’re trying to convince the client to shell out for something more suitable for the application, get an eval version of Aspose.Total and offer a direct comparison demo.

Ken

Full Disclosure: Aspose (like several other component vendors) gives free copies of their suite to MVPs and other .NET influencers.

Published Tuesday, May 29, 2012 10:15 PM by Ken Cox [MVP]
Filed under: , , , , ,

Comments

# re: VSTO is Free But Aspose is Speed

Tuesday, May 29, 2012 11:23 PM by Craig

Haven't used Cells but have used Aspose.Words to create Word documents server side and it is so much faster, lighter and more robust than using Word automation it's a must have.

# re: VSTO is Free But Aspose is Speed

Wednesday, May 30, 2012 2:07 PM by RichardD

+1 for EPPlus - it's free, open source, and it generates the files using the new 2007/2010 format.

For simple spreadsheets, I've also found that generating the SpreadsheetML by hand isn't too bad.

# re: VSTO is Free But Aspose is Speed

Thursday, May 31, 2012 1:23 PM by Sonu Kapoor

I agree with Ken. I have been using Aspose.cells for many years and find it as one of the best tools to use.

Leave a Comment

(required) 
(required) 
(optional)
(required)