求助：vba代码改成c＃不起作用

[咚咚锵]

想实现选中当前表的所有单元格，然后复制所有的单元格

vba代码如下：
Sub Macro1()
Cells.Select
Range("C1").Activate
Selection.Copy
End Sub
相应的c＃代码该怎么写呢？

或者vb。net代码也可以

为什么改成下边的不行

private Excel.ApplicationClass eapp;
private Excel.Workbook book;
Excel.Worksheet ws;
object mis=System.Reflection.Missing.Value;
。。。省略部分
ws=(Excel.Worksheet)this.book.Worksheets.get_Item(sheet);
this.eapp.CutCopyMode=Excel.XlCutCopyMode.xlCopy;
ws.Cells.Select();
// ws.Cells.Activate();
// ws.Cells.Copy(mis);
Excel.Range r=(Excel.Range)this.eapp.Selection;
r.Copy(mis);

[jackyped]

Excel.Application app = new Excel.Application();
app.Visible = true;
app.UserControl = true;

Workbooks workbooks = app.Workbooks;

//_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
_Workbook workbook = workbooks.Add(System.Windows.Forms.Application.StartupPath+"\\a.xls");

Sheets sheets = workbook.Worksheets;
_Worksheet worksheet = (_Worksheet)sheets.get_Item(1);

Range range1 = worksheet.get_Range("A1","c1");
range1.Copy(Type.Missing);


没问题啊

[咚咚锵]

注意是选中当前表的所有单元格，具有哪些单元格是不定的

[咚咚锵]

顶

[咚咚锵]

继续顶