public static SpreadsheetSettings GetSpreadsheetSettings() { SpreadsheetSettings settings = new SpreadsheetSettings(); settings.Name = "SpreadsheetName"; settings.CallbackRouteValues = new { Controller = "Home", Action = "SpreadsheetPartial" }; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); settings.Height = 500; settings.Saving = (s, e) => { byte[] docBytes = SpreadsheetExtension.SaveCopy("SpreadsheetName", DocumentFormat.Xlsx); DataHelper.SaveDocument(docBytes); e.Handled = true; }; return(settings); }
/// ----------------------------------------------------------------------------------- /// <summary> /// Get spreadsheet details from the user /// </summary> /// ----------------------------------------------------------------------------------- public override bool HandlePreScan(Seed seed) { _spreadSheetModel = new SpreadSheetModel(seed.Id); var chooser = new ColumnChooser(_spreadSheetModel); var settings = SettingsHandler.GetSettings <SpreadsheetSettings>("SpreadSheetHandler"); if (settings == null) { settings = new SpreadsheetSettings(); } if (_spreadSheetModel.ColumnNames.Contains(settings.PathColumn)) { _spreadSheetModel.SelectedPathColumn = _spreadSheetModel.GetColumnIndex(settings.PathColumn); } if (settings.SizeColumn != null) { _spreadSheetModel.SizeColumn = settings.SizeColumn; } if (settings.DoubleClickTemplate != null) { _spreadSheetModel.DoubleClickTemplate = settings.DoubleClickTemplate; } if (chooser.ShowDialog().Value) { var pathColumn = _spreadSheetModel.ColumnNames[_spreadSheetModel.SelectedPathColumn]; _columnInfo = ColumnInfo.CreateFromFixedColumns(_spreadSheetModel.ColumnNames, _spreadSheetModel.ValueColumns, pathColumn); SizeColumn = _spreadSheetModel.SizeColumn; settings.PathColumn = pathColumn; settings.SizeColumn = _spreadSheetModel.SizeColumn; settings.DoubleClickTemplate = _spreadSheetModel.DoubleClickTemplate; SettingsHandler.SaveSettings("SpreadSheetHandler", settings); return(true); } return(false); }