Server-side Office Integration -7 (Conclusion)

atmacam — Tue, 04 Nov 2008 04:28:00 GMT

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!.

Technorati Tags: Best Practices & Design,Office Integration,How to import excel spreadsheet into a database table,Data Application Block,Validation Block,System.IO.Packaging.

Mecit Atmaca : WCF

Server-side Office Integration -7 (Conclusion)