Posted by jpluimers on 2026/04/09
Some links on the [Wayback/Archive] FILTERXML function – Microsoft Support.
It is only available on Windows (because of the underlying XPath libraries used, I think it is MSXML), and “only” as of Excel 2013, but still can be useful.
Some links below on FILTERXML and related XPath information so I can more easily find their content back.
Notes:
FILTERXML only supports XPath 1.0- The quotes are huge, for one because I don’t use Excel enough to be an expert, but have enough software experience to sometimes want to use complex concepts in Excel. Having all this in one place helps me with that goal.
- You need to ensure your data is either XML in a well-formed document format, or you can translate your data to well-formed XML.
The links and quotes starting with the question that sparked my interest:
Read the rest of this entry »
Posted in Development, Excel, Office, Office 2013, Office 2016, Office VBA, Power User, Scripting, Software Development, Windows, XML, XML/XSD, XPath | Leave a Comment »
Posted by jpluimers on 2019/11/19
I never thought you could do it, but you can: [Archive.is] Return empty cell from formula in Excel – Stack Overflow.
You have to crate:
- a VBA function
- a reference to a range that evaluates the function so it returns blank
- a cell with a function that blanks the cell using the range
Convoluted, but clever!
–jeroen
Posted in Development, Excel, Office, Office VBA, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2015/01/22
Wow: I feel like having lived under a stone for 8 years, as RosettaCode has been alive since it was founded in 2007 by Mike Mol.
The idea is that you solve a task and learn from that, or learn by seeing how others have solved tasks or draft tasks.
So in a sense it is similar to the Rosetta stone: it has different languages phrasing the same tasks.
There are already a whole bunch of languages on RosettaCode (of which a few are in the categories below), and you can even suggest or add your own languages.
When you want to solve tasks, be sure to look at the list unimplemented tasks by language that leads to automatic reports by language (for instance two of the languages I use most often: C# and Delphi).
I’m sure there are lots of programming chrestomathy sites, even beyond the ones, and it feels very similar to programming kata sites.
–jeroen
Posted in .NET, APL, Awk, bash, Batch-Files, C, C#, C++, COBOL, CommandLine, Delphi, Development, Fortran, FreePascal, Java, JavaScript/ECMAScript, Lazarus, Object Pascal, Office VBA, Pascal, Perl, PHP, PowerShell, PowerShell, Prism, Scripting, sed script, Sh Shell, Software Development, Turbo Prolog, VB.NET, VBS, VBScript, Visual Studio and tools, Web Development | Leave a Comment »
Posted by jpluimers on 2014/08/05
I’ve done a bit of WinWord automation and came across different locations for the API:
New Style:
Old Style:
Fun fact: there is no Old Style Word 2007 documentation any more. You might expect it at http://msdn.microsoft.com/en-us/library/ms263641(v=office.12) but it is not there.
Not so fun fact (and the reason I was looking for the Documents documentation), is because of this big bug ONLY in Office 2010 (it does not occur in Office 2000 .. 2007, and is fixed in 2013): The WordMeister » Bug Word 2010: Documents collection is not correctly maintained.
The only workaround is to run an Office Add-in, or VBA Macro. Both not feasible for external clients.
–jeroen
Posted in Delphi, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Development, Office, Office 2007, Office 2010, Office 2013, Office Automation, Office VBA, Power User, Scripting, Software Development, VBScript | Leave a Comment »
The Wiert Corner - irregular stream of stuff 