Aspose Product Info Requested

Aspose.Cells Product Family
1

Hi,

I am in need of a web control which can fulfill our following current requirements.

1. Display data and chart on a web page with ability to export this data and chart to an excel sheet. The data and chart have to be displayed on the same excel sheet not on two different sheets.

2. Ability to export multiple data and charts to separate worksheets in the same excel document.

3. Works with VS 2008, and SSL.

Please let me know what is the best control which can serve these requirements or at least comes closer to fulfilling these requirements.

Thanks

Nishat Mazhar


This message was posted using Email2Forum by DannyCooper.
2

Hi,

I would like to mention a few components against your requirements. Kindly check the info (with a few limitations) given below for the components.

1). Well, We do have Aspose.Grid.Web control but it cannot create/manipulate Charts currently. Aspose.Grid.Web (original package is Aspose.Grid which includes two controls i.e. Aspose.Grid.Web and Aspose.Grid.Desktop) is a GUI control that provides MS Excel like environment in WYSIWYG manner, you may easily place it on the webpage (.aspx webform). It has its own grid matrix and has its own formula calculation engine to calculate all types of formulas at runtime. It can load existing excel files to the grid matrix (cells in rows/columns) and can also save output files to disk. It allows user can design its spreadsheet of his need too. For ref, please check the source code of Aspose.Grid.Web demos: http://www.aspose.com/Products/Aspose.Grid/Demos/, the demos gets automatically installed on your machine when you use control's MSI installer. Please check the docs for further ref: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/index.html

2).Aspose.Cells is a powerful library that can be used to manage spreadsheets. Well, it does not provide web preview feature although using Aspose.Cells API i.e. Worksheet.SheetToImage, you may get the worksheet image and can place it on your webform. Similarly, Aspose.Cell can create/manipulate all types of native excel charts (import/export operations) (bar, column, line, pie, stock etc.) in excel formats. It also supports to convert an excel chart to image file using Chart.ToImage() method. So, if you don't want the users should not be able to use grid matrix dynamically in WYSIWYG manner rather wants to display the images of spreadsheet sheets and charts, you can use the component (Aspose.Cells) only to fulfill your needs. The component is highly optimized and perform will under loads. You can import/export excel spreadsheets, create and manipulate charts with data in a single worksheet in a workbook/excel file or in different worksheets too. Aspose.Cells for .NET has a powerful formula calculation engine as well. It provides almost all the MS Excel (97-2007) features. Please check the Aspose.Cells documentation for further reference: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/index.html

3). And another one, Aspose.Chart is a utility library for creating sophisticated charts of all types. you may create and take the image of the chart in all the popular formats e.g.., jpg, bmp, emf, png etc. Check some demos: `http://www.aspose.com/demos/aspose.chart/default.aspx`

Furthermore, you may try to use only one (Aspose.Cells for .NET) or two (Aspose.Cells for .NET and Aspose.Grid.Web) or even all three components for your requirements, it actually depends on your scenario/requirements. Suppose, if you would like some dynamic implementations in WYSIWYG manner too. For example you may use Aspose.Chart/Aspose.Cells to create charts and take the image of the chart, use Aspose.Grid.Web to place it on the webform and fill the data (or load an excel file) into its grid and input the chart image (provided by Aspose.Chart/Aspose.Cells). You can dynamically change the data and recreate the chart using Aspose.Cells / Aspose.Chart APIs to re-take the chart image to be shown in the GridWeb. For exporting data and chart into excel, use Aspose.Grid.Web to export the data to create an excel sheet in the excel file, use Aspose.Cells/Aspose.Chart to insert the chart into the excel sheet.

I would like to refer a technical article here which may best describe a demo for creating worksheets and dynamic charts (both import and export operations). In this article, we have used all the three components i.e.., Aspose.Grid.Web, Aspose.Cells for .NET and Aspose.Chart for .NET. Please check the article: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/dynamically-generate-formatted-excel-reports-with-an-elegant-graph.html

I think your Q1 and Q2 is cleared to you now. And, for your third query (Point 3.), all three components support VS2008 and SSL.

Thanks for your considerations.