Rendering excel on webpage

arun.rudrangi · February 22, 2018, 4:56pm

Hi Can we render excel file in web application using Aspose.Cells for .NET Features we are looking are

edit online
select and copy row/column on buttonclick and paste

Any inputs on this is appreciated. Thank you.

amjad.sahi · February 22, 2018, 5:53pm

Thanks for your query.

I think you may consider using our Aspose.Cells.GridWeb control - A grid control that is specifically designed to work on web environments or in Asp.NET projects. It is an independent control where you may load Excel files into its grid matrix, create/design worksheets and update/ manipulate the data into the cells in WYSIWYG (visual) manner. It can load, manipulate/edit and save/re-save Excel files on the fly, everything in your browser type.

Please see the documents / articles for your reference:

Also, download the VS.NET featured demos “Examples.GridWeb” @ Github repos:

Hope, this helps a bit.

arun.rudrangi · February 22, 2018, 7:52pm

Thank you Amjad. I just tried rendering, file I have is a huge one. It is taking more than 3 minutes and even after loading, anything I do its responding so slow. Any thoughts on this. To improve performance.

shakeel.faiz · February 23, 2018, 5:05am

@arun.rudrangi

For your purpose of loading the huge file in GridWeb, please set the EnableAsync property to true.

EnableAsync

Gets or sets whether load cells data in asynchronous way, suggest to apply for one sheet with more than 10000 cells.

arun.rudrangi · February 23, 2018, 12:37pm

Thank you Shakeel for the update. Can we compare two excels on browser and show difference?

shakeel.faiz · February 23, 2018, 1:31pm

@arun.rudrangi

Thanks for considering Aspose APIs.

It is not an easy thing to highlight the differences between two Excel files. You will have to write your own algorithms. However, Aspose.Cells for .NET provides all the APIs to create, read and manipulate Excel files. But in order to highlight or show the differences between two Excel files, there is no direct API and you will have to depend on your own algorithms.

However, Aspose.Cells for .NET allows you to take the image of entire worksheet or range of cells. You can show the user the images of entire worksheet or range of cells and user may see the differences by himself. But if you want to highlight the differences, then as said earlier, you will have to write and depend upon your own algorithms.

Reference Article:

Export Range of Cells in a Worksheet to Image

arun.rudrangi · February 23, 2018, 4:35pm

Thank you Shakeel. Do we have Aspose.Cells.GridWeb control in JavaScript like to integrate in angularjs application.

shakeel.faiz · February 24, 2018, 12:18am

@arun.rudrangi

We are afraid, Aspose.Cells for GridWeb is a Server-Side control. It is available for ASP.NET and JSP or Servlets.

However, you should give try to Aspose.Cells for JavaScript because JavaScript is a client side language that means, Aspose.Cells can be used at client side.

Besides GridWeb, there is GridDesktop that is used on Windows Forms Control.

arun.rudrangi · February 28, 2018, 3:30pm

Thank you Shakeel. Do we have a sample for gridweb in aspose.cells for javascript to try ?
We are looking to add some buttons on the spreadsheet and perform some actions will that be possible ?

If aspose.cells for javascript does not have grid web. Do we have any other control similar to it to use in Angularjs solution.

shakeel.faiz · March 1, 2018, 1:00am

@arun.rudrangi

We are afraid, GridWeb Javascript is not available for the moment. Will you please share your Excel file and let us know your expected output with some screenshots. It will help us look into your issue better and we will update you asap.

arun.rudrangi · March 1, 2018, 1:14am

Sorry Shakeel this file cannot be shared. But this is excel file which has like 20 tabs almost 10000 cells data.
Features we are looking

open in angularjs solution
on some action I(Button click) we want to create few records in 10 templates at the same time with the same data.
of course edit the spreadsheet in ui and save on server.

shakeel.faiz · March 1, 2018, 8:02am

@arun.rudrangi

We have logged your requirements in our database for product team’s investigation for evaluation and for feasibility and implementation purpose. Once, we will have some news for you, we will update you asap.

This issue has been logged as

CELLSJAVA-42548 - GridWeb feasibility for AngularJS for Template Excel files containing 20 Tabs with 10000 Cells Data

arun.rudrangi · March 1, 2018, 1:15pm

Thank you Shakeel.

shakeel.faiz · March 9, 2018, 10:17am

@arun.rudrangi

Thanks for considering Aspose APIs.

Currently Gridweb is based on Client JS and a typical Server (e.g. ASP_NET or JSP Java Runtime) .

You need to write your own business logic if you want to use AngularJS. You will also need to use Aspose.Cells for JavaScript as basic API library.

We are afraid, we have no plan to support it for now.