Sim , o Excel pode ler arquivos XML, consulte: Visão geral do XML no Excel :
Overview of how Excel works with XML data
- Adding an XML schema file (.xsd) to a workbook.
- Mapping XML schema elements to individual cells or XML tables
- Importing an XML data file (.xml) and binding the XML elements to mapped cells.
- Entering data, moving mapped cells, and leveraging Excel functionality, while preserving XML structure and definitions.
- Exporting revised data from mapped cells to an XML data file.
Você pode, por exemplo, usar a biblioteca LibXl para ler e gravar arquivos Excel (xml) ou o Biblioteca SimpleXlsxWriter .