Server-side Office Integration -7 (Conclusion)
Voow, I am almost done. On this Sunday night, at Panera, I have enjoyed writing while listening to the jazz and drinking coups of tea (3, so far).
Alright, let's summarize briefly what we have done so far in these series: After giving some intro, In this complete but simple web application, we import data from an excel spreadsheet uploaded by the user into a database table by leveraging .NET 3.5 framework and ExcelPackage with C#.
Plus, we expose to some other areas of application development:
- Best practices and Enterprise Library (used Data and Logging Blocks). Later on, I will deep into more details hopefully
- Object serialization and de-serializaition
- File operations using System.IO namespace (FileInfo, Stream/FileStream)
- Resource releases/disposal once it is done by using 'using' blocks
- XML Document
- Use of XPATH for accessing XML content.
- Use XML Document as way of importing data (like a Batch process)
- T-SQL Script for reading data from an XML Document
- Rendering data as an Office document
- Use of Data Controls.
I will also publish the solution. Please note that this is just a sample application, I have used very simple development architecture (UI and Business), it is not optimized nor tested well.
I think I am done. Bye for now & All the Best!.