We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Why can't we use MS Excel itself to generate the reports?

Platform: WinForms |
Control: XlsIO |
Published Date: April 30, 2011 |
Last Revised Date: July 10, 2014

Why can't we use MS Excel itself to generate reports?

MS Excel was not designed to be a report generation library, so it has several disadvantages compared to XlsIO. Here is a list of some of the problems in using Excel as a reporting component

Microsoft, themselves do not recommend using Excel as a report generation server side component. The reasons are clearly explained in this Knowledge Base article from Microsoft.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2.


Here is a quote from the article "Microsoft does not currently recommend, and does not support automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when run in this environment."

Speed : Excel automation is several times slower than Essential XlsIO while generating reports.

Cost : Licensing XlsIO is much cheaper than MS Excel licensing options. Here is a link to a Knowlege Base article from Microsoft.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q243006#kb2

Usability : Essential XlsIO has a very intuitive object model that is modelled after the Excel object model which makes it very easy to work with. XlsIO also includes some additional helper functionalities like the ImportDataTable method which makes programming with XlsIO much easier than using COM Automation. Intellisense comments also make the job of programming with XlsIO much easier than Excel automation.

 

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon