How to convert the below lines from VB to C#

Gomathi Palaniswamy

eSHEET = CType(eBOOK.ActiveSheet,Microsoft.Office.Interop.Excel.Worksheet)

eSHEET.Cells.Range("A2", "v500").Copy()

how to convert the above lines to c#.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka14y ago
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 Palaniswamy14y ago
i am using vs 2005.want to copy and paste excel.
Vulpes14y ago
If only it were always so easy, Jagan :)
Jaganathan Bantheswaran14y ago
Hi,

Here you can convert the codes from VB to C#
Vulpes14y ago
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 Palaniswamy14y ago
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)'
Vulpes14y ago
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 Palaniswamy14y ago
eSHEET.Cells.Range["A2", "v500"].Copy(); its not working fine.
Vulpes14y ago
Try:

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