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;
}
public static void HideFileTab(ASPxSpreadsheet spreadsheet)
{
spreadsheet.CreateDefaultRibbonTabs(true);
RemoveRibbonTab(spreadsheet.RibbonTabs, typeof(SRFileTab));
spreadsheet.ActiveTabIndex = 0;
}
