top of page

VBA-Excel obtain photon cross section

I developed a program using VBA-Excel to extract data from the NIST XCOM website, which provides a database of photon cross sections for various elements, compounds, and mixtures. The program allows users to input a specific element, compound, or mixture and retrieve its corresponding photon cross section data. This data can then be further analyzed and manipulated within Excel, providing valuable insights for researchers and professionals in various fields.

​

Link to the NIST XCOM website.

​

The following image is the NIST XCOM display:

Here is the Excel display:

When the button is clicked, there is a communication between the Excel and the NIST XCOM website. The Excel obtains the data from the NIST XCOM website:

The following gif shows the Excel in progress:

GIF NIST VBA.gif

The Excel file can be obtained clicking here.

bottom of page