public override void Process(iExcel owner, ref Workbook book, ref Worksheet sheet) { try { if (book != null && !string.IsNullOrEmpty(Title)) { sheet = new Worksheet(Title); //sheet.PageSetup.PrintRepeatRows = 2; //sheet.PageSetup.PrintRepeatColumns = 2; if (Style != null) { if (Style["Orientation"] != null) { if (((string)Style["Orientation"]).ToLower() == "landscape") { sheet.PageSetup.Orientation = Orientation.Landscape; } else if (((string)Style["Orientation"]).ToLower() == "portrait") { sheet.PageSetup.Orientation = Orientation.Portrait; } } } book.Add(sheet); } } catch (Exception ex) { Log.Trace(ex.Message, ex.StackTrace); } }
protected override bool ProcessRequest(CefRequest request, CefCallback callback) { Task task = new Task(() => { try { //var serializer = new JavaScriptSerializer(); //serializer.MaxJsonLength = Int32.MaxValue; //serializer.RegisterConverters(new[] { new DynamicJsonConverter() }); var excel = new iExcel(configuration.Application, Environment.CurrentDirectory, JsonMapper.ToObject <object>(excelString)); var excelBytes = Data = iExcel.CreateExcel(excel); var dir = Environment.CurrentDirectory + "\\Web\\" + configuration.Application + "\\reports"; if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } var dt = DateTime.Now.ToString("yyyyMMddHmmssfff"); var file = excel.Properties.Title.Replace(" ", "_") + "_" + dt + "_" + excel.Properties.Items + ".xlsx"; var path = dir + "\\" + file; File.WriteAllBytes(path, excelBytes); var echo = JsonMapper.ToJson(new FileHelper("OK", "reports/" + file, excel.Properties.Title, excel.Properties.Items)); Data = Encoding.UTF8.GetBytes(echo); } catch (Exception ex) { Log.Trace(ex.Message, ex.StackTrace); var echo = JsonMapper.ToJson(new ErrorHelper(ex.Message, ex.StackTrace)); Data = Encoding.UTF8.GetBytes(echo); } callback.Continue(); }); task.Start(); return(true); }
public virtual void Process(iExcel owner, ref Workbook book, ref Worksheet sheet) { }
public override void Process(iExcel owner, ref Workbook book, ref Worksheet sheet) { try { if (sheet != null && Content != null && X > -1 && Y > -1) { sheet.Cells[X, Y].Value = Content.ToString(); if (Content.IsNumber()) { sheet.Cells[X, Y].Format = BuiltInCellFormat.NumberNoDecimalPlaces; } else { sheet.Cells[X, Y].Format = BuiltInCellFormat.Text; } if (Style != null) { try { if (Style["FontName"] != null) { sheet.Cells[X, Y].FontName = (string)Style["FontName"]; } } catch { } try { if (Style["Bold"] != null) { sheet.Cells[X, Y].Bold = (bool)Style["Bold"]; } } catch { } try { if (Style["FontSize"] != null) { sheet.Cells[X, Y].FontSize = (int)Style["Bold"]; } } catch { } try { if (Style["Format"] != null) { sheet.Cells[X, Y].Format = (string)Style["Format"]; } } catch { } try { if (Style["Hyperlink"] != null) { sheet.Cells[X, Y].Hyperlink = (string)Style["Hyperlink"]; } } catch { } try { if (Style["Italic"] != null) { sheet.Cells[X, Y].Italic = (bool)Style["Italic"]; } } catch { } try { if (Style["Underline"] != null) { sheet.Cells[X, Y].Underline = (bool)Style["Underline"]; } } catch { } try { if (Style["TextColor"] != null) { var col = System.Drawing.ColorTranslator.FromHtml((string)Style["TextColor"]); sheet.Cells[X, Y].TextColor = col; // Simplexcel.Color.FromArgb(col.A, col.R, col.G, col.B); } } catch { } } } } catch (Exception ex) { Log.Trace(ex.Message, ex.StackTrace); } }