public void TestOneSeriePlot()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = new SheetBuilder(wb, plotData).Build();
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 1, 1, 10, 30);
IChart chart = Drawing.CreateChart(anchor);
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Bottom);
IChartAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
IScatterChartData <string, double> scatterChartData =
chart.ChartDataFactory.CreateScatterChartData <string, double>();
IChartDataSource <String> xs = DataSources.FromStringCellRange(sheet, CellRangeAddress.ValueOf("A1:J1"));
IChartDataSource <double> ys = DataSources.FromNumericCellRange(sheet, CellRangeAddress.ValueOf("A2:J2"));
IScatterChartSeries <string, double> series = scatterChartData.AddSeries(xs, ys);
Assert.IsNotNull(series);
Assert.AreEqual(1, scatterChartData.GetSeries().Count);
Assert.IsTrue(scatterChartData.GetSeries().Contains(series));
chart.Plot(scatterChartData, bottomAxis, leftAxis);
}
static void CreateChart(IDrawing drawing, ISheet sheet, IClientAnchor anchor, string serie1, string serie2)
{
IChart chart = drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.TopRight;
ILineChartData<double, double> data = chart.ChartDataFactory.CreateLineChartData<double, double>();
// Use a category axis for the bottom axis.
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = AxisCrosses.AutoZero;
IChartDataSource<double> xs = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
IChartDataSource<double> ys1 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
IChartDataSource<double> ys2 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1));
var s1 = data.AddSeries(xs, ys1);
s1.SetTitle(serie1);
var s2 = data.AddSeries(xs, ys2);
s2.SetTitle(serie2);
chart.Plot(data, bottomAxis, leftAxis);
}
private static void CreateChart(ISheet sheet, IDrawing drawing, IClientAnchor anchor, string serieTitle, int startDataRow, int endDataRow, int columnIndex)
{
XSSFChart chart = (XSSFChart)drawing.CreateChart(anchor);
IBarChartData <string, double> barChartData = chart.ChartDataFactory.CreateBarChartData <string, double>();
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.Bottom;
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
bottomAxis.MajorTickMark = AxisTickMark.None;
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = AxisCrosses.AutoZero;
leftAxis.SetCrossBetween(AxisCrossBetween.Between);
IChartDataSource <string> categoryAxis = DataSources.FromStringCellRange(sheet, new CellRangeAddress(startDataRow, endDataRow, 0, 0));
IChartDataSource <double> valueAxis = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(startDataRow, endDataRow, columnIndex, columnIndex));
var serie = barChartData.AddSeries(categoryAxis, valueAxis);
serie.SetTitle(serieTitle);
chart.Plot(barChartData, bottomAxis, leftAxis);
}
private void AddChart(IDrawing drawing, ISheet sheet, IClientAnchor anchor)
{
var chart = drawing.CreateChart(anchor);
var legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.Bottom;
var data = chart.ChartDataFactory.CreateLineChartData <string, double>();
var bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
var leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = AxisCrosses.AutoZero;
var row = sheet.CreateRow(0);
for (int i = 0; i < _errorList.Count; i++)
{
var cell = row.CreateCell(i);
cell.SetCellValue(_errorList[i]);
}
var xAxis = DataSources.FromStringCellRange(sheet, new CellRangeAddress(0, 0, 0, _errorList.Count - 1));
FillChartDataCells(sheet, 1, _dichotomyIterations, xAxis, data);
FillChartDataCells(sheet, 2, _goldenRatioIterations, xAxis, data);
FillChartDataCells(sheet, 3, _fibonacciIterations, xAxis, data);
FillChartDataCells(sheet, 4, _parabolaIterations, xAxis, data);
FillChartDataCells(sheet, 5, _brentIterations, xAxis, data);
chart.Plot(data, bottomAxis, leftAxis);
}
static void CreateChart(IDrawing drawing, ISheet sheet, IClientAnchor anchor, string serie1, string serie2, bool enableMajorGridline = false)
{
XSSFChart chart = (XSSFChart)drawing.CreateChart(anchor);
chart.SetTitle("Test 1");
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.TopRight;
ILineChartData <double, double> data = chart.ChartDataFactory.CreateLineChartData <double, double>();
// Use a category axis for the bottom axis.
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = AxisCrosses.AutoZero;
IChartDataSource <double> xs = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys1 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys2 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1));
var s1 = data.AddSeries(xs, ys1);
s1.SetTitle(serie1);
var s2 = data.AddSeries(xs, ys2);
s2.SetTitle(serie2);
chart.Plot(data, bottomAxis, leftAxis);
//add major gridline, available since NPOI 2.5.5
var plotArea = chart.GetCTChart().plotArea;
plotArea.catAx[0].AddNewMajorGridlines();
plotArea.valAx[0].AddNewMajorGridlines();
}
public void TestFormulaCache()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = new SheetBuilder(wb, plotData).Build();
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 1, 1, 10, 30);
IChart chart = Drawing.CreateChart(anchor);
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Bottom);
IChartAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
IScatterChartData scatterChartData =
chart.ChartDataFactory.CreateScatterChartData();
DataMarker xMarker = new DataMarker(sheet, CellRangeAddress.ValueOf("A1:E1"));
DataMarker yMarker = new DataMarker(sheet, CellRangeAddress.ValueOf("A2:E2"));
IScatterChartSerie serie = scatterChartData.AddSerie(xMarker, yMarker);
chart.Plot(scatterChartData, bottomAxis, leftAxis);
XSSFScatterChartData.Serie xssfScatterSerie =
(XSSFScatterChartData.Serie)serie;
XSSFNumberCache yCache = xssfScatterSerie.LastCalculatedYCache;
Assert.AreEqual(5, yCache.PointCount);
Assert.AreEqual(4.0, yCache.GetValueAt(3), 0.00001);
Assert.AreEqual(16.0, yCache.GetValueAt(5), 0.00001);
}
static void CreateChart(IDrawing drawing, ISheet sheet, IClientAnchor anchor, string serie1, string serie2)
{
IChart chart = drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.TopRight;
ILineChartData <double, double> data = chart.ChartDataFactory.CreateLineChartData <double, double>();
// Use a category axis for the bottom axis.
IChartAxis bottomAxis = chart.GetChartAxisFactory().CreateCategoryAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.GetChartAxisFactory().CreateValueAxis(AxisPosition.Left);
leftAxis.SetCrosses(AxisCrosses.AutoZero);
IChartDataSource <double> xs = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys1 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys2 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1));
var s1 = data.AddSeries(xs, ys1);
s1.SetTitle(serie1);
var s2 = data.AddSeries(xs, ys2);
s2.SetTitle(serie2);
chart.Plot(data, bottomAxis, leftAxis);
}
/// <summary>
/// 创建一个图表实例
/// </summary>
/// <param name="excelChart"></param>
/// <param name="sheet"></param>
private void CreateChart(NPOIExcelChart excelChart, ISheet sheet, int startRow, int endRow)
{
if (_excelType != NPOIExcelType.XLS)
{
throw new NotImplementedException("只支持.xls文件作图");
}
IDrawing drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = drawing.CreateAnchor(0, 0, 0, 0, 0, startRow, excelChart.Axis.Count, endRow);
XSSFChart chart = drawing.CreateChart(anchor) as XSSFChart;
chart.Title.String = excelChart.Title;
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.TopRight;
//坐标轴
var axis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
axis.IsVisible = true;
//值轴
var data = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
data.IsVisible = true;
data.Crosses = (AxisCrosses.AutoZero);
IChartDataSource <string> xs = DataSources.FromArray <string>(excelChart.Axis.ToArray());
switch (excelChart.ExcelChartType)
{
case NPOIExcelChartType.Bar:
var chartBarData = chart.ChartDataFactory.CreateBarChartData <string, double>();
foreach (var item in excelChart.Data)
{
var curData = DataSources.FromArray <double>(item.Value.ToArray());
var curSeries = chartBarData.AddSeries(xs, curData);
curSeries.SetTitle(item.Key);
}
chart.Plot(chartBarData, axis, data);
return;
case NPOIExcelChartType.Line:
var chartLineData = chart.ChartDataFactory.CreateLineChartData <string, double>();
foreach (var item in excelChart.Data)
{
var curData = DataSources.FromArray <double>(item.Value.ToArray());
var curSeries = chartLineData.AddSeries(xs, curData);
curSeries.SetTitle(item.Key);
}
chart.Plot(chartLineData, axis, data);
break;
default:
break;
}
}
static void Main(string[] args)
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet("linechart");
int NUM_OF_ROWS = 3;
int NUM_OF_COLUMNS = 10;
// Create a row and put some cells in it. Rows are 0 based.
IRow row;
ICell cell;
for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++)
{
row = sheet.CreateRow((short)rowIndex);
for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++)
{
cell = row.CreateCell((short)colIndex);
cell.SetCellValue(colIndex * (rowIndex + 1));
}
}
IDrawing drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = drawing.CreateAnchor(0, 0, 0, 0, 0, 5, 10, 15);
IChart chart = drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.TopRight;
ILineChartData <double, double> data = chart.GetChartDataFactory().CreateLineChartData <double, double>();
// Use a category axis for the bottom axis.
IChartAxis bottomAxis = chart.GetChartAxisFactory().CreateCategoryAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.GetChartAxisFactory().CreateValueAxis(AxisPosition.Left);
leftAxis.SetCrosses(AxisCrosses.AutoZero);
IChartDataSource <double> xs = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys1 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys2 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1));
var s1 = data.AddSerie(xs, ys1);
s1.SetTitle("title1");
var s2 = data.AddSerie(xs, ys2);
s2.SetTitle("title2");
chart.Plot(data, bottomAxis, leftAxis);
using (FileStream fs = File.Create("test.xlsx"))
{
wb.Write(fs);
}
}
public TestXSSFChartAxis()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet();
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 1, 1, 10, 30);
IChart chart = Drawing.CreateChart(anchor);
axis = chart.GetChartAxisFactory().CreateValueAxis(AxisPosition.Bottom);
}
public void GenaretionChart()
{
FileStream RfileStream = new FileStream("D:\\test.xlsx", FileMode.Open, FileAccess.Read);
//建立讀取資料的FileStream
XSSFWorkbook wb = new XSSFWorkbook(RfileStream);
//讀取檔案內的Workbook物件
ISheet Wsheet = wb.GetSheetAt(1);
//選擇圖表存放的sheet
ISheet Rsheet = wb.GetSheetAt(0);
//選擇資料來源的sheet
IDrawing drawing = Wsheet.CreateDrawingPatriarch();
//sheet產生drawing物件
IClientAnchor clientAnchor = drawing.CreateAnchor(0, 0, 0, 0, 0, 0, 5, 10);
//設定圖表位置
IChart chart = drawing.CreateChart(clientAnchor);
//產生chart物件
IChartLegend legend = chart.GetOrCreateLegend();
//還沒研究出這行在做甚麼
legend.Position = LegendPosition.TopRight;
ILineChartData <double, double> data = chart.ChartDataFactory.CreateLineChartData <double, double>();
//產生存放資料的物件(資料型態為double)
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
//設定X軸
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
//設定Y軸
bottomAxis.Crosses = AxisCrosses.AutoZero;
//設定X軸數值開始為0
leftAxis.Crosses = AxisCrosses.AutoZero;
//設定Y軸數值開始為0
IChartDataSource <double> xs = DataSources.FromNumericCellRange(Rsheet, new CellRangeAddress(0, 4, 0, 0));
//取得要讀取sheet的資料位置(CellRangeAddress(first_row,end_row, first_column, end_column))
//x軸資料
IChartDataSource <double> ys1 = DataSources.FromNumericCellRange(Rsheet, new CellRangeAddress(0, 4, 1, 1));
//第一條y軸資料
IChartDataSource <double> ys2 = DataSources.FromNumericCellRange(Rsheet, new CellRangeAddress(0, 4, 2, 2));
//第二條y軸資料
data.AddSeries(xs, ys1);
data.AddSeries(xs, ys2);
//加入到data
chart.Plot(data, bottomAxis, leftAxis);
//加入到chart
FileStream WfileStream = new FileStream("D:\\test.xlsx", FileMode.Create, FileAccess.Write);
//建立寫入資料的FileStream
wb.Write(WfileStream);
//將workbook寫入資料
RfileStream.Close();
//關閉FileStream
WfileStream.Close();
//關閉FileStream
}
private IManualLayout GetEmptyLayout()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet();
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 1, 1, 10, 30);
IChart chart = Drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
return(legend.GetManualLayout());
}
public void TestLegendPositionAccessMethods()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet();
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 1, 1, 10, 30);
IChart chart = Drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = LegendPosition.TopRight;
Assert.AreEqual(LegendPosition.TopRight, legend.Position);
}
public void Main()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet("Sheet 1");
int NUM_OF_ROWS = 3;
int NUM_OF_COLUMNS = 10;
// Create a row and put some cells in it. Rows are 0 based.
IRow row;
ICell cell;
for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++)
{
row = sheet.CreateRow((short)rowIndex);
for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++)
{
cell = row.CreateCell((short)colIndex);
cell.SetCellValue(colIndex * (rowIndex + 1));
}
}
IDrawing drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = drawing.CreateAnchor(0, 0, 0, 0, 0, 5, 10, 15);
IChart chart = drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = (LegendPosition.TopRight);
IScatterChartData <double, double> data = chart.ChartDataFactory.CreateScatterChartData <double, double>();
IValueAxis bottomAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = AxisCrosses.AutoZero;
IChartDataSource <double> xs = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys1 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys2 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1));
data.AddSeries(xs, ys1);
data.AddSeries(xs, ys2);
chart.Plot(data, bottomAxis, leftAxis);
// Write the output to a file
FileStream sw = File.Create("test.xlsx");
wb.Write(sw);
sw.Close();
}
public void Test_setOverlay_defaultChartLegend_expectOverlayInitialValueSetToFalse()
{
// Arrange
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet();
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 1, 1, 10, 30);
IChart chart = Drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
// Act
// Assert
Assert.IsFalse(legend.IsOverlay);
}
private IWorkbook CreateWorkbookWithChart()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet("linechart");
int NUM_OF_ROWS = 3;
int NUM_OF_COLUMNS = 10;
// Create a row and Put some cells in it. Rows are 0 based.
IRow row;
ICell cell;
for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++)
{
row = sheet.CreateRow((short)rowIndex);
for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++)
{
cell = row.CreateCell((short)colIndex);
cell.SetCellValue(colIndex * (rowIndex + 1));
}
}
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 0, 5, 10, 15);
IChart chart = Drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = (/*setter*/ LegendPosition.TopRight);
ILineChartData <double, double> data = chart.ChartDataFactory.CreateLineChartData <double, double>();
// Use a category axis for the bottom axis.
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = (/*setter*/ AxisCrosses.AutoZero);
IChartDataSource <double> xs = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys1 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys2 = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1));
data.AddSeries(xs, ys1);
data.AddSeries(xs, ys2);
chart.Plot(data, bottomAxis, leftAxis);
return(wb);
}
public void TestAccessMethods()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet();
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 1, 1, 10, 30);
IChart chart = Drawing.CreateChart(anchor);
IValueAxis axis = chart.GetChartAxisFactory().CreateValueAxis(AxisPosition.BOTTOM);
axis.SetCrossBetween(AxisCrossBetween.MIDPOINT_CATEGORY);
Assert.AreEqual(axis.GetCrossBetween(), AxisCrossBetween.MIDPOINT_CATEGORY);
axis.SetCrosses(AxisCrosses.AUTO_ZERO);
Assert.AreEqual(axis.GetCrosses(), AxisCrosses.AUTO_ZERO);
Assert.AreEqual(chart.GetAxis().Count, 1);
}
public void TestAccessMethods()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet();
IDrawing Drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor = Drawing.CreateAnchor(0, 0, 0, 0, 1, 1, 10, 30);
IChart chart = Drawing.CreateChart(anchor);
IValueAxis axis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Bottom);
axis.SetCrossBetween(AxisCrossBetween.MidpointCategory);
Assert.AreEqual(axis.GetCrossBetween(), AxisCrossBetween.MidpointCategory);
axis.Crosses = (AxisCrosses.AutoZero);
Assert.AreEqual(axis.Crosses, AxisCrosses.AutoZero);
Assert.AreEqual(chart.GetAxis().Count, 1);
}
public void Run()
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet("linechart");
IRow row;
ICell cell;
// line chart
for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++)
{
row = sheet.CreateRow((short)rowIndex);
for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++)
{
cell = row.CreateCell((short)colIndex);
cell.SetCellValue(colIndex * (rowIndex + 1));
}
}
IDrawing drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor1 = drawing.CreateAnchor(0, 0, 0, 0, 0, 5, 10, 15);
CreateChart(drawing, sheet, anchor1, "title1", "title2");
IClientAnchor anchor2 = drawing.CreateAnchor(0, 0, 0, 0, 0, 20, 10, 35);
CreateChart(drawing, sheet, anchor2, "s1", "s2");
// ScatterChart
ISheet sheet1 = wb.CreateSheet("ScatterChart");
for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++)
{
row = sheet1.CreateRow((short)rowIndex);
for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++)
{
cell = row.CreateCell((short)colIndex);
cell.SetCellValue(colIndex * (rowIndex + 1));
}
}
drawing = sheet1.CreateDrawingPatriarch();
IClientAnchor anchor = drawing.CreateAnchor(0, 0, 0, 0, 0, 5, 10, 15);
IChart chart = drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = (LegendPosition.TopRight);
IScatterChartData <double, double> data = chart.ChartDataFactory.CreateScatterChartData <double, double>();
IValueAxis bottomAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = AxisCrosses.AutoZero;
IChartDataSource <double> xs = DataSources.FromNumericCellRange(sheet1, new CellRangeAddress(0, 0, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys1 = DataSources.FromNumericCellRange(sheet1, new CellRangeAddress(1, 1, 0, NUM_OF_COLUMNS - 1));
IChartDataSource <double> ys2 = DataSources.FromNumericCellRange(sheet1, new CellRangeAddress(2, 2, 0, NUM_OF_COLUMNS - 1));
data.AddSeries(xs, ys1);
data.AddSeries(xs, ys2);
chart.Plot(data, bottomAxis, leftAxis);
using (FileStream fs = File.Create(@"C:\00.Dev\temp\ChartTest.xlsx"))
{
wb.Write(fs);
}
}
