Excel Groovy Parser

Summary:

This code is to read an excel file in EPM Groovy.

The LXP (Lightweight eXcel Parser) is designed to parse .xlsx files natively. It functions by unzipping the Excel file structure and using optimized regex patterns to parse the internal XML components (Shared Strings, Styles, Worksheets) into a memory-efficient object model. The parser captures basic data points including cell values, comments, indentation levels, and background fill colors, while transparently handling merged cell regions. It gives VBA-Style references (e.g., Range("A1"), Cells(row, col)) allowing easy navigation and extraction data from the excel grid.

I hope this is helpful.