Monday, September 20, 2010

Excel Automation

Excel automation is unavoidable scenario in most of the Enterprise IT solution. Primarily the automation targets following area

  1. Pivot Report Generation
  2. Complex formula abstraction
  3. Report Attachment
  4. Data Transfer medium

In addition to typical Interop Assembly usage, we can take advantage of Open XML APIs. In addition to that there are lot of third party tools available to address the same. In this blog will keep adding the relevant tools and techniques of Excel Automation.

Note: If you are using SSIS, there is good amount challenge. Check out Dougbert blog for solutions.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Engineering Excellence

Engineering Excellence Having solid engineering process and tools in place help to improve the agility of the system. Here is the high-level...

  • SSIS Script Component
    In SQL Server Integration services, we have Script Component, which can be used in Data Flow Task as Source, Destination or Transformation. ...
  • Windows Restart
    I was trying to install SharePoint 2013, the setup was complaining about a pending system restart.  Even after multiple restart / Shutdown. ...
  • C# Virtual & Abstract Properties
    Recently a new learner of C# asked me a question on C# Virtual & Abstract properties.  It turned out to a deep dive.  Detail follows. D...