91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 3.59MB
    文件類型: .zip
    金幣: 2
    下載: 1 次
    發布日期: 2023-08-10
  • 語言: C#
  • 標簽: C#，NPOI??

資源簡介

最近工作需要做一個導入Excel功能，特地學習制作，代碼邏輯清晰，注釋明確，方便新手入門。可導入多表頭Excel數據文件，免去新手找DLL、無從下手等一系列問題。

資源截圖

代碼片段和文件信息 

using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Reflection;
using?System.Text;
using?System.Threading.Tasks;

namespace?XlsImportDemo
{
????public?class?BeanToMapUtil
????{
????????/**
????????*?將一個?Map?對象轉化為一個?JavaBean
????????*?@param?type?要轉化的類型
????????*?@param?map?包含屬性值的?map
????????*?@return?轉化出來的?JavaBean?對象
????????*?@throws?IntrospectionException?如果分析類屬性失敗
????????*?@throws?IllegalAccessException?如果實例化?JavaBean?失敗
????????*?@throws?InstantiationException?如果實例化?JavaBean?失敗
????????*?@throws?InvocationTargetException?如果調用屬性的?setter?方法失敗
????????*/
????????public?static?object?convertMap（User?objSource?Dictionaryject>?map）
????????{

????????????Type?typeSource?=?objSource.GetType（）;
????????????object?objTarget?=?Activator.CreateInstance（typeSource）;//創建目標對象
????????????PropertyInfo[]?propertyDescriptors?=?typeSource.GetProperties（）;
????????????try
????????????{
????????????????foreach?（PropertyInfo?p?in?propertyDescriptors）//遍歷屬性
????????????????{
????????????????????if?（p.CanWrite）
????????????????????{
????????????????????????string?propertyName?=?p.Name;
????????????????????????if?（map.Keys.Contains（propertyName））
????????????????????????{
????????????????????????????object?value?=?map[propertyName];

????????????????????????????object[]?args?=?new?object[1];
????????????????????????????args[0]?=?value;

????????????????????????????p.SetMethod.Invoke（objTarget?args）;

????????????????????????????//object?objPropertyValue?=?p.GetValue（objSource?null）;
????????????????????????????//if?（objPropertyValue?==?null）
????????????????????????????//{
????????????????????????????//????p.SetValue（objTarget?args）;
????????????????????????????//}

????????????????????????}
????????????????????}
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{

????????????}

????????????return?objTarget;

????????}


????????/**
????????*?將一個?JavaBean?對象轉化為一個??Map
????????*?@param?bean?要轉化的JavaBean?對象
????????*?@return?轉化出來的??Map?對象
????????*?@throws?IntrospectionException?如果分析類屬性失敗
????????*?@throws?IllegalAccessException?如果實例化?JavaBean?失敗
????????*?@throws?InvocationTargetException?如果調用屬性的?setter?方法失敗
????????*/
????????public?static?Dictionaryject>?convertBean（object?bean）
????????{
???????????Type?sType=?bean.GetType（）;
???????????Dictionaryject>?returnMap?=?new?Dictionaryject>（）;
???????????PropertyInfo[]?propertyDescriptors?=?sType.GetProperties（）;
???????????foreach?（PropertyInfo?p?in?propertyDescriptors）
???????????{
???????????????string?propertyName?=?p.Name;
???????????????if?（!propertyName.Equals（“class“））
???????????????{
???????????????????MethodInfo?readMethod?=?p.GetGetMethod（）;
??????????????????
???????????????????object?result?=readMethod.Invoke（beannew?object[0]）;
???????????????????if?（result?!=?null）
???????????????????{
???????????????????????return

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-09-30?10:59??OperateExcelDemo\
?????文件?????????187??2015-01-29?10:37??OperateExcelDemo\App.config
?????文件????????3524??2015-01-30?11:41??OperateExcelDemo\BeanToMapUtil.cs
?????目錄???????????0??2015-01-29?10:37??OperateExcelDemo\bin\
?????目錄???????????0??2017-09-30?10:55??OperateExcelDemo\bin\Debug\
?????文件??????200704??2014-07-03?10:56??OperateExcelDemo\bin\Debug\ICSharpCode.SharpZipLib.dll
?????文件?????1603072??2014-12-11?05:48??OperateExcelDemo\bin\Debug\NPOI.dll
?????文件??????421888??2014-12-11?05:48??OperateExcelDemo\bin\Debug\NPOI.OOxml.dll
?????文件??????420479??2014-12-11?05:48??OperateExcelDemo\bin\Debug\NPOI.OOxml.xml
?????文件???????85504??2014-12-11?05:48??OperateExcelDemo\bin\Debug\NPOI.Openxml4Net.dll
?????文件??????153211??2014-12-11?05:48??OperateExcelDemo\bin\Debug\NPOI.Openxml4Net.xml
?????文件?????1873408??2014-12-11?05:48??OperateExcelDemo\bin\Debug\NPOI.OpenxmlFormats.dll
?????文件?????2134991??2014-12-11?05:48??OperateExcelDemo\bin\Debug\NPOI.xml
?????文件????????1057??2015-01-29?11:27??OperateExcelDemo\bin\Debug\user.xml
?????文件???????19456??2017-09-30?10:55??OperateExcelDemo\bin\Debug\XlsImportDemo.exe
?????文件????????1266??2017-09-30?10:55??OperateExcelDemo\bin\Debug\XlsImportDemo.exe.CodeAnalysisLog.xml
?????文件?????????187??2015-01-29?10:37??OperateExcelDemo\bin\Debug\XlsImportDemo.exe.config
?????文件???????????0??2017-09-30?10:55??OperateExcelDemo\bin\Debug\XlsImportDemo.exe.lastcodeanalysissucceeded
?????文件???????48640??2017-09-30?10:55??OperateExcelDemo\bin\Debug\XlsImportDemo.pdb
?????文件???????24224??2017-09-30?10:59??OperateExcelDemo\bin\Debug\XlsImportDemo.vshost.exe
?????文件?????????187??2015-01-29?10:37??OperateExcelDemo\bin\Debug\XlsImportDemo.vshost.exe.config
?????文件?????????490??2015-10-30?15:19??OperateExcelDemo\bin\Debug\XlsImportDemo.vshost.exe.manifest
?????目錄???????????0??2015-01-29?17:20??OperateExcelDemo\DLL\
?????文件??????200704??2014-07-03?10:56??OperateExcelDemo\DLL\ICSharpCode.SharpZipLib.dll
?????文件?????1603072??2014-12-11?05:48??OperateExcelDemo\DLL\NPOI.dll
?????文件??????421888??2014-12-11?05:48??OperateExcelDemo\DLL\NPOI.OOxml.dll
?????文件??????420479??2014-12-11?05:48??OperateExcelDemo\DLL\NPOI.OOxml.xml
?????文件???????85504??2014-12-11?05:48??OperateExcelDemo\DLL\NPOI.Openxml4Net.dll
?????文件??????153211??2014-12-11?05:48??OperateExcelDemo\DLL\NPOI.Openxml4Net.xml
?????文件?????1873408??2014-12-11?05:48??OperateExcelDemo\DLL\NPOI.OpenxmlFormats.dll
?????文件?????2134991??2014-12-11?05:48??OperateExcelDemo\DLL\NPOI.xml
............此處省略33個文件信息

評論

共有 條評論

相關資源