private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.Title = "请选择数据文件";
fileDialog.Filter = "*.xlsx|*.xlsx";
//fileDialog.CheckFileExists = false;
if (fileDialog.ShowDialog() == DialogResult.OK)
{
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;//鼠标为忙碌状态
textBox3.Text = fileDialog.FileName;
textBox1.Text = "正在读取EXCEL数据...";
EXCELHelper2 excelRead = new EXCELHelper2();
string s = excelRead.excelRead(@textBox3.Text);
string[] sArray = s.Split('@');
if (readAddr != sArray[2])
{
MessageBox.Show("EXCEL格式有误", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
File.WriteAllText(@subROMInfoFilename, sArray[1]);
File.WriteAllText(@txtDataFilename, sArray[0]);
textBox1.Text = "读取EXCEL数据成功，数据没有改变就不用再次选择";
this.Cursor = System.Windows.Forms.Cursors.Arrow;//设置鼠标为正常状态
}
}
//to excel
private void toolStripButton2_Click(object sender, EventArgs e)
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.Title = "请选择数据文件";
fileDialog.Filter = "*.xlsx|*.xlsx";
fileDialog.CheckFileExists = false;
if (fileDialog.ShowDialog() == DialogResult.OK)
{
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;//鼠标为忙碌状态
EXCELHelper2 excel = new EXCELHelper2();
int programDataCount = programData.Count;
List <string> s = new List <string>();
for (int i = 0; i < programDataCount; i++)
{
int rowCount = StringHelper.SubstringCount(programData[i], "\r\n");
string[] item = programData[i].Replace("\r\n", "!").Split('!');
s.AddRange(item);
}
int allRowCount = s.Count;
string[][] ss = new string[allRowCount][];
for (int i = 0; i < allRowCount; i++)
{
ss[i] = s[i].Replace(":", " ").Split(' ');
}
excel.excelWrite(fileDialog.FileName, ss);
this.Cursor = System.Windows.Forms.Cursors.Arrow;//设置鼠标为正常状态
}
}
