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

Edhy Rijo

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.

Edhy Rijo

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.



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?

Edhy Rijo

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

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.

Edhy Rijo

Cool