还有个小问题

yezhubenyue 2012-04-03 07:58:49
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;


namespace shangweiji
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
1: Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
2: Workbook wbook = app.Workbooks.Open("D:\\sun", Type.Missing);
3: Worksheet worksheet = (Worksheet)wbook.Worksheets[1];

worksheet.Cells[2,1] = "jiweiqiang";
app.Visible = true;
string temp = ((Range)worksheet.Cells[1, 2]).Text;

}

private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Workbook wbook = app.Workbooks.Open("D:\\sun", Type.Missing);
Worksheet worksheet = (Worksheet)wbook.Worksheets[1];
worksheet.Cells[9, 2] = "-20";
}


}
}

请问下1,2,3处的代码该放在什么地方,才能使定义的worksheet在每个事件应用程序下都能使用。现在我放在form_load下的话button_click是用不到的。
本来想放到form1()构造函数下的,可报错说不能引用非静态字段,属性和方法。
谢谢了
...全文
115 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
yezhubenyue 2012-04-03
  • 打赏
  • 举报
回复
[Quote=引用 1 楼 的回复:]
C# code



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.F……
[/Quote]
刚说错了,就是你说的这样,然后就报错,
错误 2 字段初始值无法引用非静态字段、方法或属性“shangweiji.Form1.app” D:\vs2010_profession\example\shangweiji\shangweiji\Form1.cs 17 26 shangweiji
错误 3 字段初始值无法引用非静态字段、方法或属性“shangweiji.Form1.wbook” D:\vs2010_profession\example\shangweiji\shangweiji\Form1.cs 18 42 shangweiji
ojekleen 2012-04-03
  • 打赏
  • 举报
回复


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;


namespace shangweiji
{
public partial class Form1 : Form
{
1: Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
2: Workbook wbook = app.Workbooks.Open("D:\\sun", Type.Missing);
3: Worksheet worksheet = (Worksheet)wbook.Worksheets[1];

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{

worksheet.Cells[2,1] = "jiweiqiang";
app.Visible = true;
string temp = ((Range)worksheet.Cells[1, 2]).Text;

}

private void button1_Click(object sender, EventArgs e)
{
worksheet.Cells[9, 2] = "-20";
}


}
}

111,126

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • Creator Browser
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧