Missing Office.Interop.Excel Reference

Question

Hy Gurus!

I hope i am writing in the right place.  I would like to use the Microsoft.Office.Interop.Excel to read and write Excel files, but (maybe i am the lame) i just found some little examples. I need the full reference of this namespace. What i found is http://msdn.microsoft.com/en-us/library/ms262200(v=Office.11).aspx, wich doesn't contain useful things for me. Is there any other full reference of this namespace?

Answer 1

Hi,

 

I think in the above code, the for loop will skip first row. Try giving value of "i" in for loop as -1;

 

for (int i = -1; i < dataGridView2.Rows.Count - 1; i++)

{

Answer 2

Midhun T P

Got it, thank you very much!

Answer 3

Nilesh Sawardekar

 

Good suggestion but not working. Changed to 2 my header gone, change to 0 it throw an error (Exception on HRESULT: 0x800A03EC). Any other suggestion?

Answer 4

int cellRowIndex = 1;

 

change value of it and check.