Excel Images & Charts
Media in Excel is governed by the DrawingML specification (<xdr:wsDr>). Images and charts sit on a "drawing layer" floating above the cell grid. The worksheet XML contains a <drawing rId="..."/> tag, which points to a drawing XML file, which in turn maps relationships to actual files in xl/media/ or xl/charts/.
These files are specifically designed to test your application's ability to traverse this multi-layered relationship graph, extract the underlying binary image files, and handle dynamic data-driven charts.
pie chart
A standard pie chart.
scatter chart
An XY scatter plot.
column chart
A vertical column chart variant.
bar chart
A data-driven column/bar chart tied to internal cell data.
line chart
A standard line chart for testing series extraction.
logo embedded
A simple file with a single embedded PNG logo to baseline relationship extraction.
dashboard
A complex multi-chart dashboard representing a typical BI report.
image formats
A file mixing both JPEG and PNG formats.
multiple images
A file containing numerous images scattered across the sheet to test iterative extraction.
Frequently Asked Questions
Use Cases
- Testing automated media extraction scripts that pull physical JPEGs and PNGs out of Excel archives.
- Validating relationship parser integrity across the DrawingML namespace.
- Testing data-scraping logic against chart objects and their backing series data.