Using ExcelHelper Tool to Export Business Object to Excel Document


Author
Message
Trent Taylor
Trent Taylor
StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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!

Attachments
ExcelHelperSample_Csharp.zip (378 views, 138.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search