# excel Published articles for excel. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## CodeSOD: An Odd Sort DevFeed: [CodeSOD: An Odd Sort]() Original publisher: [Read original article]() Author: Remy Porter Published: 2026-09-15T06:30:00Z Content type: opinion Language: en Sources: [The Daily WTF]() Topics: [Code](), [PowerShell](), [Script](), [Sorting]() Tags: [code](), [codesod](), [csv](), [excel](), [powershell](), [report](), [script](), [sorting]() ### AI overview The article critiques a PowerShell script that queries Active Directory for users and their last logon times. It explains that the script's alphabet-based approach does not correctly sort names, performs unnecessary searches and property loading, and generates a CSV report for Excel despite these inefficiencies. ### Source excerpt Let's say we wanted to query Active Directory and print out a report of all of our users, and their last logon time. That seems like a pretty normal task for a Powershell script. It'd probably be short and easy to read, at least if it were written by a normal person. Alice sends us one that wasn't. She's already done us a favor, as she writes: "Code cleaned up and indented for the whitespace-missing-impaired." ##################################### # lists accounts and selected attributes alphabetically ##################################### foreach( $letter in "a", "b", "c"......"z") { $strfilter = $letter + "*" $objdomain = New-object System.DirectoryServices.DirectoryEntry $objSearcher = New-object System.DirectoryServices.DirectorySearcher $objSearcher.SearchRoot = $objdomain $objSearcher.Filter = $strFilter $objSearcher.PropertiesToLoad.Add("name"); $colResults = $objSearcher.FindAll() foreach($result in $colResults) { $name = $result.Properties.Name $searcher = New-Object DirectoryServices.DirectorySearcher([adsi]"") $searcher.filter "(&(objectCategory=User)(sAMAccountName=$name))" $users = searcher.FindAll() foreach($user in $users) { Write-Output $user.properties.item("name") + "," + $user.properties.item("lastLogon") } } } This accomplishes sorting alphabetically by iterating across the alphabet. Which, I suspect, isn't going to actually get them in alphabetical order; it makes sure that albert and alice appear before bob, but doesn't enforce that albert must come before alice. In any case, we iterate across the alphabet, and then create a searcher that finds a*, then b*, etc. We explicitly tell the searcher that the only property we care about is the name field, so that we don't load unnecessary fields, like the ones we want to report on. We then iterate across the list of names, construct a new searcher, and search for the account with the username we fetched. That lets us get all of the fields we need, including the ones we aren't going to use. Now, we sea ## Microsoft patches Windows and Excel - breaks audio, remote access, and paste DevFeed: [Microsoft patches Windows and Excel - breaks audio, remote access, and paste]() Original publisher: [Read original article]() Author: Richard Speed Published: 2026-09-14T13:00:00Z Content type: news Language: en Sources: [www.theregister.com - Articles]() Topics: [Microsoft](), [Windows]() Tags: [excel](), [microsoft](), [os-platforms](), [remote](), [remote-access](), [windows]() ### AI overview Microsoft patches Windows and Excel, but the updates introduce problems affecting audio, remote access, and paste functionality. ### Source excerpt Redmond's quality drive takes another detour through the known issues list ## Trusting AI agents: A reinsurance case study DevFeed: [Trusting AI agents: A reinsurance case study]() Original publisher: [Read original article]() Author: Sophia Barnes Published: 2026-01-22T00:00:00Z Content type: article Language: en Sources: [Temporal Blog]() Topics: [Artificial Intelligence](), [data-processing](), [datasets](), [decision-making](), [parallel](), [file]() Tags: [agents](), [ai](), [ai-agents](), [automate](), [case-study](), [data-processing](), [excel](), [how-to](), [insurance](), [multi-agent](), [pricing](), [risk](), [workflows]() ### AI overview This case study explains how a multi-agent AI system with human-in-the-loop safeguards automates reinsurance data workflows. The system parses unstandardized Excel submission packs, matches catastrophe events with historical records, creates cedant loss records, and flags changes to existing data. ### Source excerpt Learn how to build a reliable multi-agent AI system with human-in-the-loop safeguards using Temporal. A detailed case study on automating complex reinsurance data workflows. ## The 3 (+2) ways to Get Data in Power BI, simply explained DevFeed: [The 3 (+2) ways to Get Data in Power BI, simply explained]() Original publisher: [Read original article]() Published: 2024-04-01T00:00:00Z Content type: tutorial Language: en Sources: [Mutt0-ds Notes]() Topics: [data](), [datasets](), [Database]() Tags: [data](), [database](), [dataset](), [excel](), [live-data](), [performance](), [query](), [semantic](), [tutorials]() ### AI overview This tutorial explains how Power BI Desktop stores and retrieves report data through Import Mode, DirectQuery, Live Connection, and Composite Models. It describes the trade-offs between local copied data and live queries, including refresh needs, scalability, and performance. ### Source excerpt There's quite a bit of confusion swirling around about how Power BI reports gather data. Where is the data actually stored? How frequently... ## Fastest Way to Read Excel in Python DevFeed: [Fastest Way to Read Excel in Python]() Original publisher: [Read original article]() Author: Haki Benita Published: 2024-01-02T22:00:00Z Content type: article Language: en Sources: [Haki Benita]() Topics: [Python](), [data](), [CSV](), [parquet]() Tags: [article](), [articles](), [benchmarks](), [compare](), [csv](), [excel](), [generator](), [import](), [memory](), [parquet](), [performance](), [python](), [reading]() ### AI overview This article compares several ways to read Excel files from Python. It benchmarks importing data from a 25 MB XLSX file containing 500,000 rows and considers timing, memory use, generators, and preservation of Excel data types. ### Source excerpt I'm fairly sure that Excel is the most common way to store data, manipulate data, and yes(!), even pass data around. This is why it's not uncommon to find yourself reading Excel in Python. In this article I compare several ways to read Excel from Python. ## DataGrip 2021.3: Aggregate view в редакторе, табличное представление узлов дерева БД, новое окно сравнения БД и др DevFeed: [DataGrip 2021.3: Aggregate view в редакторе, табличное представление узлов дерева БД, новое окно сравнения БД и др]() Original publisher: [Read original article]() Author: AlisaLu (JetBrains) Published: 2021-11-25T10:31:46Z Content type: release Language: ru Sources: [JetBrains RU]() Topics: [Databases](), [Database](), [data](), [jetbrains](), [ide]() Tags: [data](), [database](), [env-file-security](), [excel](), [extensions](), [intellij](), [intellijidea](), [jetbrains](), [mongodb](), [mysql](), [oracle](), [postgres](), [postgresql](), [sql](), [sqlserver](), [tag-d189f87ebb8f]() ### AI overview A release overview of DataGrip 2021.3 describes new database-development features, including aggregate views in the data editor, tabular views for database-tree nodes, independent filtering and sorting in split editors, custom fonts, and multi-value foreign-key navigation. ### Source excerpt Привет! Сегодня расскажем, что нового в свежем релизе DataGrip 2021.3. Если вы работаете с базами данных в других IDE от JetBrains, то этот пост и для вас тоже. Читать далее ## LAMBDA: An Excel worksheet function for defining new functions DevFeed: [LAMBDA: An Excel worksheet function for defining new functions]() Original publisher: [Read original article]() Published: 2021-01-27T03:27:09Z Content type: article Language: en Sources: [Lambda the Ultimate]() Topics: [Programming](), [Programming language](), [data](), [decision-making](), [Microsoft]() Tags: [data](), [decision-making](), [excel](), [fun](), [function](), [lambda](), [lambda-calculus](), [microsoft](), [programming-language]() ### AI overview The post describes LAMBDA, an Excel worksheet function that lets users define new functions. It addresses limitations of Excel's formula language, including its previous lack of user-defined functions and support for only scalar values. ### Source excerpt Post by Andy Gordon and Simon Peyton Jones on LAMBDA giving Excel users the ability to define functions. Ever since it was released in the 1980s, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the millions of people who use it each day. It's also the world's most widely used programming language. Excel formulas are written by an order of magnitude more users than all the C, C++, C#, Java, and Python programmers in the world combined. Despite its success, considered as a programming language Excel has fundamental weaknesses. Over the years, two particular shortcomings have stood out: (1) the Excel formula language really only supported scalar values--numbers, strings, and Booleans--and (2) it didn't let users define new functions. Until now. ## Test naming convention DevFeed: [Test naming convention]() Original publisher: [Read original article]() Published: 2019-03-14T00:00:00Z Content type: tutorial Language: en Sources: [Paweł Chudzik]() Topics: [Automation](), [unit tests](), [Development](), [Code review]() Tags: [api](), [automated](), [automation](), [code-review](), [database](), [excel](), [ide](), [integration-test](), [tests](), [verify]() ### AI overview This tutorial explains how to use automated tests to enforce naming conventions for test groups. It distinguishes fast unit tests from integration tests involving I/O, databases, external APIs, reports, and Excel imports, and argues that convention checks can serve as both automated enforcement and living documentation. ### Source excerpt How to introduce automated checks that will guarantee that conventions are followed in an example of test naming convention. I'm going to focus on creating automated process that will verify if test names do match conventions. Automation will allow us to forget about the rule because the computer will ensure it's followed. Test that I'm going to introduce will be living documentation inside the project and ensure no one will miss nor forget about the way we group tests. Read more ## Cerego - Learn Anything, Everywhere DevFeed: [Cerego - Learn Anything, Everywhere]() Original publisher: [Read original article]() Published: 2012-12-16T00:00:00Z Content type: opinion Language: en Sources: [Juri Strumpflohner]() Topics: [Learning](), [Automation](), [VBA]() Tags: [android](), [automation](), [excel](), [import](), [ios](), [learn](), [net-11](), [q-a](), [script]() ### AI overview The author describes an automated study system built in Excel using a two-column question-and-answer format and a small VBA script. The script randomly presents questions, reveals solution hints for checking, and tracks correct versus incorrect answers to indicate exam readiness. The article later connects this approach to flash-card apps, including Cerego. ### Source excerpt Lorem ipsum dolor sit amet