code
11 TopicsPython in Excel – Available Now
Python in Excel is now generally available for Windows users of Microsoft 365 Business and Enterprise. Last August, in partnership with Anaconda, we introduced an exciting new addition to Excel by integrating Python, making it possible to seamlessly combine Python and Excel analytics within the same workbook, no setup required. Since then, we’ve brought the power of popular Python analytics libraries such as pandas, Matplotlib, and NLTK to countless Excel users.129KViews5likes26CommentsHow to count and sum "Condtional formatting" cells by color in Excel 2010?
I installed few add-ins for counting "Conditional formatted" cells but all are generating an instant (one-time) numeric result by activating that command. Also, I tried a code which gives an instant counting of 1 picked color without a total sum of all other colors -in my case 12 colors in a matrix. ("How to use the code to count colored cells and sum their values" - https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/ ) My question is: Is there any functional code (or other aproach) which can count and sum all cells by "Conditional formatted" colors, on one sheet, and that the generated result is linked through common formulas? That can be updated/refreshed/code run during the work process as a complete overview of colors of a matrix (and not by picking every color every time as I mentioned). Thanks in advance!Solved290KViews1like181CommentsAzure SQL Database Token-based authentication with PowerShell
First published on MSDN on Oct 26, 2018 How to connect to Azure SQL Database using token-based authentication in PowerShell native appsThis guide assumes you already have a deployment of an Azure SQL Database, your PowerShell environment configured and you have an app registration for a native app in Azure Active Directory.16KViews0likes1CommentMicrosoft Edge Discount Code Finder: Leaked Codes
Hi there, I work for a retail e-commerce brand that constantly has discount codes leaked from closed affiliate networks onto Edge Shopping discount finder. Of which, there is no contact for us to get in touch with to ensure they are removed. Has anyone else had any contact with someone at Microsoft/Edge/Bing that can help me get these codes removed? I would prefer to keep the information about the brand private, and not in this forum - hence needing a contact. Thanks, James1.1KViews0likes0CommentsSharing pages via QR Code - [Not Working Right Now]
Note: either It's currently not working or I can't figure out how to work with it: 12/20/2019 There is a new feature added to Edge browser in Version 81.0.369.0 canary The ability to share web pages via QR code it needs to be enabled using this flag: #sharing-qr-code-generator in edge://flags/ the QR indications will appear in the address bar And in the right-click menu on web pages After selecting "generate QR code for this page", I get this box I'm not sure what I'm supposed to write in that text area, when I start typing, the color up there changes accordingly.Solved2.3KViews2likes4CommentsCan i please get some explanation and information about the things written in the Local State file?
The file is located here: %localappdata%/Microsoft\Edge SxS\User Data for Edge canary can be viewed from browser too: edge://local-state/ some of them are obvious like this "browser": { "browser_build_version": "81.0.387.0", "enabled_labs_experiments": which show which flags are enabled. but then i don't understand what these are for: "experimentation_and_configuration_service_control": 2, "external_config_domain_actions": { "idl_override": { "applications": [ { "applied_policy": "ExposePrefixedEME", "domain": "netflix.com" }, { "applied_policy": "ExposePrefixedEME", "domain": "music.amazon.com" }, { "applied_policy": "ExposePrefixedEME", "domain": "music.amazon.de" }, { "applied_policy": "ExposePrefixedEME", "domain": "sling.com" }, { "applied_policy": "ExposePrefixedEME", "domain": "openidconnectweb.azurewebsites.net" } ], "policies": [ { "name": "ExposePrefixedEME", "type": "PrefixedEme" } ], "version": 1 } I'd appreciate if anyone can shed some light on it.Solved5.9KViews0likes5CommentsTeam client source
We want to be able to have a Team chat client embedded as a component in one of our in-house Angular applications. What would be the best way to approach this? Is the source available to use anywhere or would we have to develop our own and mimic the client? Thanks Ian1.1KViews0likes1Comment