XAF Excel Importer

XAF 用Excel导入数据模块

Here's a video on how it works: http://mdworkstuff.blogspot.com/2011/05/excel-import-wizard-demo-from.html

and a post on how to include it into an existing XAF project
http://mdworkstuff.blogspot.com/2011/05/how-to-include-expandframework-module.html

 

One more common situation when working with XAF is that in many cases You usually get a lot of data in Excel SpreadSheets,You need to import to Your New Application.

So instead of writing a separate controller for each different excel file, o forcing people to use some predefined template, here what I came up with.

Wizard Page 1 lets You select Excell 2007 or newer file, select a Sheet that You want to import data from and see a PreView of the Data:

Next You can Map Excel columns to Your object Properties (or Let the Import Wizard try to Guess the mappings)

And See the progress of data import that is done in a separate thread.