We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Inquiry about Excel Component (.NET)

Aspose.Cells Product Family
#1

Hi,

We have bought PDF library from you. So far we do not have any issue with it.

We would like to know more about Excel Library. (Same license : Developer OEM)

Following are our requirements : ( Fully managed code .net, No office installed)

1) Create workbook ( from template too)

2) Open workbook ( visible )

3) Add worksheet (by position)

4) Add (chart , macro , dialog, specific template) (by position)

5) Activate worksheet and Get Activate worksheet ( by name, by index)

6) Activate Cell and Get Activate Cell ( by reference, by position, by range)

7) Get and set cell value (active worksheet or specific worksheet) ( by reference, by position) also formatted values

8) Run macros

9) Future any online excel file access ( e.g. Google doc )

Let me know your component will support this functionality.

#2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

All of your requested features except those related to macros are supported by Aspose.Cells. Aspose.Cells can create workbook, open workbook, add worksheet, activate worksheet and get activated worksheet, activate cell and access cell contents.

However, Aspose.Cells cannot add macros or run them.

Please see the documentation for more help.

http://www.aspose.com/docs/display/cellsnet/Programmers+Guide

#3

Hi,


Thank you for your quick response.

One more question how do we achieve this functionality.

Microsoft.Office.Interop.Excel.Application xlApp;
xlApp = new Microsoft.Office.Interop.Excel.Application();

xlApp.Visible = true; // we need this functionality for our product for backword capbility.

Right now we can open Excel file (visible) and do interactivity with excel file to automate it.

I have look into your Excel component. but could find this.

waiting for your response.
#4

Hi,


For your knowledge, Aspose.Cells is a pure .NET component/library which is created in managed C# and it is independent and does not depend on any APIs or application what so ever. Also, it does not provide any interface. In Aspose.Cells there is no Excel.Application object. The core object it has is Workbook object, e.g

//this line will create a new workbook into memory that represents a new Excel file.
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook();

See the topics in the section for your reference:
http://www.aspose.com/docs/display/cellsnet/File+Handling+Features

So, to automate MS Excel interactively in MS Excel by using Aspose.Cells, I am afraid, you cannot do this. However, if you need to view the generated file or manipulate file by Aspose.Cells, you may use .NET’s Process.Start() API.

By the way, do you need some grid like control/environment where a client can see, open/save or manipulate Excel files in WYSIWYG (visual) manner on the web/desktop. If this is the case, you may make use of our controls (GridDeesktop, GridWeb) that support these features, e.g.

To get familiar with Aspose.Cells.GridWeb, see the demos and docs:
http://www.aspose.com/demos/.net-components/aspose.cells/csharp/grid/default.aspx
http://www.aspose.com/docs/display/cellsnet/Aspose.Cells.GridWeb