C# Interop Excel Question

[kav123]

I am using Excel Interop to read and write data from/to an Excel Spreadsheet. The first hurdle i have hit is, that i get "Cells were not found error", even though there is data in the spreadsheet.

I am using the following at the moment, as a test:

oRngLicenceNumbers = oSheet.UsedRange.get_Range("A1", "A6");

 

[PRPhx]

You should be using your best friend, GOOGLE, to search for help. Using these keywords: excel spreadsheet c# returns over 5.5 MILLION results. There are lots of samples.

You really didn't provide enough code to be helpful.

Good luck.

 

[kav123]

Ok, has anyone used get_offset method. Basically i need to get values from every alternate column in a row, till the end of the row i.e. where the data ends.

Please any help would be great