Scenario Description

Users load an Excel file as a format template and initialize lots of cells with data from a database.

Current Limitation

• Using Range API costs much.
  Currently users insert data into cells with Range API in a controller. But through Range API, it also handles notification to the component, read-write lock, and dependent formula re-evaluation which is unnecessary cost when importing. So this approach will have poor performance when the amount of data is large.

• Current Importer doesn't have a proper way to post-process imported book model.

Possible Workaround

Extending ExcelXlsxImporter and overriding imports(InputStream is, String bookName) from AbstractExcelImporter. Then access book model to insert data from a database directly by accessing SCell instead of Range API.