Most important limitations

Aspose.Cells Product Family
1

One of our clients asked for a web application that is capable to generate PPT files, based on a couple of templates we or the client provide.

I would like to have a honest list of the most important limitations of Aspose.Cells. I'm very sure we can convince the client to live with these limitations (the main purpose of the tool we have to create is to avoid people using silly animations, exploding text, etc.).

Thanks in advance.

2

Hi,

Thanks for considering Aspose.

Well, It will not be a bad idea if you could describe the list of features you want to expect with our product.

For the complete list of features of Aspose.Cells, Kindly check:

you may also check our wiki docs:

There are some limitations while converting Excel file to Pdf format. Kindly check:

There are certain features like Chart 2 image and working with a few drawing objects are under process.

Thank you.

3

What our client basically wants is the following:

- The user selects a template we created (I work for a communication agency). This template can be completely fixed (e.g. 5 slides that describe a product they sell) or partially open (e.g. the layout is fixed but the user can add some additional slides).

- Depending on the selected template, the user has to enter a slide title, body text, add a picture, etc. It's in a first stage not intended for real advanced things like adding charts for example, but this may come in the future.

- A part of the information in the slide may already be filled out automatically by other applications we made for them. This will mainly be the case for PPTs that describe a certain product or product range.

- After filling out their details, a PPT should be generated. Ideally, a PowerPoint Projector File (PPS? I don't remember the correct extension) should be generated as well.

- The main goal is to preserve their corporate identity guidelines. So the user should not be able to alter the font, colours, brand logo, and so on.

4

Hi,

Well, Aspose.Cells is a spreadsheet managment component.

I think for you scenario, you should contact to our Aspose.Slides forum. This product is related to the management of Powerpoint presentations or slides etc.

Thank you.

5

I'm very sorry, I posted this in the wrong forum ...

Can someone please transfer my post to the .slides one?

6

Hi,

Please send your post at:

http://www.aspose.com/Community/forums/109/ShowForum.aspx

Thank you.

7

@MaartenBE,

Aspose.Cells supported to convert the Excel Charts to images and PDF formats without requiring any additional tools or applications. The feature has now become more enhanced and robust. In order to provide rendering support, the Chart class has exposed ToImage & ToPdf methods with a verity of overloads to best suit the application requirements.

See the following sample code for your reference:
e.g
Sample code:

// Instantiating a Workbook object
Workbook workbook = new Workbook();
// Adding a new worksheet to the Workbook
int sheetIndex = workbook.Worksheets.Add();
// Obtaining the reference of the newly added worksheet by passing its index to WorksheetCollection
Worksheet worksheet = workbook.Worksheets[sheetIndex];

// Adding sample values to cells
worksheet.Cells["A1"].PutValue(50);
worksheet.Cells["A2"].PutValue(100);
worksheet.Cells["A3"].PutValue(150);
worksheet.Cells["B1"].PutValue(4);
worksheet.Cells["B2"].PutValue(20);
worksheet.Cells["B3"].PutValue(50);

// Adding a chart to the worksheet
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5);
// Accessing the instance of the newly added chart
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex];
// Adding Series Collection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.NSeries.Add("A1:B3", true);

// Create an instance of ImageOrPrintOptions and set a few properties
ImageOrPrintOptions options = new ImageOrPrintOptions()
{
    VerticalResolution = 300,
    HorizontalResolution = 300,
    SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.AntiAlias
};
// Convert chart to image with additional settings
chart.ToImage("chartPNG_out.png", options);

See the document for your further reference:

You may also download the up-to-date examples/demos here.