StrataFrame Forum
Home   
Search
   Members   Calendar   Who's On
Welcome Guest ( Login | Register )
    
Recent Posts
  
Popular Topics

Home » Updates and Information » Samples and Solutions » Using ExcelHelper Tool to Export Business...

Using ExcelHelper Tool to Export Business...Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Trent L. Taylor
Posted 01/31/2010 7:13:02 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 2:32:07 PM
Posts: 6,217, Visits: 6,081
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!

  Post Attachments 
ExcelHelperSample_Csharp.zip (26 views, 138.76 KB)

Post #25683
« Prev Topic | Next Topic »

Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 12:54pm

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.047. 8 queries. Compression Enabled.
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.