Excel – Artineering

By Aman Agrawal Apr 7, 2014Dec 26, 2016

A Silverlight control to parse Excel data into a flat collection

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 … Continue reading A Silverlight control to parse Excel data into a flat collection

By Aman Agrawal Jan 7, 2012Jan 7, 2012

Using MS Excel to Generate Mass SQL Statements for Data Insertion

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 … Continue reading Using MS Excel to Generate Mass SQL Statements for Data Insertion

By Aman Agrawal Aug 30, 2011Dec 26, 2016

Excel Doesn’t Always Excel

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 … Continue reading Excel Doesn’t Always Excel