Aspose.cells 导出Excel
浏览数：93 /
时间：2015年06月09日
//Export private void btnExport_Click(object sender, RoutedEventArgs e) { string strDataTime = System.DateTime.Now.ToString("yyyyMMdd_HHmmss"); string strFileName = "buyf_Template" + strDataTime; SaveFileDialog save = new SaveFileDialog(); save.DefaultExt = "xlsx"; save.Filter = "Excel File|*.xlsx"; save.FileName = strFileName; if (save.ShowDialog() == true) { //获得数据源 DataClasses1DataContext db = new DataClasses1DataContext(); List<TBProduct> pros = new List<TBProduct>(); pros = (from p in db.TBProduct select p).Take(20).ToList(); string strReportPath = AppDomain.CurrentDomain.BaseDirectory + @"\Template\Buyf_Template.xlsx"; //string strReportPath = System.Windows.Forms.Application.ExecutablePath + @"\Template\Buyf_Template.xlsx"; Workbook book = new Workbook(strReportPath); Worksheet sheet = book.Worksheets[0]; sheet.Cells[0, 0].PutValue("Item One"); sheet.Cells[0, 1].PutValue("Item Two"); sheet.Cells[0, 2].PutValue("Item Three"); sheet.Cells[0, 3].PutValue("Item Four"); for (int i = 0; i < pros.Count; i++) { TBProduct pro = pros[i]; sheet.Cells[i + 1, 0].PutValue(pro.No); sheet.Cells[i + 1, 1].PutValue(pro.Name); sheet.Cells[i + 1, 2].PutValue(pro.CarNumber); sheet.Cells[i + 1, 3].PutValue(pro.SRP); } book.Save(save.FileName); MessageBox.Show("Export Successful!"); } }
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
