private Guid OpenDocumentID(string documentID) { var unitOfWork = new DocumentsUnitOfWork(); var documentItem = unitOfWork.ItemRepository.GetByID(long.Parse(documentID)); var documentItemInfo = new DocumentItemInfo(documentItem); var editorType = documentItemInfo.DocumentProcessorType; OfficeWorkSessionControl editor = null; if (editorType == OfficeDocumentProcessorType.Spreadsheet) { var spreadsheetControl = new ASPxSpreadsheet(); spreadsheetControl.Open( documentItemInfo.Id, (DevExpress.Spreadsheet.DocumentFormat)DocumentFormatUtils.GetDocumentFormat(documentItemInfo.NameExtension), () => documentItem.Content.Data); editor = spreadsheetControl; } if (editorType == OfficeDocumentProcessorType.RichEdit) { var richEditControl = new ASPxRichEdit(); richEditControl.Open( documentItemInfo.Id, (DevExpress.XtraRichEdit.DocumentFormat)DocumentFormatUtils.GetDocumentFormat(documentItemInfo.NameExtension), () => documentItem.Content.Data); editor = richEditControl; } return(editor.GetWorkSessionID()); }
private void OpenExcelFile(string fileFullPath) { ASPxSpreadsheet spreadsheet = new ASPxSpreadsheet(); spreadsheet.ID = "spreadsheet"; ASPxPopupControl1.Controls.Add(spreadsheet); spreadsheet.Open(fileFullPath); }
protected override void Dispose(bool disposing) { if (disposing) { _spreadsheet = null; } base.Dispose(disposing); }
protected override WebControl CreateEditModeControlCore() { this._spreadsheet = new ASPxSpreadsheet(); _spreadsheet.SettingsDocumentSelector.UploadSettings.Enabled = true; _spreadsheet.SettingsDocumentSelector.UploadSettings.UseAdvancedUploadMode = true; _spreadsheet.SettingsDocumentSelector.UploadSettings.AdvancedModeSettings.EnableFileList = true; _spreadsheet.SettingsDocumentSelector.UploadSettings.AdvancedModeSettings.EnableMultiSelect = true; _spreadsheet.SettingsDocumentSelector.UploadSettings.AutoStartUpload = true; //初始目录:当前登陆用户+当天日期 var dir = "~/ExcelFiles/" + SecuritySystem.CurrentUserName + "/" + DateTime.Now.ToString("yyyyMMdd"); _spreadsheet.WorkDirectory = dir; _spreadsheet.ShowConfirmOnLosingChanges = false; _spreadsheet.ClientSideEvents.Init = "function(s, e){ s.SetFullscreenMode(true); }"; _spreadsheet.Height = 800; _spreadsheet.CreateDefaultRibbonTabs(true); _spreadsheet.ActiveTabIndex = 0;//默认标签行这个可以打开的时候默认第一个导入的标签 //_spreadsheet.ClientSideEvents.CustomCommandExecuted if (IsNewStyle) { _spreadsheet.ClientSideEvents.Init = "function(s, e){ s.SetFullscreenMode(false); }"; _spreadsheet.Theme = "Aqua"; } _spreadsheet.Load += (s, e) => { var handlerid = _spreadsheet.UniqueID + "StartImport"; var page = _spreadsheet.Page as ICallbackManagerHolder; page.CallbackManager.RegisterHandler(handlerid, this); var doAction = page.CallbackManager.GetScript(handlerid, "null"); _spreadsheet.ClientSideEvents.CustomCommandExecuted = "function(s,e) { " + doAction + " }"; }; var t = _spreadsheet.RibbonTabs[0]; var g = t.Groups.Add("导入"); //_spreadsheet.Document var temp = new RibbonButtonItem("ImportData", "导入数据", RibbonItemSize.Large); temp.LargeImage.Url = "~/Images/ImportData_32x32.png"; //new RibbonTemplateItem(); g.Items.Add(temp); //StartImport = new StartImportTemplate(_spreadsheet, this._objectSpace, this._application); //temp.Template = StartImport; importer.InitializeExcelSheet(_spreadsheet.Document, this.option); //_spreadsheet.d return(_spreadsheet); }
public static void HideFileTab(ASPxSpreadsheet spreadsheet) { spreadsheet.CreateDefaultRibbonTabs(true); spreadsheet.RibbonTabs.RemoveAt(0); SRFileCommonGroup gr = new SRFileCommonGroup(); gr.Items.Add(new SRFileSaveCommand()); gr.Items.Add(new SRFilePrintCommand()); spreadsheet.RibbonTabs[0].Groups.Insert(0, gr); spreadsheet.ActiveTabIndex = 0; }
protected void ASPxSpreadsheet1_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e) { ASPxSpreadsheet spreadSheet = (ASPxSpreadsheet)sender; Margins margins = spreadSheet.Document.Worksheets[0].ActiveView.Margins; spreadSheet.Document.Unit = DocumentUnit.Inch; margins.Top = (float)speTop.Number; margins.Bottom = (float)speBottom.Number; margins.Left = (float)speLeft.Number; margins.Right = (float)speRight.Number; }
protected void ASPxSpreadsheet1_Saving(object source, DocumentSavingEventArgs e) { ASPxSpreadsheet sh = source as ASPxSpreadsheet; try { // SqlDataSource1.Update(); // uncomment to update the data source sh.JSProperties["cpSavingResult"] = "OK"; } catch (Exception ex) { sh.JSProperties["cpSavingResult"] = "ERROR"; } e.Handled = true; }
protected void ASPxSpreadsheet1_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e) { ASPxSpreadsheet spreadSheet = sender as ASPxSpreadsheet; IWorkbook workbook = spreadSheet.Document; Worksheet worksheet = workbook.Worksheets[0]; switch (e.Parameter) { case "applyFormatting": CellRange priceRange = worksheet.Range["C2:C15"]; Formatting rangeFormatting = priceRange.BeginUpdateFormatting(); rangeFormatting.Font.Color = Color.SandyBrown; rangeFormatting.Font.FontStyle = SpreadsheetFontStyle.Bold; rangeFormatting.Fill.BackgroundColor = Color.PaleGoldenrod; rangeFormatting.NumberFormat = "$0.0#"; rangeFormatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center; rangeFormatting.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center; priceRange.EndUpdateFormatting(rangeFormatting); break; case "insertLink": worksheet.Columns["G"].WidthInPixels = 180; CellRange cell1 = worksheet.Cells["G4"]; cell1.Fill.BackgroundColor = Color.WhiteSmoke; worksheet.Hyperlinks.Add(cell1, "https://documentation.devexpress.com/OfficeFileAPI/14912/Spreadsheet-Document-API", true, "Spreadsheet Document API"); break; case "drawBorders": CellRange tableRange = worksheet.Range["A2:E16"]; tableRange.Borders.SetAllBorders(Color.RosyBrown, BorderLineStyle.Hair); break; case "showTotal": CellRange cell2 = worksheet.Cells["E16"]; cell2.Formula = "=SUBTOTAL(9,E2:E15)"; CellRange cell3 = worksheet.Cells["A16"]; cell3.Formula = "SUBTOTAL(103,A2:A15)"; CellRange cell4 = worksheet.Cells["D16"]; cell4.Value = "Total amount"; break; } }
public static void HideFileTab(ASPxSpreadsheet spreadsheet) { spreadsheet.CreateDefaultRibbonTabs(true); RemoveRibbonTab(spreadsheet.RibbonTabs, typeof(SRFileTab)); spreadsheet.ActiveTabIndex = 0; }
protected void btnDownloadExistingFile_Command(object sender, CommandEventArgs e) { ASPxSpreadsheet.Visible = false; if (e.CommandName == "DownloadExistingFile") { string filename = e.CommandArgument.ToString(); if (File.Exists(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + filename))) { LogDownload(filename); DownloadFile(filename); } else { string result = "Sorry, the file [" + filename + "] was not found."; ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + result + "');", true); } } else if (e.CommandName == "LoadXLSX") { string filename = e.CommandArgument.ToString(); if (File.Exists(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + filename))) { ASPxSpreadsheet.Open(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + filename)); ASPxSpreadsheet.Visible = true; } else { string result = "Sorry, the file [" + filename + "] was not found."; ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + result + "');", true); } } else if (e.CommandName == "DownloadExistingFile_xls") { string filename = e.CommandArgument.ToString().Replace(".xlsx", ".xls"); if (File.Exists(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + filename))) { LogDownload(filename); DownloadFile(filename); } else { if (File.Exists(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + e.CommandArgument.ToString()))) { //convert to .xls here try { SpreadsheetGearUtils.Save_xls_from_xlsx(e.CommandArgument.ToString()); LogDownload(filename); DownloadFile(filename); } catch (Exception ex) { string x = ex.Message; string result = "Sorry, the file [" + filename + "] was not found. We have tried to create it but an error occurred."; ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + result + "');", true); } } else { string result = "Sorry, the file [" + filename + "] was not found."; ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + result + "');", true); } } } else if (e.CommandName == "ViewSummary") { string filename = e.CommandArgument.ToString(); string pageurl = "DataProjectStats.aspx"; pageurl += "?filename=" + e.CommandArgument.ToString() + "&pk=" + Request.QueryString["pk"]; Response.Redirect(pageurl); } }
public StartImportTemplate(ASPxSpreadsheet spreadSheet) { _spreadSheet = spreadSheet; }
public StartImportTemplate(ASPxSpreadsheet spreadSheet, IObjectSpace os, XafApplication xaf) { _spreadSheet = spreadSheet; this._application = xaf; objectSpace = os; }