1、数据准备
if (("type_constant.xlsx").equals(fileName)) {
initializeExcel.excelConstant();
} else if (("type_activity.xlsx").equals(fileName)) {
initializeExcel.excelActivityConf();
} else if (("type_dailytasks.xlsx").equals(fileName)) {
initializeExcel.excelDayTask();
} else if (("type_noble.xlsx").equals(fileName)) {
initializeExcel.excelVipConf();
} else if (("type_package.xlsx").equals(fileName)) {
initializeExcel.excelPackageConf();
} else if (("type_raffle.xlsx").equals(fileName)) {
initializeExcel.excelRaffle();
} else if (("type_raffleitem.xlsx").equals(fileName)) {
initializeExcel.excelRaffleItem();
} else if ("type_fb.xlsx".equals(fileName)) {
initializeExcel.excelFb();
} else if ("type_level.xlsx".equals(fileName)) {
initializeExcel.excelLevel();
} else if ("type_weather.xlsx".equals(fileName)) {
initializeExcel.excelWeather();
} else if ("type_skin.xlsx".equals(fileName)) {
initializeExcel.excelSkin();
} else if ("type_sign_in.xlsx".equals(fileName)) {
initializeExcel.excelSign();
} else if ("type_update_award.xlsx".equals(fileName)) {
initializeExcel.excelUpdateAward();
} else if ("type_ad.xlsx".equals(fileName)) {
initializeExcel.excelTypeAd();
} else if ("type_hero.xlsx".equals(fileName)) {
initializeExcel.excelHero();
} else if ("type_heroStarup.xlsx".equals(fileName)) {
initializeExcel.excelHeroStarUp();
} else if ("type_soldierOrder.xlsx".equals(fileName)) {
initializeExcel.excelSoldier();
} else if ("type_sale.xlsx".equals(fileName)) {
initializeExcel.excelSale();
} else if ("type_arena.xlsx".equals(fileName)) {
initializeExcel.excelArena();
} else if ("type_jishi.xlsx".equals(fileName)) {
initializeExcel.excelMarket();
} else if ("type_cube.xlsx".equals(fileName)) {
initializeExcel.excelCube();
} else if ("type_cityconfig.xlsx".equals(fileName)) {
//initializeExcel.excelCityConf();
} else if ("type_ai.xlsx".equals(fileName)) {
initializeExcel.excelAiParam();
} else if ("type_citysearch.xlsx".equals(fileName)) {
//initializeExcel.excelCitySearch();
} else if ("type_citytask.xlsx".equals(fileName)) {
//initializeExcel.excelCityTask();
} else if ("type_holiday.xlsx".equals(fileName)) {
initializeExcel.excelHoliday();
} else if ("type_grabcity.xlsx".equals(fileName)) {
initializeExcel.excelCityNewConf();
} else if ("type_gift_bag.xlsx".equals(fileName)) {
// initializeExcel.excelGiftBag();
} else if ("type_notice.xlsx".equals(fileName)) {
initializeExcel.excelNotice();
} else if ("type_herohallAI.xlsx".equals(fileName)) {
initializeExcel.excelHerohallAi();
} else if ("type_world_boss.xlsx".equals(fileName)) {
initializeExcel.excelWorldBoss();
} else if ("type_dispatchtask.xlsx".equals(fileName)) {
initializeExcel.excelDispatchTask();
} else if ("type_dispatchlv.xlsx".equals(fileName)) {
initializeExcel.excelDispatchLevel();
} else if ("type_item.xlsx".equals(fileName)) {
initializeExcel.excelItem();
} else if ("type_artifact.xlsx".equals(fileName)) {
initializeExcel.excelArtifact();
} else if ("type_artifact_cultivate.xlsx".equals(fileName)) {
initializeExcel.excelArtifactCultivate();
} else if ("type_artifact_entry.xlsx".equals(fileName)) {
initializeExcel.excelArtifactEntry();
} else if ("type_denseanswer.xlsx".equals(fileName)) {
initializeExcel.excelDenseFogAnswer();
} else if ("type_densefoglevel.xlsx".equals(fileName)) {
initializeExcel.excelDenseFogLevel();
} else if ("type_open_notice.xlsx".equals(fileName)) {
initializeExcel.excelOpenNotice();
} else if ("type_notice_android.xlsx".equals(fileName)) {
initializeExcel.excelNoticeAndroid();
} else if ("type_trialtbox.xlsx".equals(fileName)) {
initializeExcel.excelTrialtbox();
} else if ("type_trialtlevel.xlsx".equals(fileName)) {
initializeExcel.excelTrialtlevel();
} else if ("type_achievement.xlsx".equals(fileName)) {
initializeExcel.excelAchievementTask();
} else if ("type_healthyGame.xlsx".equals(fileName)) {
initializeExcel.excelHealthyGame();
} else if ("type_saleactivities.xlsx".equals(fileName)) {
initializeExcel.excelGameActivity();
} else if ("type_rewardcode.xlsx".equals(fileName)) {
initializeExcel.excelRewardCode();
} else if ("type_exploreCopy.xlsx".equals(fileName)) {
initializeExcel.excelExploreCopy();
} else if ("type_itemPackage.xlsx".equals(fileName)) {
initializeExcel.excelItemPackage();
} else if ("type_skill.xlsx".equals(fileName)) {
initializeExcel.excelSkill();
} else {
System.out.println("您输入的Excel名称不存在,请核对后再次输入!");
return;
}
2、目标把type_*.xlsx文件名全部提取出来 我们把代码放到Notpad++里面
选择正则表达式(G)
查找目标:.*?(type_.*?xlsx).*
替换为:$1
替换后结果
我们发现initializeExcel还存在 一样的方法把initializeExcel也使用正则表达式进行全部替换
查找目标:.*?(initializeExcel..*?();).*
替换为空:
替换后结果
3、把包含xlsx这一行的全部给删掉
替换前
查找目标:.*?xlsx.*
替换为空:
替换后结果