Many a times there is a need to import data from Excel files into a database or even just generally parse the Excel data into a typed collection in memory that can then be used for various purposes. I have written a Silverlight control that converts raw Excel text data and converts it into a […]

I came across this rather cool hack sometime ago but only now did i finally get a chance to blog about it. When you are dumped with massive Excel files which contain lots of business data that users send with an alarm that they want to “upload” this data into the databases, you are kinda […]

While working on one of the change requests for one of our web products, I came across a very peculiar issue with importing Excel data into the system. The usual way of uploading data from Excel spreadsheets is that you browse to the folder where the Excel file is located, select it then click some […]