Excel automation is unavoidable scenario in most of the Enterprise IT solution. Primarily the automation targets following area
- Pivot Report Generation
- Complex formula abstraction
- Report Attachment
- 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.
No comments:
Post a Comment