• 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 Categories / XML stuff

XML stuff

SAF-T auditfiles for test and development

2020/09/04 by Frans

Most test and demo auditfiles that are available on the internet are incomplete and invalid. In this post I present a maximal SAF-T auditfile which is valid and contains all possible data elements. I also explain how to create this file and it’s minimal variants.

[Read more…] about SAF-T auditfiles for test and development

Filed Under: RGS en auditfiles, XML stuff

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

Improvements on SAF-T, OESO’s Standard Audit File for Tax

2020/07/23 by Frans

SAF-T (Standard Audit File for Tax) is an international standard for electronic exchange of accounting data. In this post I propose some improvements for SAF-T version 2.00.

[Read more…] about Improvements on SAF-T, OESO’s Standard Audit File for Tax

Filed Under: RGS en auditfiles, XML stuff Tagged With: SAF-T

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