![]() ![]() MS Office tools such as Word, Excel, PowerPoint, etc. Published MaA Comparison between IronXL and Microsoft Office Interop Excel Yet there is no possibility to remove chart or edit it's series/position. Multiple call of this method leads to plotting multiple charts instead of modifying the existing chart. Plot all the data that was added to the chart before. We can change the position of the chart.Ĭ = + 3 Var series = chart.AddSeries("B3:B8", "A3:A8") Ĭhart.SetLegendPosition(LegendPosition.Bottom) The second parameter represents the address of the range for vertical(value) axis. The first parameter represents the address of the range for horizontal(category) axis. Var chart = workSheet.CreateChart(ChartType.Line, 10, 10, 18, 20) Set the chart type and it's position on the worksheet. WorkBook workBook = WorkBook.Load("test.xlsx") Set the number of spaces to intend the text FillPattern enum indicates the style of fill pattern DiagonalBorderDirection enum stands for direction of diagonal border inside cell Define border type and border direction as well Indicate whether the cell should be auto-sized BorderType enum indicates the line style of a border in a cell There are also TopBorder,LeftBorder,RightBorder,DiagonalBorder properties Font script enum stands for available options Define whether the font is italic or not Define whether the font is bold or not Define whether to use horizontal line through the text or not ![]() FontUnderlineType is enum that stands for different types of font underlying Set background color of the cell with an rgb stringĬ("#428D65") ![]() WorkBook workBook = WorkBook.Load("sample.xls") WorkBook.SaveAs("appl圜onditionalFormatting.xlsx") Var rule1 = (ComparisonOperator.Between, "7", "10") Var rule = (ComparisonOperator.LessThan, "8") WorkSheet workSheet = workBook.DefaultWorkSheet WorkBook workBook = WorkBook.Load("sample.xlsx")
0 Comments
Leave a Reply. |