StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Missing ExcelHelper class in SF v1.7.0.6

Missing ExcelHelper class in SF v1.7.0.6

Edhy Rijo — Sun, 31 Jan 2010 21:22:14 GMT

Hi Trent,

I downloaded the SF v1.7.0.6 and could not find any reference to the new ExcelHelper class in MicroFour.StrataFrame.Tools namespace.

FYI in the StrataFrame version form all assemblies are 1.7.0.6

RE: Missing ExcelHelper class in SF v1.7.0.6

Trent L. Taylor — Sun, 31 Jan 2010 21:22:14 GMT

Cool :cool:

RE: Missing ExcelHelper class in SF v1.7.0.6

Edhy Rijo — Sun, 31 Jan 2010 20:46:00 GMT

Great, thanks. I already have a use for this feature, I was using a library to export some data to CSV, but this approach is much easier and once the file is in Excel customer can export it to CSV.

RE: Missing ExcelHelper class in SF v1.7.0.6

Trent L. Taylor — Sun, 31 Jan 2010 20:40:38 GMT

Sure. It exports the data table, so just make your query include the fields that you want to export instead of including all fields. Simple solution. :)

BTW, glad you got it going :)

RE: Missing ExcelHelper class in SF v1.7.0.6

Edhy Rijo — Sun, 31 Jan 2010 20:05:39 GMT

Problem solved on this one. The assembly in the GAC was 1.7.0.5, uninstalling and copying the one from the common folders did the trick on this one.

I should have known better, but it wasn't after I downloaded your sample and it worked, so something must have been messed. :hehe:

BTW, nice feature, I tested the Export and it works really fast. Now it would be nice to have the ability to exclude some fields from the BO, is there any hidden trick to do this?

RE: Missing ExcelHelper class in SF v1.7.0.6

Edhy Rijo — Sun, 31 Jan 2010 19:46:10 GMT

Well this is very weird, I downloaded your C# sample and I can access the ExcelHelper class in there, but in VB project I simply don't have it.

Hopefully somebody else can test this in VB and see if the ExcelHelper class is there.

RE: Missing ExcelHelper class in SF v1.7.0.6

Edhy Rijo — Sun, 31 Jan 2010 19:32:38 GMT

Ok, double checking the assemblies I found this:

In the GAC all list version 1.7.0.0, when right clicking each one, all are version 1.7.0.6 except MicroFourStrataFrame.UI.Expanded which is 1.7.0.5 (that may be the problem).

I don't have any other references in the BIN folders for SF assemblies.

RE: Missing ExcelHelper class in SF v1.7.0.6

Trent L. Taylor — Sun, 31 Jan 2010 19:13:58 GMT

Edhy,

I just double checked and this is working just fine. So it looks like you have some rogue assemblies somewhere. Also, I went ahead and created a quick sample so you can see how to use it.

http://forum.strataframe.net/FindPost25683.aspx

RE: Missing ExcelHelper class in SF v1.7.0.6

Trent L. Taylor — Sun, 31 Jan 2010 18:46:53 GMT

This further confirms my suspicions about your other thread where you indicated that the Cancel was returning OK. This class I KNOW is in there. Check to make sure that you don't have old assemblies in the GAC or in your local bin folder. I am pretty confident that you are still using old assemblies.