Information on Excel and InteropServices?

could provide me useful links or information regarding excel , interopservices?

i have little application reads in excel file datagrid, it's kind of hacked together.

what i'm hoping able get, how many rows have values in column on sheet 1. seems simple enough, having lot of trouble finding information on working dynamic type, , automationfactory.createobject("excel.application") in general.

any information helpful, if point me toward how pull count column sheet 1!

thanks!

- dan

hi, 

you can in way 

                    dynamic sheet = workbook.sheets[sheetno];                     dynamic range = sheet.usedrange;                     int rows = range.rows.count;                     int columns = range.columns.count; 

agreed, not easy work excel through dynamic. therefore have project, i've imported excel typelibrary , can spy object model.

hope helps.

regards, greg

Silverlight  >  Getting Started with Silverlight