Hi,

In the C#/.NET component, upon calling:

new Workbook(fileName);

two exceptions are being thrown and caught every time. These are "Could not read block - no data!" and after that, "Cannot read that as a Zip file". I have my debugger set to break on any exceptions so I'm aware of these occurring even though they're being caught.

Even though they're being caught, throwing and catching exceptions is very slow (compared with other operations) and it should be avoided. Paying this performance cost every single time a file is loaded is not very good design from a performance standpoint (as well as the annoyance of having the debugger break!)

I hope it will be fixed soon as we're looking to evaluate an Excel interoperability library and are strongly considering Aspose.

Hi,

Please post your template file, we will check it soon.

---

Simon Zhao
Developer
Aspose Nanjing Team
Contact Us

I have met the exact same problem as MgSam's and have not got a answer up to now. Looking forward to see the solution to this problem as soon as possible.

var workBook = new Workbook(filePath);


This throws and catches exceptions each time its invoked. I've also found that 

workBook.Save(filePath) 

is throwing and catching an exception each time its invoked.


This really needs to be addressed. It screws up debugging and is needlessly inefficient.

Hi,

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

I've included a project that does nothing other than instantiate a Workbook object and then tries to save it. If you run it with the VS debugger set to break on all exceptions, you will see the issue. It only occurs for xls files, not xlsx, from what I can tell.

Hi,

I have tested your file with the latest version: Aspose.Cells for .NET v7.0.3.2 and it is working fine.

Please see the code below and the output xls file.

C#

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

I am not able to get the DLL you linked to work at all. It must be built for your specific machine or something else is wrong.

Was this issue actually known about and fixed in a newer build, or you just were not able to replicate the issue?

Hi,

What is the .NET framework version of your System? Are you using .NET framework ClientProfile? In this case, you will need a different dll and not this one.

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

I'm using Windows 7 64 bit. I did have the test project set to .NET 4.0 Client Profile but I changed it to .NET 4.0 based on your feedback so that I could test this DLL. However, the same exact exceptions still occur.

They are handled exceptions. They are thrown and caught internally in Apose.Cells, every time. I known they are happening because my debugger is set to break whenever an exception is thrown. It doesn't affect the library from being usable, but it is a serious pain when debugging and its inefficient.

Did you even try to reproduce the problem before telling me it is working fine?

Hi,

Yes, I did test it as you can see the sample code and the output file attached by me. I was not able to reproduce the problem.

It seems, you need ClientProfile dll. We will provide it to you asap.

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

So is there a resolution?

Hi,

Please try the client profile version of Aspose.Cells dll, which you will find in net3.5_ClientProfile folder and share your feedback with me.

Please download the MSI installer that will create the above folders from this link: Aspose.Cells for .NET 7.0.3

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook

I tried this and the same exceptions are still thrown (and caught). I strongly suspect these exceptions have nothing to do with the framework version.

Clearly, I am not the only one having this issue, as only a small subset of users of a product typically post on a forum and this thread has two people encountering it.

Can you please try and project that I uploaded for you to test with and list every step you are taking to reproduce the problem? I'm not sure that you're understanding what the issue is.

Here is the exception text again:

new Workbook("myfile.xls"); - causes the following exceptions to be thrown and caught:

ࣝ.დ occurred
  Message=Could not read block - no data!  (position 0x00000000)
  Source=Aspose.Cells
  StackTrace:
       at ࣝ.Ⴏ._Ⴟ(Stream ݞ, String Ⴠ)
  InnerException:

ࣝ.Ⴎ occurred
  Message=Cannot read that as a ZipFile
  Source=Aspose.Cells
  StackTrace:
       at ࣝ.ვ.ᅻ(ვ ၧ)
  InnerException: ࣝ.დ
       Message=Could not read block - no data!  (position 0x00000000)
       Source=Aspose.Cells
       StackTrace:
            at ࣝ.Ⴏ._Ⴟ(Stream ݞ, String Ⴠ)
            at ࣝ.Ⴏ.Ⴞ(Stream ݞ)
            at ࣝ.ვ.ᅽ(Stream ݞ)
            at ࣝ.ვ.ᅻ(ვ ၧ)
       InnerException:

workbook.Save("out.xls") - causes the following exception to be thrown and caught:

System.ArgumentException occurred
  Message=Item has already been added. Key in dictionary: '0'  Key being added: '0'
  Source=mscorlib
  StackTrace:
       at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
  InnerException:

Hi,

Its strange, your issue is still unresolved.

I have forwarded your thread to our development team. I have also logged this issue in our database. We will look into it and update you asap.

This issue has been logged as CELLSNET-40141.

---

Many Thanks and Kind Regards,

Shakeel Faiz
Support Developer
Aspose Sialkot Team
Contact Us
Aspose - The .NET and Java Component Publisher

Keep in touch! We're on Twitter and Facebook