private void button5_Click(object sender, EventArgs e)
{
string strFile_jisuancanshu = "";
OpenFileDialog ofd = new OpenFileDialog();
ofd.InitialDirectory = "D:\\开题\\shuju";
//ofd.Filter = "Excel文件(*.xls;*.xlsx)|*.xls;*.xlsx|所有文件|*.*";
ofd.ValidateNames = true;
ofd.CheckPathExists = true;
ofd.CheckFileExists = true;
//strFileA_xishu = "D:\\开题\\shuju\\20120712_20m+\\1000\\2012-07-12-10_56_36.txt ";
if (ofd.ShowDialog() != DialogResult.OK)
{
MessageBox.Show("请选择数据文件");
// return;
}
strFile_jisuancanshu = ofd.FileName;
ps5000example.ExcelHelp excelhelp = new ExcelHelp();
//MessageBox.Show("您当前选择数据为" + strFileName8.ToString());
Jisuancanshu = excelhelp.LoadDataFromExcel(strFile_jisuancanshu);
JisuancanshuFor_1_3 = excelhelp.LoadDataFromExcel_sheel2(strFile_jisuancanshu);
if (Jisuancanshu != null && JisuancanshuFor_1_3 != null)
{
MessageBox.Show("读取数据成功");
}
}
private void button1_Click(object sender, EventArgs e)
{
string strFileName8 = "";
OpenFileDialog ofd = new OpenFileDialog();
ofd.InitialDirectory = "D:\\开题\\shuju";
//ofd.Filter = "Excel文件(*.xls;*.xlsx)|*.xls;*.xlsx|所有文件|*.*";
ofd.ValidateNames = true;
ofd.CheckPathExists = true;
ofd.CheckFileExists = true;
//strFileName8 = "D:\\开题\\shuju\\20120712_20m+\\1000\\2012-07-12-10_56_36.txt ";
if (ofd.ShowDialog() != DialogResult.OK)
{
MessageBox.Show("请选择数据文件");
// return;
}
strFileName8 = ofd.FileName;
ps5000example.ExcelHelp excelhelp = new ExcelHelp();
//MessageBox.Show("您当前选择数据为" + strFileName8.ToString());
dt_for_cal = excelhelp.LoadDataFromExcel(strFileName8);
if (dt_for_cal != null)
{
if (dataGridView1.DataSource != null)
{
DataTable dt = (DataTable)dataGridView1.DataSource;
dt.Rows.Clear();
dataGridView1.DataSource = dt;
}
else
{
dataGridView1.Rows.Clear();
}
data_fresh();
}
else
{
MessageBox.Show("读取数据失败");
}
}
private void button4_Click(object sender, EventArgs e)
{
string strFileA_xishu = "";
OpenFileDialog ofd = new OpenFileDialog();
ofd.InitialDirectory = "D:\\开题\\shuju";
//ofd.Filter = "Excel文件(*.xls;*.xlsx)|*.xls;*.xlsx|所有文件|*.*";
ofd.ValidateNames = true;
ofd.CheckPathExists = true;
ofd.CheckFileExists = true;
//strFileA_xishu = "D:\\开题\\shuju\\20120712_20m+\\1000\\2012-07-12-10_56_36.txt ";
if (ofd.ShowDialog() != DialogResult.OK)
{
MessageBox.Show("请选择数据文件");
// return;
}
strFileA_xishu = ofd.FileName;
ps5000example.ExcelHelp excelhelp = new ExcelHelp();
//MessageBox.Show("您当前选择数据为" + strFileName8.ToString());
A_xishu = excelhelp.LoadDataFromExcel(strFileA_xishu);
try
{
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[3].HeaderCell.Value = "A加权系数";
for (int i = 0; i < 31; i++)
{
this.dataGridView1.Rows[i].Cells[3].Value = A_xishu.Rows[i][1].ToString();
}
this.dataGridView1.Columns[0].FillWeight = 60;
this.dataGridView1.Columns[1].FillWeight = 60;
MessageBox.Show("读取数据成功");
}catch
{
MessageBox.Show("读取数据失败");
}
}