private void ButtonInsertAnnoToExcel_Click(object sender, EventArgs e) { //判断机制需要更加智能 if (this.dataGridViewAnnoText.DataSource != null && this.dataGridViewAnnoText.Rows.Count > 0) { if (this.dataGridViewAnnoText.Rows.Count == 0) { MessageBox.Show("未查询到相应数据!"); } else { //int seletedHandle = this.dataGridViewResult.CurrentRow.Index; //MessageBox.Show(dataGridViewResult.CurrentRow.Cells[3].Value.ToString()); //获得选中行的值 //EditExcel.getActivCell().Value = dataGridViewResult.CurrentRow.Cells[3].Value.ToString(); EditExcel.getActivCell().Value = StringHelper.insert2Excel(dataGridViewAnnoText.CurrentRow.Cells[2].Value.ToString(), dataGridViewAnnoText.CurrentRow.Cells[3].Value.ToString()); //MessageBox.Show(this.gridView1.GetRowCellValue(seletedHandle, "IRI").ToString()); //Insert2Excel.insert2Excel(this.gridView1.GetRowCellValue(seletedHandle, "Term").ToString(), this.gridView1.GetRowCellValue(seletedHandle, "IRI").ToString(), sheetControl); } } else { MessageBox.Show("请先搜索", "ERROR"); } }
public void annotatorTerm(IRibbonControl control) { //如果用户未创建sheet,将自动创建一个sheet if (!EditExcel.IsSheetActive()) { EditExcel.createWorkbook(); } Form aForm = new AnnotatorForm(); aForm.Show(); }
public void searchTerm(IRibbonControl control) { //如果用户未创建sheet,将自动创建一个sheet if (!EditExcel.IsSheetActive()) { EditExcel.createWorkbook(); } Form sForm = new SearchTermForm(); sForm.Show(); }
public void uploadXML(IRibbonControl control) { //xml文件上传模块 OpenFileDialog uploadXMLDiaglog = new OpenFileDialog(); uploadXMLDiaglog.Filter = "Xml文件|*.xml"; uploadXMLDiaglog.FileName = string.Empty; uploadXMLDiaglog.FilterIndex = 1; uploadXMLDiaglog.RestoreDirectory = true; if (uploadXMLDiaglog.ShowDialog() == DialogResult.OK) { //test MessageBox.Show(uploadXMLDiaglog.FileName); string xmlFilePath = uploadXMLDiaglog.FileName; //读取XML模板中的数据 try { XElement xe = XElement.Load(@xmlFilePath); var elements = from ele in xe.Elements() select ele; //引入数据模型接受数据 List <DateElement> modulList = new List <DateElement>(); //测试 //MessageBox.Show(modulList.Count.ToString()); //获得xml中所有数据以及其可用性范围 //其中值为空时,输出为'',并不是null foreach (var ele in elements) { DateElement de = new DateElement(); de.LONGNAME = ele.Element("LONGNAME").Value; de.PreferredQuestionText = ele.Element("PreferredQuestionText").Value; de.Datatype = ele.Element("VALUEDOMAIN").Element("Datatype").Value; de.ValueDomainType = ele.Element("VALUEDOMAIN").Element("ValueDomainType").Value; de.UnitOfMeasure = ele.Element("VALUEDOMAIN").Element("UnitOfMeasure").Value != "" ? ele.Element("VALUEDOMAIN").Element("UnitOfMeasure").Value : null; de.MaximumLength = ele.Element("VALUEDOMAIN").Element("MaximumLength").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("MaximumLength").Value) : -1; de.MinimumLength = ele.Element("VALUEDOMAIN").Element("MinimumLength").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("MinimumLength").Value) : -1; de.DecimalPlace = ele.Element("VALUEDOMAIN").Element("DecimalPlace").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("DecimalPlace").Value) : -1; de.MaximumValue = ele.Element("VALUEDOMAIN").Element("MaximumValue").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("MaximumValue").Value) : -1; de.MinimumValue = ele.Element("VALUEDOMAIN").Element("MinimumValue").Value != "" ? Convert.ToInt32(ele.Element("VALUEDOMAIN").Element("MinimumValue").Value) : -1; modulList.Add(de); } //测试 MessageBox.Show(modulList.Count.ToString()); /** *处理Excel */ EditExcel ee = new EditExcel(); ee.createWorkbookWithDateElement(StringHelper.getCurrPath(xmlFilePath), modulList); //ee.createWorkbook(sh.getCurrPath(xmlFilePath)); EditExcel.openFile(StringHelper.getCurrPath(xmlFilePath)); } catch (Exception e) { // english version alt information MessageBox.Show("错误: " + e.Message + "上传的模板编码请设置成UTF-8,提示:另存为,右下角选择编码模式UTF-8"); } } }