First of all, Congratulations on building such a robust code base for manipulating Excel sheets with which we can create excels without the usual Microsoft Excel Automation headache.
We are evaluating Spire.XLS for a business need we have where utilization reports excels with charts are created for our clients. We use Line with Markers chart for this purpose.
As we were evaluating we noticed that there is slight difference in the chart that is drawn manually when compared to the chart drawn dynamically through Spire.XLS DLL. Please find attached screenshot.
The chart drawn dynamically has flashy colors and the lines are thin which isn't visually very pleasing.
How can we achieve a chart as in Second chart (Office Excel LineMarker Chart with Style2 - Note there are thick lines in the plot area). Is there any workaround for the same? Are there any Style settings through which we can achieve the same?
If yes it would serve our purpose.
The code used are as below
- Code: Select all
Workbook myWorkbook = new Workbook();
myWorkbook.LoadFromFile(filePath);
Worksheet mySheet = myWorkbook.Worksheets[0];
Chart myChart = mySheet.Charts.Add();
myChart.ChartType = ExcelChartType.LineMarkers;
myChart.DataRange = mySheet.Range["B4:N8"];
myChart.Height = 220;
myChart.Width = 750;
myChart.Left = 30;
myChart.Top = 220;
myChart.PlotArea.Fill.Visible = false;
myChart.Legend.Position = LegendPositionType.Right;
myWorkbook.SaveToFile(newFilePath);
Please enlighten us in this regard.
Awaiting your response at the earliest.
Thanks in advance.
Best Regards,
Pavan Kumar