How to convert the below lines from VB to C#

Question

eSHEET = CType (eBOOK.ActiveSheetMicrosoft.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.