How to convert the below lines from VB to C#

Question

eSHEET = CType (eBOOK.ActiveSheet,Microsoft.Office.Interop.Excel.Worksheet) eSHEET.Cells.Range(' A2' , 'v500' ).Copy() how to convert the above lines to c#.

Vulpes · Answer

Try: eSHEET = (Microsoft.Office.Interop.Excel.Worksheet)eBOOK.ActiveSheet; eSHEET.Cells.Range["A2", "v500"].Copy();

Dorababu Meka · Answer

Try this Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1); Microsoft.Office.Interop.Excel.Range rangeData = worksheet.get_Range ("A2", "v500" ).copy(your destination object); http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.range.copy(v=office.11).aspx

Gomathi Palaniswamy · Answer

i am using vs 2005.want to copy and paste excel.

Vulpes · Answer

If only it were always so easy, Jagan :)

Jaganathan Bantheswaran · Answer

Hi, Here you can convert the codes from VB to C#

Vulpes · Answer

OK, that would then be: eSHEET.Cells.get_Range("A2", "v500").Copy(Type.Missing); Incidentally, it would help with questions like this if you said what version of C# you are using.

Gomathi Palaniswamy · Answer

Error 1 Property, indexer, or event 'Range' is not supported by the language; try directly calling accessor method 'Microsoft.Office.Interop.Excel.Range.get_Range(object, object)'

Vulpes · Answer

The Copy() method takes an optional argument which, if omitted, copies to the clipboard. However, you can only omit it in C# if you're using v4.0 which I assume you're not. Try this instead: eSHEET.Cells.Range["A2", "v500"].Copy(Type.Missing);

Gomathi Palaniswamy · Answer

eSHEET.Cells.Range["A2", "v500"].Copy(); its not working fine.

How to convert the below lines from VB to C#

Answers (9)