public FrmReportRenderService() { var cellsFactory = new CellsFactory(); _headerStyle = cellsFactory.CreateStyle(); _tableTitleStyle = cellsFactory.CreateStyle(); _tableHeaderStyle = cellsFactory.CreateStyle(); _tableTotalStyle = cellsFactory.CreateStyle(); _tableRowStyle = cellsFactory.CreateStyle(); ConfigureStyles(); }
protected FrmBaseRenderService(string reportId) { _reportID = reportId; var cellsFactory = new CellsFactory(); _defaultStyle = cellsFactory.CreateStyle(); _dateTimeStyle = cellsFactory.CreateStyle(); ConfigureStyles(); }
private void saveExcel_FileOk(object sender, System.ComponentModel.CancelEventArgs e) { string name = saveExcel.FileName; // Get JSON text JObject obj = JObject.Parse(jsonContainer.Text); obj.AddFirst(new JProperty("name", rootName)); string jsonString = "[" + obj.ToString() + "]"; // Create a Workbook object Workbook workbook = new Workbook(); Worksheet worksheet = workbook.Worksheets[0]; // Set Styles CellsFactory factory = new CellsFactory(); Style style = factory.CreateStyle(); style.HorizontalAlignment = TextAlignmentType.Center; style.Font.Color = System.Drawing.Color.BlueViolet; style.Font.IsBold = true; // Set JsonLayoutOptions JsonLayoutOptions options = new JsonLayoutOptions(); options.ConvertNumericOrDate = true; options.TitleStyle = style; options.ArrayAsTable = true; // Import JSON Data JsonUtility.ImportData(jsonString, worksheet.Cells, 0, 0, options); // Save Excel file workbook.Save(@name); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Instantiating a Workbook object Workbook workbook = new Workbook(); Worksheet worksheet = workbook.Worksheets[0]; // Read File string jsonInput = File.ReadAllText(dataDir + "Test.json"); // Set Styles CellsFactory factory = new CellsFactory(); Style style = factory.CreateStyle(); style.HorizontalAlignment = TextAlignmentType.Center; style.Font.Color = System.Drawing.Color.BlueViolet; style.Font.IsBold = true; // Set JsonLayoutOptions JsonLayoutOptions options = new JsonLayoutOptions(); options.TitleStyle = style; options.ArrayAsTable = true; // Import JSON Data JsonUtility.ImportData(jsonInput, worksheet.Cells, 0, 0, options); // Save Excel file workbook.Save(dataDir + "ImportingFromJson.out.xlsx"); // ExEnd:1 }
public FundingSummaryRenderService() { var cellsFactory = new CellsFactory(); _defaultStyle = cellsFactory.CreateStyle(); _textWrappedStyle = cellsFactory.CreateStyle(); _futureMonthStyle = cellsFactory.CreateStyle(); _fundingCategoryStyle = cellsFactory.CreateStyle(); _fundingSubCategoryStyle = cellsFactory.CreateStyle(); _fundLineGroupStyle = cellsFactory.CreateStyle(); _headerAndFooterStyle = cellsFactory.CreateStyle(); ConfigureStyles(); }
public DevolvedAdultEducationFundingSummaryReportRenderService() { var cellsFactory = new CellsFactory(); _defaultStyle = cellsFactory.CreateStyle(); _futureMonthStyle = cellsFactory.CreateStyle(); _fundingCategoryStyle = cellsFactory.CreateStyle(); _fundingSubCategoryStyle = cellsFactory.CreateStyle(); _fundLineGroupStyle = cellsFactory.CreateStyle(); _headerStyle = cellsFactory.CreateStyle(); _footerStyle = cellsFactory.CreateStyle(); ConfigureStyles(); }
public FundingSummaryReportRenderService() { var cellsFactory = new CellsFactory(); _defaultStyle = cellsFactory.CreateStyle(); _reportTitleStyle = cellsFactory.CreateStyle(); _deliverableGroupStyle = cellsFactory.CreateStyle(); _deliverableSubGroupStyle = cellsFactory.CreateStyle(); _deliverableLineStyle = cellsFactory.CreateStyle(); _headerAndFooterStyle = cellsFactory.CreateStyle(); _reportMonthlyTotalsStyle = cellsFactory.CreateStyle(); ConfigureStyles(); }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create a Style object using CellsFactory class CellsFactory cf = new CellsFactory(); Style st = cf.CreateStyle(); // Set the Style fill color to Yellow st.Pattern = BackgroundType.Solid; st.ForegroundColor = Color.Yellow; // Create a workbook and set its default style using the created Style object Workbook wb = new Workbook(); wb.DefaultStyle = st; // Save the workbook wb.Save(dataDir + "output_out.xlsx"); // ExEnd:1 }
public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create a Style object using CellsFactory class CellsFactory cf = new CellsFactory(); Style st = cf.CreateStyle(); // Set the Style fill color to Yellow st.Pattern = BackgroundType.Solid; st.ForegroundColor = Color.Yellow; // Create a workbook and set its default style using the created Style object Workbook wb = new Workbook(); wb.DefaultStyle = st; // Save the workbook wb.Save(dataDir + "output_out.xlsx"); // ExEnd:1 }
public static void Run() { //Output directory string outputDir = RunExamples.Get_OutputDirectory(); // Create a Style object using CellsFactory class CellsFactory cf = new CellsFactory(); Style st = cf.CreateStyle(); // Set the Style fill color to Yellow st.Pattern = BackgroundType.Solid; st.ForegroundColor = Color.Yellow; // Create a workbook and set its default style using the created Style object Workbook wb = new Workbook(); wb.DefaultStyle = st; // Save the workbook wb.Save(outputDir + "outputUsingCellsFactory.xlsx"); Console.WriteLine("UsingCellsFactory executed successfully."); }