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.
Unfortunately, activation email could not send to your email. Please try again.

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

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.

 

Article ID: Published Date: Last Revised Date: Platform: Control:
1944 04/30/2011 07/10/2014 Windows Forms XlsIO
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.