2
shouts

Reading excel spread sheet as strongly typed objects « Shashank’s Blog

posted by http://shashankshetty.wordpress.com/http://shashankshetty.wordpress.com/ 311 days, 21 hours, 21 minutes ago
Monday, May 11, 2009 9:48:39 PM GMT

Recently, I was working on a prototype application that required data to be read from many different Excel spreadsheets (both xls and xlsx versions) each containing a large number of worksheets.  I started with the usual way of creating one DTO (Data Transfer Object) for each worksheet and then pulling the data from Excel through OleDBReader. It became repetitive to do the same thing over and over for every single worksheet. After quick thought, I decided to write a simple tool that can solve this proble...

category: Architecture | clicked: 8 | | source: shashankshetty.wordpress.com | show counter code
tags: ASP.NET, C#, Excel

No comments yet, be the first one to post comment.

To post your comment please login or signup