SmlDataRetriever: Better Approach for Retrieving Spreadsheet Data
Return to the SpreadsheetML Screen-Cast SeriesThe new release of Open-Xml-PowerTools includes two new modules:
- SmlDataRetriever – Retrieves a specified table or sheet/range in a simpler XML form
- SmlCellFormatter – Produces formatted text given the raw value from the cell markup, and the SpreadsheetML formatCode
I have developed this module as an interim step in the process of converting SpreadsheetML to HTML/CSS. However, it is useful in its own right, so am releasing this before I've written the rest of the SmlToHtmlConverter module.
The following screen-cast discusses the issues involved, and demos the module: