当单元格值在0.001至9.999(小数)范围内时,C#NPOI将折线图绘制到Excel
我可以在单元格值相似(0、1、2,... 9)或其他整数值时绘制图表,但是当我尝试使用(0,293或其他小数位数)时我看到错误:
“已删除的部分:/xl/drawings/drawing1.xml部分。(图形)”(打开Excel文件时)。
我尝试在google和github中搜索搜索解决方案,但未发现类似情况。 也许有人面对这个问题。
感谢您的帮助。
已更新添加了报告文件 Good report Repot with error message
**添加了解释问题的代码:**
class Program
{
const int NUM_OF_ROWS = 3;
const int NUM_OF_COLUMNS = 10;
static void CreateChart(IDrawing drawing,ISheet sheet,IClientAnchor anchor)
{
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);
IChartDataSource<double> xs = DataSources.FromNumericCellRange(sheet,new CellRangeAddress(0,NUM_OF_COLUMNS - 1));
IChartDataSource<double> ys1 = DataSources.FromNumericCellRange(sheet,new CellRangeAddress(1,1,NUM_OF_COLUMNS - 1));
data.AddSeries(xs,ys1);
chart.Plot(data,bottomAxis,leftAxis);
}
static void Main(string[] args)
{
IWorkbook wb = new XSSFWorkbook();
ISheet sheet = wb.CreateSheet("linechart");
// 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);
//This generate graph
//cell.SetCellValue(colIndex * (rowIndex + 1));
//This make error when open Excel file
cell.SetCellValue(colIndex * (rowIndex + 1) + 0.1);
}
}
IDrawing drawing = sheet.CreateDrawingPatriarch();
IClientAnchor anchor1 = drawing.CreateAnchor(0,5,10,8);
CreateChart(drawing,sheet,anchor1);
//Write to Excel file
using (FileStream fs =File.Create("test1.xlsx"))
{
wb.Write(fs);
}
}
}