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;//设置鼠标为正常状态 } }