public static void export_Excel(string tenFile, GridView view, bool exportText = false) { SaveFileDialog sf = new SaveFileDialog(); sf.Filter = "Excel 2007-2010(*.xlsx) |*.xlsx|Excel 97-2003(*.xls)|*.xls"; sf.AddExtension = true; sf.FileName = tenFile; if (sf.ShowDialog() == DialogResult.OK) { if (sf.FileName.Contains(".xlsx")) { XlsxExportOptionsEx option = new XlsxExportOptionsEx(); if (exportText) { option.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Text; } option.ExportType = ExportType.WYSIWYG; view.ExportToXlsx(sf.FileName, option); } else if (sf.FileName.Contains(".xls")) { XlsExportOptionsEx option = new XlsExportOptionsEx(); if (exportText) { option.TextExportMode = DevExpress.XtraPrinting.TextExportMode.Text; } option.ExportType = ExportType.WYSIWYG; view.ExportToXls(sf.FileName, option); } //if (XtraMessageBox.Show("Export excel, Bạn có muốn mở nó ngay?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) System.Diagnostics.Process.Start(sf.FileName); } }
protected void btnExport_Click(object sender, EventArgs e) { DevExpress.XtraPrinting.XlsExportOptionsEx options = new XlsExportOptionsEx() { ExportType = DevExpress.Export.ExportType.WYSIWYG }; options.SheetName = "DevExpress"; gridExporter.WriteXlsToResponse(options); }
public ActionResult ExportTo(GridViewExportFormat?exportFormat, int companyId, DateTime d_From, DateTime d_To) { Thread.CurrentThread.CurrentCulture = new CultureInfo("tr-TR"); string _CompanyName = (from tt in DB.Companies where tt.ID == companyId && tt.IS_DELETED == false select new { tt.NAME }).FirstOrDefault().NAME; if (exportFormat == null || !GridViewExportHelper.ExportFormatsInfo.ContainsKey(exportFormat.Value)) { return(RedirectToAction("CompanyAlarmListPartial", companyId)); } //DateTime dts = Convert.ToDateTime(datePck); string date1 = Convert.ToString(d_From); date1 = date1.Substring(0, date1.Length - 9); DateTime date_1 = Convert.ToDateTime(date1); DateTime date_2; DateTime date2 = Convert.ToDateTime(d_To); if (date2.Hour == 00) { date_2 = date2.AddHours(23); date_2 = date_2.AddMinutes(59); } else { date_2 = date2; } var _list = (from tt in DB.AlarmStatus join t in DB.Stations on tt.STATION_ID equals t.ID where t.COMPANY_ID == companyId select new { tt.INVERTER_ID, tt.ERROR_NUMBER, tt.START_DATE, tt.STATION_ID, tt.END_DATE, t.NAME }).OrderBy(X => X.START_DATE).ToList(); var _listInv = DB.Inverters.ToList(); var _listAlarmDesc = DB.AlarmDesc.ToList(); List <AlarmStatusDTO> _ListDataSource = new List <AlarmStatusDTO>(); for (int i = 0; i < _list.Count; i++) { AlarmStatusDTO alarmStatus = new AlarmStatusDTO(); alarmStatus.INVERTER_ID = _list[i].INVERTER_ID; TBL_INVERTER _TblInv = _listInv.Where(x => x.ID == _list[i].INVERTER_ID).FirstOrDefault(); if (_TblInv != null) { alarmStatus.INV_NAME = _TblInv.NAME; } else { alarmStatus.INV_NAME = "-"; } alarmStatus.ERROR_NUMBER = _list[i].ERROR_NUMBER; //alarmStatus.STATUS = _list[i].STATUS; alarmStatus.START_DATE = _list[i].START_DATE; alarmStatus.STATION_NAME = _list[i].NAME; alarmStatus.END_DATE = _list[i].END_DATE; alarmStatus.STATION_ID = _list[i].STATION_ID; alarmStatus.ERROR_NUMBER_NAME = _listAlarmDesc.Where(a => a.ERROR_NUMBER == _list[i].ERROR_NUMBER).FirstOrDefault().ERROR_DESC; //switch (_list[i].ERROR_NUMBER) //{ // case "0001": // alarmStatus.ERROR_NUMBER_NAME = "Communication Error"; // break; // case "0002": // alarmStatus.ERROR_NUMBER_NAME = "Station Voltage L2 Fault"; // break; // case "0003": // alarmStatus.ERROR_NUMBER_NAME = "Station Voltage L1 Fault"; // break; // case "0004": // alarmStatus.ERROR_NUMBER_NAME = "Station Voltage L3 Fault"; // break; // case "0005": // alarmStatus.ERROR_NUMBER_NAME = "EKK No Connection"; // break; // case "0006": // alarmStatus.ERROR_NUMBER_NAME = "No Main Voltage"; // break; // case "0007": // alarmStatus.ERROR_NUMBER_NAME = "No Production"; // break; // case "0008": // alarmStatus.ERROR_NUMBER_NAME = "AC Voltage Fault"; // break; //} _ListDataSource.Add(alarmStatus); } List <CompanyAlarmStatusExportDTO> _ListExport = new List <CompanyAlarmStatusExportDTO>(); var _TempList = _ListDataSource.Where(x => x.START_DATE >= date_1 && x.START_DATE <= date_2) /*.OrderBy(x => x.START_DATE)*/.ToList(); for (int i = 0; i < _TempList.Count; i++) { CompanyAlarmStatusExportDTO _ExportDto = new CompanyAlarmStatusExportDTO(); _ExportDto.ID = i + 1; _ExportDto.DEVICE = _TempList[i].INV_NAME; _ExportDto.ERROR_DEFINITION = _TempList[i].ERROR_NUMBER_NAME; _ExportDto.ALERT_START_DATE = _TempList[i].START_DATE.ToString(); _ExportDto.ALERT_END_DATE = _TempList[i].END_DATE.ToString(); _ExportDto.STATION_NAME = _TempList[i].STATION_NAME; _ListExport.Add(_ExportDto); } string filename = _CompanyName + " (" + date1.ToString() + " - " + date2.ToShortDateString() + ")"; GridHelper gh = new GridHelper(companyId); if (exportFormat == GridViewExportFormat.Xls) { XlsExportOptionsEx exportOptions = new XlsExportOptionsEx(); exportOptions.CustomizeCell += new DevExpress.Export.CustomizeCellEventHandler(exportOptions_CustomizeCell); return(GridViewExtension.ExportToXls(gh.GridStationSetting, _ListExport, filename, exportOptions)); } else if (exportFormat == GridViewExportFormat.Pdf) { return(GridViewExtension.ExportToPdf(gh.GridStationSetting, _ListExport, filename)); } else if (exportFormat == GridViewExportFormat.Xlsx) { return(GridViewExtension.ExportToXlsx(gh.GridStationSetting, _ListExport, filename)); } return(View(companyId)); }
public ActionResult ExportTo(GridViewExportFormat?exportFormat, int stationId, DateTime d_From, DateTime d_To) { Thread.CurrentThread.CurrentCulture = new CultureInfo("tr-TR"); string _stationName = (from tt in DB.Stations where tt.ID == stationId && tt.IS_DELETED == false select new { tt.NAME }).FirstOrDefault().NAME; if (exportFormat == null || !GridViewExportHelper.ExportFormatsInfo.ContainsKey(exportFormat.Value)) { return(RedirectToAction("AlarmListPartial", stationId)); } //DateTime dts = Convert.ToDateTime(datePck); string date1 = Convert.ToString(d_From); date1 = date1.Substring(0, date1.Length - 9); DateTime date_1 = Convert.ToDateTime(date1); DateTime date_2; DateTime date2 = Convert.ToDateTime(d_To); if (date2.Hour == 00) { date_2 = date2.AddHours(23); date_2 = date_2.AddMinutes(59); } else { date_2 = date2; } var stationName = DB.Stations.Where(a => a.ID == stationId).FirstOrDefault().NAME; var _listAlarmDesc = DB.AlarmDesc.ToList(); var _list = DB.AlarmStatus.Where(x => x.STATION_ID == stationId).OrderBy(x => x.START_DATE).ToList(); var _listInv = DB.Inverters.ToList(); List <AlarmStatusDTO> _ListDataSource = new List <AlarmStatusDTO>(); for (int i = 0; i < _list.Count; i++) { AlarmStatusDTO alarmStatus = new AlarmStatusDTO(); alarmStatus.INVERTER_ID = _list[i].INVERTER_ID; TBL_INVERTER _TblInv = _listInv.Where(x => x.ID == _list[i].INVERTER_ID).FirstOrDefault(); if (_TblInv != null) { alarmStatus.INV_NAME = _TblInv.NAME; } else { alarmStatus.INV_NAME = stationName; } alarmStatus.ERROR_NUMBER = _list[i].ERROR_NUMBER; //alarmStatus.STATUS = _list[i].STATUS; alarmStatus.START_DATE = _list[i].START_DATE; alarmStatus.END_DATE = _list[i].END_DATE; alarmStatus.STATION_ID = _list[i].STATION_ID; alarmStatus.ERROR_NUMBER_NAME = _listAlarmDesc.Where(a => a.ERROR_NUMBER == _list[i].ERROR_NUMBER).FirstOrDefault().ERROR_DESC; _ListDataSource.Add(alarmStatus); } List <AlarmStatusExportDTO> _ListExport = new List <AlarmStatusExportDTO>(); var _TempList = _ListDataSource.Where(x => x.START_DATE >= date_1 && x.START_DATE <= date_2) /*.OrderBy(x => x.START_DATE)*/.ToList(); for (int i = 0; i < _TempList.Count; i++) { AlarmStatusExportDTO _ExportDto = new AlarmStatusExportDTO(); _ExportDto.ID = i + 1; _ExportDto.DEVICE = _TempList[i].INV_NAME; _ExportDto.ERROR_DEFINITION = _TempList[i].ERROR_NUMBER_NAME; _ExportDto.ALERT_START_DATE = _TempList[i].START_DATE.ToString(); _ExportDto.ALERT_END_DATE = _TempList[i].END_DATE.ToString(); _ListExport.Add(_ExportDto); } string filename = _stationName + " (" + date1.ToString() + " - " + date2.ToShortDateString() + ")"; GridHelper gh = new GridHelper(stationId); if (exportFormat == GridViewExportFormat.Xls) { XlsExportOptionsEx exportOptions = new XlsExportOptionsEx(); exportOptions.CustomizeCell += new DevExpress.Export.CustomizeCellEventHandler(exportOptions_CustomizeCell); return(GridViewExtension.ExportToXls(gh.GridStationSetting, _ListExport, filename, exportOptions)); } else if (exportFormat == GridViewExportFormat.Pdf) { return(GridViewExtension.ExportToPdf(gh.GridStationSetting, _ListExport, filename)); } else if (exportFormat == GridViewExportFormat.Xlsx) { return(GridViewExtension.ExportToXlsx(gh.GridStationSetting, _ListExport, filename)); } return(View(stationId)); }
public static void XuatExcelv2Ten(string _fileName, DevExpress.XtraGrid.Views.Grid.GridView gridView1, GridControl gc) { //_fileName = Regex.Replace(_fileName, "[^0-9a-zA-Z]+", "") + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") ; SaveFileDialog dialog = new SaveFileDialog(); dialog.Filter = "Excel 97-2003 Workbook(.xls)|*.xls| Excel Workbook(.xlsx) | *.xlsx"; dialog.FileName = _fileName.ToUpper(); DialogResult result = dialog.ShowDialog(); try { if (result == DialogResult.OK) { string fileName = dialog.FileName; if (dialog.FilterIndex == 0) { XlsExportOptionsEx exportOptions = new XlsExportOptionsEx(); //exportOptions.CustomizeSheetHeader += options_CustomizeSheetHeader; //exportOptions.TextExportMode = TextExportMode.Text; exportOptions.ShowTotalSummaries = DevExpress.Utils.DefaultBoolean.True; exportOptions.FitToPrintedPageWidth = false; exportOptions.AllowSortingAndFiltering = DevExpress.Utils.DefaultBoolean.True; exportOptions.ShowColumnHeaders = DevExpress.Utils.DefaultBoolean.True; exportOptions.ShowPageTitle = DevExpress.Utils.DefaultBoolean.True; gridView1.OptionsPrint.AutoWidth = false; // gridView1.AppearancePrint.HeaderPanel.Options.UseTextOptions = true; gridView1.AppearancePrint.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; gridView1.AppearancePrint.HeaderPanel.TextOptions.Trimming = DevExpress.Utils.Trimming.Word; gridView1.ColumnPanelRowHeight = 70; gridView1.AppearancePrint.EvenRow.Options.UseTextOptions = true; gridView1.AppearancePrint.EvenRow.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; gridView1.AppearancePrint.EvenRow.TextOptions.Trimming = DevExpress.Utils.Trimming.Word; // gridView1.AppearancePrint.OddRow.Options.UseTextOptions = true; gridView1.AppearancePrint.OddRow.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; gridView1.AppearancePrint.OddRow.TextOptions.Trimming = DevExpress.Utils.Trimming.Word; gridView1.OptionsPrint.AllowMultilineHeaders = true; gridView1.OptionsPrint.UsePrintStyles = true; foreach (GridColumn c in gridView1.Columns) { c.AppearanceCell.Options.UseTextOptions = true; c.AppearanceCell.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; } gridView1.OptionsView.RowAutoHeight = true; //gridView1.OptionsPrint.EnableAppearanceEvenRow = true; //gridView1.OptionsPrint.EnableAppearanceOddRow = true; gridView1.OptionsPrint.AllowMultilineHeaders = true; exportOptions.ExportType = ExportType.WYSIWYG; //exportOptions.ExportType = ExportType.DataAware; gc.ExportToXls(fileName, exportOptions); System.Diagnostics.Process.Start(fileName); } else { XlsxExportOptionsEx exportOptions = new XlsxExportOptionsEx(); //exportOptions.CustomizeSheetHeader += options_CustomizeSheetHeader; //exportOptions.TextExportMode = TextExportMode.Text; exportOptions.ShowTotalSummaries = DevExpress.Utils.DefaultBoolean.True; exportOptions.FitToPrintedPageWidth = false; exportOptions.AllowSortingAndFiltering = DevExpress.Utils.DefaultBoolean.True; exportOptions.ShowColumnHeaders = DevExpress.Utils.DefaultBoolean.True; exportOptions.ShowPageTitle = DevExpress.Utils.DefaultBoolean.True; gridView1.OptionsPrint.AutoWidth = false; // gridView1.AppearancePrint.HeaderPanel.Options.UseTextOptions = true; gridView1.AppearancePrint.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; gridView1.AppearancePrint.HeaderPanel.TextOptions.Trimming = DevExpress.Utils.Trimming.Word; gridView1.ColumnPanelRowHeight = 70; gridView1.AppearancePrint.EvenRow.Options.UseTextOptions = true; gridView1.AppearancePrint.EvenRow.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; gridView1.AppearancePrint.EvenRow.TextOptions.Trimming = DevExpress.Utils.Trimming.Word; // gridView1.AppearancePrint.OddRow.Options.UseTextOptions = true; gridView1.AppearancePrint.OddRow.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; gridView1.AppearancePrint.OddRow.TextOptions.Trimming = DevExpress.Utils.Trimming.Word; gridView1.OptionsPrint.AllowMultilineHeaders = true; gridView1.OptionsPrint.UsePrintStyles = true; foreach (GridColumn c in gridView1.Columns) { c.AppearanceCell.Options.UseTextOptions = true; c.AppearanceCell.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; } gridView1.OptionsView.RowAutoHeight = true; //gridView1.OptionsPrint.EnableAppearanceEvenRow = true; //gridView1.OptionsPrint.EnableAppearanceOddRow = true; gridView1.OptionsPrint.AllowMultilineHeaders = true; exportOptions.ExportType = ExportType.WYSIWYG; //exportOptions.ExportType = ExportType.DataAware; gc.ExportToXlsx(fileName, exportOptions); System.Diagnostics.Process.Start(fileName); } } } catch (Exception ex) { throw ex; } }
public ActionResult ExportTo(GridViewExportFormat?exportFormat, int stationId, /*DateTime datePck,*/ DateTime dFrom, DateTime dTo /*, string filterString*/) { string _stationName = (from tt in DB.Stations where tt.ID == stationId && tt.IS_DELETED == false select new { tt.NAME }).FirstOrDefault().NAME; if (exportFormat == null || !GridViewExportHelper.ExportFormatsInfo.ContainsKey(exportFormat.Value)) { return(RedirectToAction("InvDetailReportPartial", stationId)); } // DateTime dts = Convert.ToDateTime(datePck); DateTime date1 = Convert.ToDateTime(dFrom); DateTime date2 = Convert.ToDateTime(dTo); DateTime date1_ = date1.Date; DateTime date2_ = date2.Date; date2_ = date2_.AddHours(23); date2_ = date2_.AddMinutes(59); GridHelper gh = new GridHelper(stationId); var _TempInvOzet = (from x in DB.InvSums join inv in DB.Inverters on x.Inv_Id equals inv.ID where x.STATION_ID == stationId && date1_ <= x.Tarih.Value && date2_ >= x.Tarih.Value //&& //date2.Month >= x.Tarih.Value.Month //&& //date1.Month <= x.Tarih.Value.Month //&& //date2.Day >= x.Tarih.Value.Day //&& //date1.Day <= x.Tarih.Value.Day select new { x, inv.NAME }).OrderBy(X => X.x.Tarih.Value).ToList(); List <ExportEsso> ListExport = new List <ExportEsso>(); for (int i = 0; i < _TempInvOzet.Count; i++) { ExportEsso _cExportEsso = new ExportEsso(); _cExportEsso.Id = _TempInvOzet[i].x.Id; _cExportEsso.DATE = _TempInvOzet[i].x.Tarih.Value.ToString("dd/MM/yyyy HH:mm"); _cExportEsso.INV = _TempInvOzet[i].NAME; _cExportEsso.CRNT_AC = Convert.ToDecimal(_TempInvOzet[i].x.Akim_AC); _cExportEsso.CRNT_DC = Convert.ToDecimal(_TempInvOzet[i].x.Akim_DC); _cExportEsso.V_AC = Convert.ToDecimal(_TempInvOzet[i].x.Gerilim_AC); _cExportEsso.V_DC = Convert.ToDecimal(_TempInvOzet[i].x.Gerilim_DC); _cExportEsso.PWR_AC = Convert.ToDecimal(_TempInvOzet[i].x.Guc_AC); _cExportEsso.PWR_DC = Convert.ToDecimal(_TempInvOzet[i].x.Guc_DC); _cExportEsso.DAILY_YIELD = Convert.ToDecimal(_TempInvOzet[i].x.Gunluk_Enerji); _cExportEsso.TOTAL_YIELD = Convert.ToDecimal(_TempInvOzet[i].x.Toplam_Enerji); ListExport.Add(_cExportEsso); } if (exportFormat == GridViewExportFormat.Xls) { XlsExportOptionsEx exportOptions = new XlsExportOptionsEx(); exportOptions.CustomizeCell += new DevExpress.Export.CustomizeCellEventHandler(exportOptions_CustomizeCell); string filename = _stationName + " (" + date1.ToShortDateString() + " - " + date2.ToShortDateString() + ")"; return(GridViewExtension.ExportToXls(gh.GridStationSettings, ListExport, filename, exportOptions)); } else { return(GridViewExportHelper.ExportFormatsInfo[exportFormat.Value]( gh.GridStationSettings, ListExport)); } }