You can export all input cells (which does not contain formulas) with a specific background into text file. This feature is useful, when you need to transfer user's data between different versions of your spreadsheet.
This export procedure is called from VBA macro. Method LockXLSRuntime.ExportCellsByColor( <workbook>, <ColorIndex>, <FilePath>) exports all input cells from passed workbook with specified ColorIndex of the background into file. You may pass empty string as file path. In this case LockXLS Runtime asks customer to select a file.
Example of exporting all cells without background color:
In this example we use Color Index of the background of cell A1. As we know that in our spreadsheet this cell does not have a background color.