Feature Questions - Aspose Excel

Aspose.Cells Product Family
1

Hi,
I appreciate your answer to the following questions:

1) Is there any limitation in your software to read and edit an existing MS Excel spreadsheet?

2) Is it a correct assumption that after reading an MS Excel spreadsheet, the software can edit, add/delete columns and rows, and generic charts (including Pareto charts)?

3) Is your Pareto chart customizable?

Thanks,
Sathish.

2

Dear Sathish,

Thanks for your consideration.

1)Aspose.Excel supports most of features in MS Excel. Please refer to here.
Aspose.Excel can read and edit an existing MS Excel spreadsheet.

2) Yes. Aspose.Excel supports the features to edit, add/delete columns and rows, and generic charts.

3) I don’t know you need which kind of Pareto charts. I cannot find if MS Excel directly supports Pareto charts. Aspose.Excel supports all the charts in MS Excel and can customize them.

3

@sathish,
We have discontinued Aspose.Excel and introduced new product Aspose.Cells which is much more advanced and feature-rich product. It supports all the features of the latest versions of MS Excel including reading/writing to Excel file and creating Pareto chart as well. Give a try to the following sample code which generates Pareto chart.

Workbook workbook = new Workbook();
int index = workbook.Worksheets.Add();
Worksheet worksheet = workbook.Worksheets[index];
worksheet.Cells[0, 0].PutValue("Defect Case");
worksheet.Cells[0, 1].PutValue("Qty");
worksheet.Cells[1, 0].PutValue("Cut not straight");
worksheet.Cells[1, 1].PutValue(9);
worksheet.Cells[2, 0].PutValue("No defect found");
worksheet.Cells[2, 1].PutValue(7);
worksheet.Cells[3, 0].PutValue("Product not made by FLC");
worksheet.Cells[3, 1].PutValue(3);
worksheet.Cells[4, 0].PutValue("Sample lost");
worksheet.Cells[4, 1].PutValue(3);
worksheet.Cells[5, 0].PutValue("Incorrect hose cut length");
worksheet.Cells[5, 1].PutValue(3);
worksheet.Cells[6, 0].PutValue("Mechanical failure");
worksheet.Cells[6, 1].PutValue(2);
worksheet.Cells[7, 0].PutValue("Missing quantity");
worksheet.Cells[7, 1].PutValue(1);
worksheet.Cells[8, 0].PutValue("Accessories");
worksheet.Cells[8, 1].PutValue(1);
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.ParetoLine, 5, 0, 40, 19);
string dataArea = "B2: B9";
string categoryArea = "A2: A9";
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex];
chart.NSeries.Add(dataArea, true);
chart.PlotArea.BackgroundMode = Aspose.Cells.Charts.BackgroundMode.Transparent;
chart.PlotArea.Area.ForegroundColor = Color.Transparent;
chart.ChartArea.Area.ForegroundColor = Color.FromArgb(242, 242, 242);
chart.ChartArea.BackgroundMode = Aspose.Cells.Charts.BackgroundMode.Automatic;
chart.ChartArea.Font.Color = Color.DarkBlue;
chart.CategoryAxis.CategoryType = Aspose.Cells.Charts.CategoryType.AutomaticScale;
chart.CategoryAxis.TickLabelSpacing = 60;
chart.NSeries.CategoryData = categoryArea;
chart.NSeries[0].Name = "= B1";
chart.ShowLegend = false;
workbook.Save(path + "prova.xlsx", SaveFormat.Xlsx);

For more information on opening different versions of Excel files, please follow the link below:
Charts

Download the latest version of Aspose.Cells for .NET from the following link:
Aspose.Cells for .NET (Latest Version)

You can download the latest demos here.