protected void btn_Export_Click(object sender, EventArgs e) { DataSet ds = this.GetProductDataSource(); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; if (dt.Rows.Count > 0) { //dt.Columns.Remove("Picture"); ExportExcel ex = new ExportExcel(); string excelname = "Product";//this.ddl_Type1.SelectedValue; excelname += "_view"; ex.ExportDataSource = dt; //excelname = MapPath("FileServer") + "\\" + excelname;//+ ".xls"; ex.DownloadFileName = excelname; string filedownloadurl = MapPath(ConfigurationManager.AppSettings["FileDownloadPath"]) + "\\"; ex.Download(); } else { //Response.Write("<script language=javascript>alert('No record!')</script>"); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "a", "<script>alert('导出前请先查询数据!');</script>"); } } else { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "a", "<script>alert('导出前请先查询数据!');</script>"); } }
private void ExportBtn_Click(object sender, RoutedEventArgs e) { if (DataShow.Items.Count > 0) { ExportExcel.ExportDataGridSaveAs(true, this.DataShow, "倒冲入库记录" + DateTime.Now.ToLongDateString().ToString()); } else { MessageBox.Show("当前没有可导出的数据!"); } }
public static void Init() { // init variables CsvReader.GetData(); // set initial K -> K = 4 as centroids int k = numberOfCentroids; for (int i = 0; i < numberOfIterations; i++) { if (i == 0) { //place K Randomly at first time. centroids = Centroid.Initialize(k); } //eucl distance from centroid to offers / items Centroid.CalcCentroidDistance(); //add data to cluster dictionary if (i > 0) { Centroid.ClearPointList(); } Centroid.AssignToCluster(); //vergelijk oude sse met nieuw Sse Centroid.UpdateSSE(); if (i > 0) { //relocate centroids centroids = Centroid.CalculateCentroidPosition(); } } Silhouette.Init(); foreach (var cluster in Centroid.sseCentroids) { var customers = cluster.Value; foreach (var customer in customers) { Silhouette.CalculateSilhouette(customer.CustomerId); } } PrintResults(); ExportExcel.Init(); ExportExcel.CreateClusterWorkSheet(); ExportExcel.CreateTopDealsWorkSheet(); ExportExcel.CreateSilhouetteWorkSheet(); ExportExcel.Export(); Console.ReadLine(); }
private void BtnReport_Click(object sender, EventArgs e) { ExportExcel export = new ExportExcel(); if (!export.ExportArchiveExcel(listView1)) { MessageBox.Show("No se Pudo Guardar la Informacon"); return; } MessageBox.Show("Infomacion Guardad -->"); }
/// <summary> /// 将符合查询的数据导出Excel /// </summary> /// <param name="filename"></param> /// <param name="grid"></param> /// <param name="httplink"></param> public void OutputExcel(string filename, ExtjsGrid grid, EntityWLOGWeekSummary wlogweeksummary) { #region int totalcount = 0; PageParams queryparams = new PageParams(1, 65536); DataSet ds = this.GetData(wlogweeksummary, queryparams, out totalcount); ExportExcel exportexcel = new ExportExcel(filename, ds, grid); exportexcel.Output(); #endregion }
/// <summary> /// 将符合查询的数据导出Excel /// </summary> /// <param name="filename"></param> /// <param name="grid"></param> /// <param name="httplink"></param> public void OutputExcel(string filename, ExtjsGrid grid, EntityBookPublisher bookpublisher) { #region int totalcount = 0; PageParams queryparams = new PageParams(1, 65536); DataSet ds = this.GetData(bookpublisher, queryparams, out totalcount); ExportExcel exportexcel = new ExportExcel(filename, ds, grid); exportexcel.Output(); #endregion }
public ActionResult Submit(AssetInventoryViewModel model) { string action = Request["Submit"]; if (action == "close") { if (model.InventoryId > 0) { this.AssetInventoryService.UpdateAssetInventoryStatus(model.InventoryId, AssetInventoryStatus.Closed); } } else if (action == "open") { if (model.InventoryId > 0) { this.AssetInventoryService.UpdateAssetInventoryStatus(model.InventoryId, AssetInventoryStatus.Open); } } else if (action == "exportNoScanInfo") { //导出某次盘点未扫描的资产信息 try { var assetInventory = this.AssetInventoryService.GetAssetInventory(model.InventoryId); var scanedAssetIds = new List <int>(); if (assetInventory != null && assetInventory.AssetInventoryRecords != null) { scanedAssetIds = assetInventory.AssetInventoryRecords.Where(it => it.AssetId.HasValue).Select(it => it.AssetId.Value).Distinct().ToList(); } var workbook = new Aspose.Cells.Workbook(); var descriptor = new ExportExcel <AssetModel>(); AssetSearchModel search = new AssetSearchModel() { BarCode = null, TypeId = null, BuyDate = null, UserName = null }; var assets = this.AssetService.List(search).Where(it => !scanedAssetIds.Contains(it.Id)).ToList(); descriptor.FillAssetData(assets, workbook, 0); var ms = new MemoryStream(); string fileName = assetInventory.Title + "(暂未扫描的资产信息)-" + DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx"; workbook.Save(ms, Aspose.Cells.SaveFormat.Xlsx); return(File(ms.ToArray(), "application/vnd.ms-excel", fileName)); } catch (Exception ex) { ViewBag.Message = ex.Message; } } return(RedirectToAction("Index")); }
/// <summary> /// 将符合查询的数据导出Excel /// </summary> /// <param name="filename"></param> /// <param name="grid"></param> /// <param name="httplink"></param> public void OutputExcel(string filename, ExtjsGrid grid, EntityRoleControlFunctionPoint rolecontrolfunctionpoint) { #region int totalcount = 0; PageParams queryparams = new PageParams(1, 65536); DataSet ds = this.GetData(rolecontrolfunctionpoint, queryparams, out totalcount); ExportExcel exportexcel = new ExportExcel(filename, ds, grid); exportexcel.Output(); #endregion }
private void OnExportExcel() { Cursor.Current = Cursors.WaitCursor; SaveFileDialog dlg = new SaveFileDialog(); dlg.Title = "Export Excel"; dlg.Filter = "Excel Files(*.xls,*.xlsx)|*.xls;*.xlsx"; if (dlg.ShowDialog() == DialogResult.OK) { ExportExcel.ExportThuocXuatHoaDonToExcel(dlg.FileName, dtpkTuNgay.Value, dtpkDenNgay.Value); } }
/// <summary> /// 导出Excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnShow_Click(object sender, EventArgs e) { //Maticsoft.Common.DataToExcel excel = new DataToExcel(); // Gdv_data.AllowPaging = false; // Gdv_data.ShowFooter = false; AspNetPager1.CurrentPageIndex = 1; AspNetPager1.PageSize = AspNetPager1.RecordCount; LoadData(); ExportExcel.GetExportExcel(Gdv_data, "用户列表"); AspNetPager1.CurrentPageIndex = 1; AspNetPager1.PageSize = 10; LoadData(); }
public void export() { try { var result = GetResults("Google", "IDS"); ExportExcel exp = new ExportExcel(result); exp.ExportToWepResponse(System.Web.HttpContext.Current.Response); //result.FirstOrDefault(). } catch (Exception ex) { } }
public string exportSource() { ExportExcel ee = new ExportExcel(); List <Product> gi = pg.Products.Where(w => w.IsDelete != -1).ToList(); ee.exportSource(Server.MapPath("/"), gi); JsonResult js = new JsonResult(); Result r = new Result(); r.succ = true; r.msg = ""; return(JsonConvert.SerializeObject(r)); }
public string ExcelTask(string date) { ExportExcel ee = new ExportExcel(); List <Group> gi = pg.Groups.Where(w => w.TaskID != "0").ToList(); ee.ExcelTask(Server.MapPath("/"), GrouplistAll(date)); JsonResult js = new JsonResult(); result r = new result(); r.code = "0"; r.msg = ""; return(JsonConvert.SerializeObject(r)); }
private void btnExport_Click(object sender, RoutedEventArgs e) { try { if (ExportExcel.ExportDetailRecordToExcel(txtPidNo.Text, Common.TempFilePath, dgDetailRecords)) { MessageBox.Show("导出成功!"); } } catch (Exception ex) { MessageBox.Show("导出失败,错误:" + ex.Message); } }
private void BtnExport_Click(object sender, RoutedEventArgs e) { try { if (ExportExcel.ExportRecordToExcel("训练信息", Common.TempFilePath, dataGridSisSerch)) { System.Windows.MessageBox.Show("导出已完成!"); } } catch (Exception ex) { System.Windows.MessageBox.Show("导出失败,错误:" + ex.Message); } }
//楼盘面积统计导出 public void HouseAreaExport(string SSJD, string expwher) { //获取导出列表 DataTable dt = BuildingsAndBuildingMonthInfoBLL.GetStatisticsByHouseName(Request["ParaName"]); //导出列 Dictionary <string, string> dicionary = new Dictionary <string, string> { { "HouseName", "楼盘名称" }, { "ZJZMJ", "总建筑面积" } }; ExportExcel.Export(dt.ExportExcelPre(dicionary), "楼盘面积统计"); }
public void Existup(DataTable ErrorDt) { try { ErrorDt.TableName = "table"; //string amountFileName = SyntacticSugar.ConfigSugar.GetAppString("Errortabel"); ExportExcel.ExportExcels("Errortabel.xlsx", "Errortabel.xls", ErrorDt); //Common.ExportExcel.ExportExcels("Errortabel.xlsx", amountFileName, ErrorDt); } catch (Exception) { throw; } }
private void OnExportExcel() { Cursor.Current = Cursors.WaitCursor; SaveFileDialog dlg = new SaveFileDialog(); dlg.Title = "Export Excel"; dlg.Filter = "Excel Files(*.xls,*.xlsx)|*.xls;*.xlsx"; if (dlg.ShowDialog() == DialogResult.OK) { DateTime tuNgay = new DateTime(dtpkTuNgay.Value.Year, dtpkTuNgay.Value.Month, dtpkTuNgay.Value.Day, 0, 0, 0); DateTime denNgay = new DateTime(dtpkDenNgay.Value.Year, dtpkDenNgay.Value.Month, dtpkDenNgay.Value.Day, 23, 59, 59); ExportExcel.ExportChiDinhDuocXuatHoaDon(dlg.FileName, tuNgay, denNgay); } }
public void export(List <WebLink> searchresult) { try { //List<WebLink> searchresult; ExportExcel exp = new ExportExcel(searchresult); exp.ExportToWepResponse(System.Web.HttpContext.Current.Response); //result.FirstOrDefault(). } catch (Exception ex) { } }
private void OnPrint(bool isPreview) { Cursor.Current = Cursors.WaitCursor; string template = string.Empty; DateTime tuNgay = new DateTime(dtpkTuNgay.Value.Year, dtpkTuNgay.Value.Month, dtpkTuNgay.Value.Day, 0, 0, 0); DateTime denNgay = new DateTime(dtpkDenNgay.Value.Year, dtpkDenNgay.Value.Month, dtpkDenNgay.Value.Day, 23, 59, 59); string docStaffGUID = cboDocStaff.SelectedValue.ToString(); string exportFileName = string.Format("{0}\\Temp\\ThongKeChiDinhCuaBacSi.xls", Application.StartupPath); if (isPreview) { if (!ExportExcel.ExportChiDinhCuaBacSi(exportFileName, tuNgay, denNgay, docStaffGUID)) { return; } try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(template)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } } else { if (_printDialog.ShowDialog() == DialogResult.OK) { if (!ExportExcel.ExportChiDinhCuaBacSi(exportFileName, tuNgay, denNgay, docStaffGUID)) { return; } try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(template)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } } } }
private void btnXuatExcel_Click(object sender, EventArgs e) { SaveFileDialog save = new SaveFileDialog(); save.Title = "Nơi chứa file Exprot Excel"; save.DefaultExt = "xls"; save.AddExtension = true; save.Filter = "File Excel (*.xls)|*.xls"; save.RestoreDirectory = true; save.FileName = string.Format("ExportExcel_{0}{1:00}{2:00}{3:00}{4:00}{5:00}", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); if (save.ShowDialog() == DialogResult.OK) { ExportExcel.ExportExcelByMicrosoft(dgvKhachHang, "Danh sách khách hàng", save.FileName, 65, "A2"); } }
/// <summary> /// 导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_Click(object sender, RoutedEventArgs e) { if (this.tabStat.SelectedIndex == 0) { ExportExcel.ExportDataGridSaveAs(true, userStat); } else if (this.tabStat.SelectedIndex == 1) { ExportExcel.ExportDataGridSaveAs(true, sumStat); } else if (this.tabStat.SelectedIndex == 2) { ExportExcel.ExportDataGridSaveAs(true, weightStat); } }
private void OnExportExcel() { if (_results == null || _results.Count <= 0) { return; } SaveFileDialog dlg = new SaveFileDialog(); dlg.Title = "Export Excel"; dlg.Filter = "Excel Files(*.xls,*.xlsx)|*.xls;*.xlsx"; if (dlg.ShowDialog(this) == DialogResult.OK) { ExportExcel.ExportDichVuTuTucToExcel(dlg.FileName, _results); } }
private void OnExportExcel() { Cursor.Current = Cursors.WaitCursor; SaveFileDialog dlg = new SaveFileDialog(); dlg.Title = "Export Excel"; dlg.Filter = "Excel Files(*.xls,*.xlsx)|*.xls;*.xlsx"; if (dlg.ShowDialog() == DialogResult.OK) { DateTime tuNgay = new DateTime(dtpkTuNgay.Value.Year, dtpkTuNgay.Value.Month, dtpkTuNgay.Value.Day, 0, 0, 0); DateTime denNgay = new DateTime(dtpkDenNgay.Value.Year, dtpkDenNgay.Value.Month, dtpkDenNgay.Value.Day, 23, 59, 59); string docStaffGUID = cboDocStaff.SelectedValue.ToString(); ExportExcel.ExportChiDinhCuaBacSi(dlg.FileName, tuNgay, denNgay, docStaffGUID); } }
/// <summary> /// 导出excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnShow_Click(object sender, EventArgs e) { AspNetPager1.CurrentPageIndex = 1; AspNetPager1.PageSize = AspNetPager1.RecordCount; if (AspNetPager1.RecordCount > 6000) { Maticsoft.Common.MessageBox.Show(this, "超过最大导出数,请先过滤条件后再导出!"); return; } LoadData(); ExportExcel.GetExportExcel(gvStatic, "用户测量数据列表"); AspNetPager1.CurrentPageIndex = 1; AspNetPager1.PageSize = 50; LoadData(); }
private void OnPrint() { Cursor.Current = Cursors.WaitCursor; List <string> checkedReceiptList = new List <string>(); DataTable dt = dgReceipt.DataSource as DataTable; foreach (DataRow row in dt.Rows) { if (Boolean.Parse(row["Checked"].ToString())) { checkedReceiptList.Add(row["ReceiptGUID"].ToString()); } } if (checkedReceiptList.Count > 0) { if (MsgBox.Question(Application.ProductName, "Bạn có muốn in những phiếu thu mà bạn đã đánh dấu ?") == DialogResult.Yes) { string exportFileName = string.Format("{0}\\Temp\\Receipt.xls", Application.StartupPath); foreach (string receiptGUID in checkedReceiptList) { try { if (ExportExcel.ExportReceiptToExcel(exportFileName, receiptGUID)) { if (_printDialog.ShowDialog() == DialogResult.OK) { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.PhieuThuDichVuTemplate)); } //ExcelPrintPreview.PrintPreview(exportFileName); } else { return; } } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); } } } } else { MsgBox.Show(Application.ProductName, "Vui lòng đánh dấu những phiếu thu cần in.", IconType.Information); } }
private void OnPrint(bool isPreview) { if (dgBenhNhan.RowCount <= 0) { return; } DataTable dt = dgBenhNhan.DataSource as DataTable; if (dt == null || dt.Rows.Count <= 0) { return; } string exportFileName = string.Format("{0}\\Temp\\DanhSachBenhNhanDenKham.xls", Application.StartupPath); if (isPreview) { if (ExportExcel.ExportDanhSachBenhNhanDenKhamToExcel(exportFileName, dt, raDenKham.Checked)) { try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(Const.DanhSachBenhNhanDenKhamTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); } } } else { if (_printDialog.ShowDialog() == DialogResult.OK) { if (ExportExcel.ExportDanhSachBenhNhanDenKhamToExcel(exportFileName, dt, raDenKham.Checked)) { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.DanhSachBenhNhanDenKhamTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } } } } }
/// <summary> /// xUẤT file excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ptbPrintf_Click(object sender, EventArgs e) { Thread thr = new Thread(() => { Invoke((MethodInvoker)(() => { string query = "USP_getListNhanVienReport"; DataTable data = DataProvider.Instance.ExecuteQuery(query); ExportExcel.exportDataToExcel("DANH SÁCH NHÂN VIÊN", data); })); }); thr.IsBackground = true; thr.Start(); }
private void OnExportExcel(string fileName) { try { if (_dtSource == null || _dtSource.Rows.Count <= 0) { return; } ExportExcel.ExportDichVuXetNghiemToExcel(fileName, _tuNgay, _denNgay, _dtSource); } catch (Exception ex) { MsgBox.Show(Application.ProductName, ex.Message, IconType.Error); Utility.WriteToTraceLog(ex.Message); } }
public HttpResponseMessage Post(string[] filePaths) { try { foreach (var item in filePaths) { ExportExcel excel = new ExportExcel(); excel.ReadExcelIntoDatatable(item); } return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { throw new HttpResponseException(HttpStatusCode.InternalServerError); } }
public string exportExcel() { ExportExcel ee = new ExportExcel(); List <GroupItem> gi = GetGroupData(); foreach (var g in gi) { ee.exportExcel(Server.MapPath("/"), g); } JsonResult js = new JsonResult(); result r = new result(); r.code = "0"; r.msg = ""; return(JsonConvert.SerializeObject(r)); }
public IWorkbook getWorkbookXLS(string tTitle, string tSubtitle, string tSource, string tKeywords, string tTableData, string tSvg) { IWorkbook workbook = null; try { string workingDir = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, Constants.XLSDownloadType.SvgRasterizerFolder); string baticPath = Constants.XLSDownloadType.BatikRasterizerJarFile; string templateFilePath = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, Constants.XLSDownloadType.ExcelTemplateFilePath); if (File.Exists(templateFilePath)) { Process dosProcess = new Process(); dosProcess.EnableRaisingEvents = false; if (!Page.IsPostBack) { ExportExcel exportExcel = new ExportExcel(); workbook = SpreadsheetGear.Factory.GetWorkbook(templateFilePath); #region Table tab IWorksheet tableWorksheet = workbook.Worksheets[1]; tableWorksheet.Name = "Table"; tableWorksheet = exportExcel.getTableWorksheet(tableWorksheet, tTableData, tTitle); #endregion #region Source tab IWorksheet sourceWorksheet = workbook.Worksheets[2]; sourceWorksheet.Name = "Source"; sourceWorksheet.Cells["A1"].Value = "Source"; string[] sourceArray = null; if (!string.IsNullOrEmpty(tSource)) { sourceArray = tSource.Split(new string[] { "{}" }, StringSplitOptions.None); int i = 2; foreach (string sourceString in sourceArray) { sourceWorksheet.Cells["A" + i].Value = sourceString; i++; } } #endregion #region Keywords tab IWorksheet keywordWorksheet = workbook.Worksheets[3]; keywordWorksheet.Name = "Keywords"; keywordWorksheet.Cells["A1"].Value = "Keywords"; string[] keywordArray = null; if (!string.IsNullOrEmpty(tKeywords)) { keywordArray = tKeywords.Split(new string[] { "{}" }, StringSplitOptions.None); int i = 2; foreach (string keywordString in keywordArray) { keywordWorksheet.Cells["A" + i].Value = keywordString; i++; } } #endregion #region If Svg ImageFormat if (!string.IsNullOrEmpty(tSvg)) { string tempFilename = DateTime.Now.ToString(); tempFilename = exportExcel.removeInvalidCharacters(tempFilename); string filePath = Path.Combine(workingDir, tempFilename + Constants.XLSDownloadType.SvgExtention); FileStream fileStream = File.Create(filePath); fileStream.Close(); using (StreamWriter sw = new StreamWriter(filePath)) { sw.Write(tSvg); } # region Image convertion svg to png using Batick /* Convert svg to png using http://xmlgraphics.apache.org/batik/tools/rasterizer.html */ string filePth = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @filePath); var sampleDoc = SvgDocument.Open(filePth, new Dictionary<string, string> { {"entity1", "fill:red" }, {"entity2", "fill:yellow" } }); string destination = @workingDir + "\\" + tempFilename + ".png"; sampleDoc.Draw().Save(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, destination)); int imageWidth = 470; //string command = "/C java -jar " + baticPath + " " + Constants.XLSDownloadType.ImageType + " " + tempFilename + Constants.XLSDownloadType.SvgExtention; //ProcessStartInfo startInfo = new ProcessStartInfo("cmd.exe"); //startInfo.UseShellExecute = false; //startInfo.WorkingDirectory = workingDir; //startInfo.Arguments = command; //startInfo.CreateNoWindow = true; //dosProcess.StartInfo = startInfo; //dosProcess.Start(); //dosProcess.WaitForExit(); //dosProcess.Close(); #endregion #region Graph tab string chartImageName = Path.Combine(workingDir, tempFilename); if (File.Exists(chartImageName + Constants.XLSDownloadType.PngExtention)) { MemoryStream picStream = new MemoryStream(); System.Drawing.Image chartImageObj = System.Drawing.Image.FromFile(chartImageName + Constants.XLSDownloadType.PngExtention); chartImageObj.Save(picStream, ImageFormat.Png); chartImageObj.Dispose(); // Graph tab IWorksheet visualizerWorksheet = workbook.Worksheets[0]; visualizerWorksheet.Name = "Graph"; visualizerWorksheet.Cells["A1"].Value = tTitle; visualizerWorksheet.Cells["A2"].Value = tSubtitle; visualizerWorksheet.Cells["A3"].Value = DateTime.Now.ToString(); string baseURL = this.Page.Request.Url.OriginalString.ToString(); baseURL = baseURL.Substring(0, baseURL.IndexOf("libraries") - 1); visualizerWorksheet.Cells["A4"].Value = baseURL; visualizerWorksheet.Cells["A1"].Columns.AutoFit(); System.Drawing.Image chartImage = System.Drawing.Image.FromStream(picStream); int imageHeight = (int)((imageWidth * chartImage.Height) / chartImage.Width); visualizerWorksheet.Shapes.AddPicture(picStream.ToArray(), 0, 100, (double)imageWidth, (double)imageHeight); picStream.Close(); picStream.Dispose(); visualizerWorksheet.MoveBefore(workbook.Sheets[0]); //Delete image files. if (File.Exists(chartImageName + Constants.XLSDownloadType.PngExtention)) { File.Delete(chartImageName + Constants.XLSDownloadType.PngExtention); } if (File.Exists(chartImageName + Constants.XLSDownloadType.SvgExtention)) { File.Delete(chartImageName + Constants.XLSDownloadType.SvgExtention); } } #endregion } else { workbook.Sheets[0].Delete(); } # endregion workbook.Sheets[0].Select(); } } } catch (Exception ex) { Global.CreateExceptionString(ex, null); } return workbook; }
private void BtnExcel_Click(object sender, EventArgs e) { this.lblMessage.Text = ""; if (dgvMain.DataSource != null && ((DataTable)(dgvMain.DataSource)).Rows.Count > 0) { if (strTitle.Equals("")) { strTitle = "全矿人员 " + cmbYear.SelectedItem.ToString() + "--" + cmbMonth.SelectedItem.ToString() + " 出勤情况明细"; } ExportExcel excel = new ExportExcel(); string time = string.Format("统计年份:{0} 统计月份:{1}", cmbYear.SelectedItem.ToString(), cmbMonth.SelectedItem.ToString()); excel.Sql_ExportExcel(GetDataTable(), time, "", strTitle); } else { MessageBox.Show("没有可用导出数据!"); } }
public ActionResult DownLoadDept() { string fileName = Server.MapPath("/") + @"Files\Temp\"+"1.xlsx"; IList<ExcelField> fields=new List<ExcelField>(); ExcelField ef=null; ef=new ExcelField("Code","代码"); fields.Add(ef); ef = new ExcelField("Name", "名字"); fields.Add(ef); ef = new ExcelField("TestExcel", "测试Excel"); fields.Add(ef); TbBaseOper<Department> departmentOper = new TbBaseOper<Department>(HibernateOper, typeof(Department)); IList<Department> list=departmentOper.Get(); //ExportExcel ee = new ExportExcel(fileName, "abc", fields); ExportExcel ee = new ExportExcel(fileName,typeof(Department)); ee.Save(list); //返回文件 return File(fileName, "xlsx", "1.xlsx"); }
private void ExpBtn_Click(object sender, EventArgs e) { QueryObject<Finance> query = new QueryObject<Finance>(); query.Condition = new Finance(); query.Condition.BeginTime = this.BeginDate.Value.ToString(Constants.DateFormat); query.Condition.EndTime = this.EndDate.Value.ToString(Constants.DateFormat); query.Condition.Description = this.Description.Text.Trim(); query.Condition.EventType = (string)this.EventType.SelectedValue; query.Condition.ItemType = (string)this.ItemType.SelectedValue; query.Condition.Association = (string)this.Association.SelectedValue; query.Condition.ReceivePaymentor = this.ReceivePaymentor.Text.Trim(); QueryObject<Finance> result = finOrderManager.GetFinances(query); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "Excel工作簿(*.xls,*.xlsx)| *.xls; *.xlsx"; saveFileDialog1.FilterIndex = 2; saveFileDialog1.RestoreDirectory = true; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { string localFilePath = saveFileDialog1.FileName.ToString(); try { ExportExcel exporter = new ExportExcel(); exporter.AddColumn("FinDate", "日期"); exporter.AddColumn("EventType", "收支类型"); exporter.AddColumn("Description", "款项说明"); exporter.AddColumn("Amount", "金额"); exporter.AddColumn("Rate", "汇率"); exporter.AddColumn("TotalAmount", "总金额"); exporter.AddColumn("ReferenceNo", "流水号"); exporter.AddColumn("ReceivePaymentor", "收付款单位"); exporter.AddColumn("Association", "经手人/相关人"); exporter.AddColumn("Remark", "备注"); exporter.ExportToExcel<Finance>(result.Result, localFilePath); exporter.Dispose(); } catch (Exception ex) { MessageBox.Show("保存文件出错:" + ex.Message); } } }
private void ExpBtn_Click(object sender, EventArgs e) { QueryObject<Order> query = GetQueryObject(); QueryObject<Order> result = finOrderManager.GetOrders(query); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "Excel工作簿(*.xls,*.xlsx)| *.xls; *.xlsx"; saveFileDialog1.FilterIndex = 2; saveFileDialog1.RestoreDirectory = true; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { string localFilePath = saveFileDialog1.FileName.ToString(); try { ExportExcel exporter = new ExportExcel(); exporter.AddColumn("BeginDate", "开始日期"); exporter.AddColumn("EndDate", "结束日期"); exporter.AddColumn("OrderNo", "订单编号"); exporter.AddColumn("Description", "订单描述"); exporter.AddColumn("SalesMan", "业务员"); exporter.AddColumn("Status", "订单状态"); if (!IsFinOrderView) { exporter.AddColumn("Remark", "备注"); } else { exporter.AddColumn("TotalAmount", "业务总金额"); } exporter.ExportToExcel<Order>(result.Result, localFilePath); exporter.Dispose(); } catch (Exception ex) { MessageBox.Show("保存文件出错:" + ex.Message); } } }
public ActionResult GetImportErrorExcel(string sessionKey, string tableName) { MemoryCacheManager cacheManager = new MemoryCacheManager(); ActionResult result = null; DataSet ds = ExcelConnection.ImportExcelDataset(sessionKey); if (ds != null) { PagingDataTable importExcelTable = null; if (ds.Tables[tableName] != null) { importExcelTable = (PagingDataTable)ds.Tables[tableName]; } PagingDataTable errorTable = (PagingDataTable)importExcelTable.Clone(); DataRow[] rows = importExcelTable.Select("ImportError<>''"); foreach (var row in rows) { errorTable.ImportRow(row); } //if (importExcelTable != null) { result = new ExportExcel { TableName = string.Format("{0}_{1}", tableName, sessionKey), GridData = errorTable }; //} } return result; }
public IWorkbook getWorkbookForSwf(string tTitle, string tSubtitle, string tSource, string tKeywords, string tTableData, string imgData) { IWorkbook workbook = null; MemoryStream picStream = new MemoryStream(Convert.FromBase64String(imgData)); int imageWidth = 470; string templateFilePath = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath,Constants.XLSDownloadType.ExcelTemplateFilePath); ExportExcel exportExcel = new ExportExcel(); if (File.Exists(templateFilePath)) { workbook = SpreadsheetGear.Factory.GetWorkbook(templateFilePath); #region Table tab IWorksheet tableWorksheet = workbook.Worksheets[1]; tableWorksheet.Name = "Table"; tableWorksheet = exportExcel.getTableWorksheet(tableWorksheet, tTableData, tTitle); #endregion #region Source tab IWorksheet sourceWorksheet = workbook.Worksheets[2]; sourceWorksheet.Name = "Source"; sourceWorksheet.Cells["A1"].Value = "Source"; string[] sourceArray = null; if (!string.IsNullOrEmpty(tSource)) { sourceArray = tSource.Split(new string[] { "{}" }, StringSplitOptions.None); int i = 2; foreach (string sourceString in sourceArray) { sourceWorksheet.Cells["A" + i].Value = sourceString; i++; } } #endregion #region Keywords tab IWorksheet keywordWorksheet = workbook.Worksheets[3]; keywordWorksheet.Name = "Keywords"; keywordWorksheet.Cells["A1"].Value = "Keywords"; string[] keywordArray = null; if (!string.IsNullOrEmpty(tKeywords)) { keywordArray = tKeywords.Split(new string[] { "{}" }, StringSplitOptions.None); int i = 2; foreach (string keywordString in keywordArray) { keywordWorksheet.Cells["A" + i].Value = keywordString; i++; } } #endregion #region Graph tab IWorksheet visualizerWorksheet = workbook.Worksheets[0]; visualizerWorksheet.Name = "Graph"; visualizerWorksheet.Cells["A1"].Value = tTitle; visualizerWorksheet.Cells["A2"].Value = tSubtitle; visualizerWorksheet.Cells["A3"].Value = DateTime.Now.ToString(); string baseURL = this.Page.Request.Url.OriginalString.ToString(); baseURL = baseURL.Substring(0, baseURL.IndexOf("libraries") - 1); visualizerWorksheet.Cells["A4"].Value = baseURL; visualizerWorksheet.Cells["A1"].Columns.AutoFit(); // Insert Image System.Drawing.Image chartImage = System.Drawing.Image.FromStream(picStream); int imageHeight = (int)((imageWidth * chartImage.Height) / chartImage.Width); visualizerWorksheet.Shapes.AddPicture(picStream.ToArray(), 0, 100, (double)imageWidth, (double)imageHeight); visualizerWorksheet.MoveBefore(workbook.Sheets[0]); #endregion workbook.Sheets[0].Select(); picStream.Close(); picStream.Dispose(); } return workbook; }
private void FinDetailExpBtn_Click(object sender, EventArgs e) { QueryObject<FinDetails> query = new QueryObject<FinDetails>(); query.IsExport = true; query.Condition = new FinDetails(); query.Condition.BeginTime = this.BeginDateTxt.Value.ToString(Constants.DateFormat); query.Condition.EndTime = this.EndDateTxt.Value.ToString(Constants.DateFormat); query.Condition.Description = this.EventNameTxt.Text.Trim(); query.Condition.EventType = (string)this.EventTypeTxt.SelectedValue; query.Condition.ItemType = (string)this.ItemTypeTxt.SelectedValue; query.Condition.OrderNo = this.OrderNoTxt.Text.Trim(); query.Condition.Association = (string)this.AssociationTxt.SelectedValue; QueryObject<FinDetails> result = finOrderManager.GetFinDetails(query); SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "Excel工作簿(*.xls,*.xlsx)| *.xls; *.xlsx"; saveFileDialog1.FilterIndex = 2; saveFileDialog1.RestoreDirectory = true; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { string localFilePath = saveFileDialog1.FileName.ToString(); try { ExportExcel exporter = new ExportExcel(); exporter.AddColumn("FinDate","日期"); exporter.AddColumn("Description", "描述"); exporter.AddColumn("TotalAmount","金额"); exporter.AddColumn("OrderNo","所属业务"); exporter.AddColumn("ItemType","项目类型"); exporter.AddColumn("Association","经手人/相关人"); exporter.AddColumn("EventType","收支类型"); exporter.AddColumn("Remark","备注"); exporter.ExportToExcel<FinDetails>(result.Result, localFilePath); exporter.Dispose(); } catch (Exception ex) { MessageBox.Show("保存文件出错:" + ex.Message); } } }