private static void AddTrustDirToRegister(string trustDir, RegistryView registryView) { List <string> listSubKeys = new List <string>(); var localKey = RegistryKey.OpenBaseKey(RegistryHive.CurrentUser, registryView); RegisterManager registerManager = new RegisterManager() { BaseKey = localKey }; registerManager.EnumerateKeyNames(@"Software\Microsoft\Office", ref listSubKeys); CreateTargetSubKey(registerManager, listSubKeys, localKey, trustDir); }
private static void CreateTargetSubKey(RegisterManager registerManager, List <string> listSubKeys, RegistryKey localKey, string trustDir) { var regAllowNetworkLocations = listSubKeys.Where(s => s.EndsWith(@"Excel\Security\Trusted Locations")); //设置信任网络路径 foreach (var item in regAllowNetworkLocations) { registerManager.SetRegeditKeyValue(item, "AllowNetworkLocations", "1"); } //包含EXCEL字样的,并且有location节点 var listSecurity = listSubKeys.Where(s => s.Contains(@"Excel\Security\Trusted Locations")).Where(s => Regex.IsMatch(s, @"Location\d+$")).ToList(); foreach (var item in listSecurity) { if (registerManager.IsRegeditKeyAndValueExist(item, "Path", trustDir)) { return; } } ; var result = from s in listSecurity select new { GroupName = Regex.Match(s, @".+?\\.+?\\.+?\\.+?\\").Value, Fullpath = s }; //按HKEY_CURRENT_USER\Software\Microsoft\Office\15.0分组,防止多个EXCEL版本的原因引起信任位置添加不全 var query = from s in result group s by s.GroupName; foreach (var item in query) { //只取第1条记录,去掉最后一个尾数 string locationName = Regex.Match(item.First().Fullpath, @".+Location").Value; //用最后的尾数来比较大小,不是用字符串,可以最终比较出11比2大 int locationIndex = item.Max(s => int.Parse(Regex.Match(s.Fullpath, @".+Location(\d+)").Groups[1].Value) + 1); string newLocationName = Regex.Match(locationName, ".+Location").Value + locationIndex; RegistryKey Location = localKey.CreateSubKey(newLocationName); Location.SetValue("Path", trustDir); Location.SetValue("AllowSubfolders", "00000001", RegistryValueKind.DWord); Location.SetValue("Date", DateTime.Now.ToString()); Location.SetValue("Description", ""); } }