Using ExcelHelper Tool to Export Business Object to Excel Document

Author Message
 Posted 1/31/2010 1:13:02 PM
StrataFrame Developer

StrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame DeveloperStrataFrame Developer

Group: StrataFrame Developers
Last Login: 11/20/2019 8:57:25 AM
Posts: 6,610, Visits: 6,776
Overview
Another common topic that comes up on the forum is exporting a BO to an Excel spreadhsheet.  And this is one of those tools that you don't need it until you need it.  But once you do, it is extremely handy!  The ExcelHelper uses the Microsoft Jet OLEDB engine to interface with Excel to query and produce the document.  So if you are running on a 64-bit machine, be sure to build the assembly in x86 otherwise it will not work.

Solution
This sample is pretty straight forward.  The business object will first be populated with 100 records and then those records are then exported to an Excel document.  You can see that the code required is minimal and very easy to implement!

 ExcelHelperSample_Csharp.zip (108 views, 138.76 KB)

Post #25683
Add to Twitter Add to Facebook

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.