Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-867

Import cell data from a database upon an Excel file as a template

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: 3.6.0
    • Fix Version/s: 3.8.3
    • Component/s: None
    • Security Level: Jean
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              henrichen henrichen
              Reporter:
              hawk hawk
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: