• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Pixcels.nl

  • Home
  • Categories
    • Excel apps
    • Pivottable stuff
    • PowerBI stuff
    • RGS en auditfiles
    • Sheet stuff
    • Userform stuff
    • VBA stuff
    • VBE stuff
    • XML stuff
  • About
You are here: Home / Archives for xml

xml

AuditfileValidator for Excel: validate and inspect Xml auditfiles

2020/09/20 by Frans

AuditfileValidator is an Excel addin that validates the most common auditfile formats and versions (XAF, XAS, XAA, SAF-T, etc) against their schema, and presents an overview of the most important properties of the auditfile.

[Read more…] about AuditfileValidator for Excel: validate and inspect Xml auditfiles

Filed Under: Excel apps, RGS en auditfiles Tagged With: auditfiles, validate, xml

Een postcodetabel op basis van BAG Extract 2.0

2020/07/28 by Frans

In de Basisregistratie Adressen en Gebouwen (BAG) beheert het Kadaster alle adressen die in Nederland voorkomen. In de BAG wordt bij een adres ook de postcode van PostNL vastgelegd, en dus moet het mogelijk zijn om o.b.v. de BAG een postcodetabel van Nederland samen te stellen.

[Read more…] about Een postcodetabel op basis van BAG Extract 2.0

Filed Under: XML stuff Tagged With: BAG, postcode, xml

Excel and XML: four observations and two bugs

2013/10/22 by Frans

I have been working with Xml files in Excel for some time now, and thought it is time to share some observations. [Read more…] about Excel and XML: four observations and two bugs

Filed Under: XML stuff Tagged With: schema, Table, xml, XPath

Create Xml from Schema

2013/10/04 by Frans

In this post I describe a tool to create an Xml file from a schema (Xsd) using VBA and the DOM and SOM objects of the Microsoft XML library MSXML version 6. [Read more…] about Create Xml from Schema

Filed Under: XML stuff Tagged With: MSXML, schema, SOM, xml

Get XPaths from workbook – update

2013/09/03 by Frans

In Get XPath objects from Excel workbook I described a method to retrieve all mapped XPaths from a workbook. In this post I describe another method, using the Worksheet.XmlMapQuery function. It’s simpler, and faster.

[Read more…] about Get XPaths from workbook – update

Filed Under: XML stuff Tagged With: xml, XPath

Sepa Direct Debits: from Excel to Pain

2013/06/18 by Frans

Europe is preparing for SEPA, the Single Euro Payments Area. One of the SEPA goals is to replace all national direct debit standards by one XML based SEPA standard by 1 February 2014. This article shows how to create such an Xml file from Excel, without scripting. [Read more…] about Sepa Direct Debits: from Excel to Pain

Filed Under: XML stuff Tagged With: Direct Debit, PAIN.008, SEPA, xml

Get XPath objects from Excel workbook

2013/06/06 by Frans

When working with XML enabled workbooks the relevant objects and properties are easy to retrieve. Unfortunately a workbook has no built-in collection of XPath objects. How can we get a list of all XPath objects in a workbook? [Read more…] about Get XPath objects from Excel workbook

Filed Under: XML stuff Tagged With: xml, XPath

Primary Sidebar

Recent posts

  • The Grand Totals range of a pivottable in Excel
  • Replace drill-through for Power Pivot and Power BI pivottables in Excel
  • AuditfileValidator for Excel: validate and inspect Xml auditfiles
  • SAF-T auditfiles for test and development
  • Een postcodetabel op basis van BAG Extract 2.0

Recent comments

  • Harry Cuntapay on Replace drill-through for Power Pivot and Power BI pivottables in Excel
  • Lucio on Disable Shift key on open
  • Lucio on Disable Shift key on open
  • Julius Peter on The sequence of events in workbooks
  • Ben on The sequence of events in workbooks

Categories

Tags

ActiveControl ActivePrinter ADCS auditfiles BAG Connection Custom tab Database Debug Direct Debit drill-through Events event trapping Focus IBAN ISO 21378 MDI MSXML Multiple Document Interface normalize PAIN.008 PivotTable postcode Power BI RGS Ribbon SAF-T schema SEPA SOM Table Userforms validate VBA XAF xml XPath

Copyright © 2023 · eleven40 Pro on Genesis Framework · WordPress · Log in