/// <summary> /// 导出的Click事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void m_btnExport_Click(object sender, EventArgs e) { if (m_dwRep.RowCount > 0) { clsVolDatawindowToExcel[] volExcel = new clsVolDatawindowToExcel[2]; volExcel[0] = new clsVolDatawindowToExcel(1); volExcel[0].m_rowheight[0] = 20; volExcel[0].m_title_text[0] = this.m_dwRep.Describe("t_title.text"); volExcel[0].m_HorizontalAlignment[0] = "0"; volExcel[0].m_firstcommn[0] = "A1"; volExcel[0].m_endcommn[0] = "ALL"; volExcel[1] = new clsVolDatawindowToExcel(3); volExcel[1].m_rowheight[0] = 20; volExcel[1].m_title_text[0] = this.m_dwRep.Describe("t_area.text"); volExcel[1].m_HorizontalAlignment[0] = "L"; volExcel[1].m_firstcommn[0] = "B1"; volExcel[1].m_endcommn[0] = "D1"; volExcel[1].m_rowheight[1] = 20; volExcel[1].m_title_text[1] = this.m_dwRep.Describe("t_date.text"); volExcel[1].m_HorizontalAlignment[0] = "L"; volExcel[1].m_firstcommn[1] = "D1"; volExcel[1].m_endcommn[1] = "E1"; volExcel[1].m_rowheight[2] = 20; volExcel[1].m_title_text[2] = this.m_dwRep.Describe("t_print.text"); volExcel[1].m_HorizontalAlignment[2] = "L"; volExcel[1].m_firstcommn[2] = "F1"; volExcel[1].m_endcommn[2] = "ALL"; clsPublic.ExportDataWindow(m_dwRep, volExcel); } }
private void btnExport_Click(object sender, EventArgs e) { if (this.dwRep.RowCount > 0) { clsVolDatawindowToExcel[] volExcl = new clsVolDatawindowToExcel[2]; volExcl[0] = new clsVolDatawindowToExcel(1); volExcl[0].m_firstcommn[0] = "A1"; volExcl[0].m_endcommn[0] = "ALL"; volExcl[0].m_title_text[0] = dwRep.Describe("t_title.text"); volExcl[0].m_rowheight[0] = 20; volExcl[0].m_HorizontalAlignment[0] = "0"; volExcl[1] = new clsVolDatawindowToExcel(2); volExcl[1].m_firstcommn[0] = "A1"; volExcl[1].m_endcommn[0] = "F1"; volExcl[1].m_title_text[0] = dwRep.Describe("t_ks.text"); volExcl[1].m_rowheight[0] = 20; volExcl[1].m_HorizontalAlignment[0] = "L"; volExcl[1].m_firstcommn[1] = "G1"; volExcl[1].m_endcommn[1] = "ALL"; volExcl[1].m_title_text[1] = dwRep.Describe("t_date.text"); volExcl[1].m_rowheight[1] = 20; volExcl[1].m_HorizontalAlignment[1] = "L"; clsPublic.ExportDataWindow(this.dwRep, volExcl); } }