XAF Excel Importer

最新推荐文章于 2025-01-25 09:21:42 发布

转载最新推荐文章于 2025-01-25 09:21:42 发布 · 297 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Tonyyang/archive/2011/04/23/2025762.html

本文介绍了一种使用Excel导入数据模块的方法，该方法允许开发者通过选择Excel文件、指定导入数据的表格并预览数据，进而轻松地将大量Excel数据导入到新的XAF应用程序中。无需为每个不同的Excel文件编写单独的控制器，也无需迫使用户遵循预定义的模板，此方法提供了一个灵活且高效的数据导入解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.

转载于:https://www.cnblogs.com/Tonyyang/archive/2011/04/23/2025762.html