GridWeb.ImportExcelFile throws exception "Object reference not set to an instance of an object"

Aspose.Cells Product Family
28

Hi,
I had a quick test with the latest dll you attached. The AutoExtendMaxRowColumn = false works and “Entity Spreadsheet.xls” now loads within 7-9 seconds. But the latest dll has problem with IE. The “Html Parsing Error…” javascript error is back again.

To see the memory leakage, load the “Default.xlsx” with the UsingAsposeGrid.csproject that I attached before. Now open Windows task manager. Find w3wp.exe. Now just navigate different sheets for sometime. You will see that memory usage is increasing un-expectedly for the w3wp.exe process.

Thanks.
Wahid

29

Hi,
In the attached excel file there are some simple formulae which doesn’t work at WebGrid. Would you please investigate?

Thanks.
Wahid

30

Hi,

Please update all files in /acw_client/ virtual directory with /acw_client directory contained in the zip file (Aspose.Cells.GridWeb v2.4.2.2006.zip). This will resolve the issue of html/javascript error which mentioned in your previous reply.

We will fix the simple formulas error in your excel file soon.

We used your default.xlsx file to test the memory leakage issue without debugging. The windows task manager shows the w3wp.exe process using about 64M memory usage. After some operations of switching worksheet in IE, the memory usage increases to about 80M. Then the memory usage will stop increasing. We used a memory tool to detect the memory leakage issue. The tool shows that the VirtualMemory will increase a little after switching worksheet every time. The VirtualMemory is managed by .net framework, and all live instances of managed objects in GridWeb are not changed. GridWeb control is implemented with 100% managed code. We think this is a memory management strategy of asp.net.

31

Hi,

We have fixed the bug of IF function in Aspose.Cells.GridWeb v2.4.2.2008.

32

Hi,
I’ve tested the Aspose.Cells.GridWeb v2.4.2.2008 version. The IF formula works fine now. But still I do have the "HTML parsing error… " javascript error at IE. I’ve replaced the acw_client directory with the latest one.

Thanks.
Wahid

33

Hi,

We have fixed the issue of HTML parsing error in Aspose.Cells.GridWeb v2.5.0.2000. It should be caused by KB927917.

Please update the dll and acwmain.js.

34

Hi,
I’ve tested the latest dll Aspose.Cells.GridWeb v2.5.0.2000. HTML parsing error is gone for IE. But sheet browsing isn’t possible now for all browsers:(. Loading message is showing for indefinite time if you try to browse any other sheet.

Thanks.
Wahid

35

Hi,

We have fixed two bugs in Aspose.Cells.GridWeb v2.5.0.2001.

1. unable to change worksheet in EnableAjax mode.

2. unable to submit changing worksheet with an editing cell all together in EnableAjax mode.

It works fine in IE and FireFox now. Please update the dll and acwmain.js files.

36

The issues you have found earlier (filed as 24155;24155) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
37

The issues you have found earlier (filed as 24155;24155) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
(1)
38

Hi,
I found an issue with the version 2.5.0.2001 that I’m using right now. If you load the attached excel file “CurrencyFormat.xlsx” with the project that I attached before, you’ll see that for each currency formatted cells the grid shows unnecessary token “_)” at the end of each cell value.

Thanks.
Wahid

39

Hi Wahid,

Yes, we noticed the issue you have talked about using your latest file “CurrencyFormat.xlsx”. I have reopened your issue “CELLSNET-24155” again, we will figure it out soon.

Thank you.

40

Hi,

Please try Aspose.Cells.GridWeb v2.5.0.2002 (attached). We have fixed the number formatting issue.

Thank you.

41

Hi,
I found my problem fixed into v2.5.0.2002.

Thank you.

42

The issues you have found earlier (filed as 24155) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
43

Hi,
We’ve successfully integrated the grid component in our application and its already in live. We got an issue from one of our client. He faced problem in loading and working with the attached excel file. The page takes un-acceptable amount of time to load and sometime the browser hangs. Even if the page loaded successfully after several timeouts, user gets very annoying experience while editing cells.

The excel file contains formulae in the hidden sheet ‘ValidationData’.

Can you please investigate the issue ASAP?

Thanks.
Wahid

44

Hi,

I have tested to load your file to
GridWeb using our latest version v2.5.2.200x and found the issue as you have mentioned.

I have logged your issue with an id: CELLSNET-26523. We will look into it soon.

Thank you.

45

Hi,

We have tested “800 Entity.xls” using AutoExtendMaxRowColumn = false. The loading speed is faster.

Please refer to: https://forum.aspose.com/t/131989

Alternatively, you can try to use EnablePaging option.

We are implementing loading gridweb asynchronously. This will enhance the performance much on client side. It will take about 2-3 weeks.

Currently, you can try the options above.

46

Hi,

We have implemented the feature of loading data asynchronously in Aspose.Cells.GridWeb v2.5.3.2001. There is an attribute named “EnableAsync” to specify whether to enable to load data asynchronously.

Note: It is not available when using one of NoScroll, EnablePaging or DataBinding. You can fetch data via scrolling the vertical scroll bar on client side.

Please try the following lines to load your excel file:

C#

if (!IsPostBack)
{
GridWeb1.EnableAsync = true;
GridWeb1.AutoExtendMaxRowColumn = false;

string pathinfo = Request.PathInfo;

if (pathinfo.StartsWith("/"))
pathinfo = pathinfo.Substring(1);

if (pathinfo != “acw_ajax_call”)
{
GridWeb1.WebWorksheets.Clear();
GridWeb1.WebWorksheets.ImportExcelFile(@“c:\excel\800+Entity.xls”);
return;
}
}

Please update the dll and update acwmain.js into /acw_client virtual directory.
47

Hi,
I’ve tested the latest version Aspose.Cells.GridWeb v2.5.3.2001 in the attached project. It works nice now for big files though the CPU/Memory usage goes incredibly high for the W3P process while loading big files. But one burning issue returns which I solved before with the help of GridWeb client side API.

Issue Details: After loading an excel file in the grid, when a user is in editing mode in a cell, user clicks on a postback button, at the button postback event the edited data isn’t available. But after editing if the user press tab to navigate to adjacent cell and then press the button, the data is available.
Button Code:
<asp:Button ID=“btnSave” runat=“server” Text=“Save” OnClientClick=“UpdateGridData();” OnClick=“btnSave_Click” />

I solved the above issue by introducing the UpdateGridData() JS function:
function UpdateGridData() {
// get the grid
var grid = GetGrid();
if (grid) {
grid.updateData(false);
grid.validateAll();
}
}

It works fine with the older version Aspose.Cells.GridWeb+v2.5.0.2002. But it doesn’t with the latest version.

Please help urgent.

Thanks.
Wahid