Does your product read xl files as well?

Aspose.Cells Product Family
1

Does your product read xl files as well?

eg I need to get all the shapes and text (with formatting) from every
worksheet.

cheers
Rob

2

Dear Rob,

Thanks for your consideration.

The answser is yes. Aspose.Excel can import excel file and let you manipulate them as your wish. Please download setup msi and hotfix.

You can have a try for our product.

3

I’ve looked over the documentation but haven’t found how to read the shapes collection ie rectangles, lines etc of an existing worksheet. How is this done?

4

Hi Rob,

Currently Aspose.Excel doesn’t supply APIs to read shapes but it can import all shape from your designer file(template) and write them to your result file.

5

@rlorimer,
Aspose.Cells has replaced the older product Aspose.Excel. This new product supports all the latest features of MS Excel. You can manage shapes using this new product. Following is an example where shapes are retrieved from the worksheet.

//Load the sample smart art shape - Excel file
Workbook wb = new Workbook("sampleSmartArtShape.xlsx");

//Access first worksheet
Worksheet ws = wb.Worksheets[0];

//Access first shape
Shape sh = ws.Shapes[0];

//Determine if shape is smart art
Console.WriteLine("Is Smart Art Shape: " + sh.IsSmartArt);

We have a detailed section for managing the drawing objects in Excel files. You may visit the following link for a variety of features for working with pictures, shapes, OleObjects and many more.
Drawing Objects

For testing purpose download the latest version here:
Aspose.Cells for .NET (Latest Version)

A ready to run solution is available for testing here.