Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Auto Populate Smart Marker Data to Other Worksheets if Data Is Too Large
Contents
[
Hide
]
Possible Usage Scenarios
Sometimes you want to auto‑populate smart‑marker data to other worksheets if it is too large. Suppose your data source has 1,500,000 records. These are too many records for a single worksheet; then you can move the rest of the records to the next worksheet.
Auto Populate Smart Marker Data to Other Worksheets if Data Is Too Large
The following sample code uses a data source that contains 21 records. We want to show only 15 records in one worksheet, and the remaining records will automatically move to the second worksheet. Please note that the second worksheet should also have the same smart‑marker tag, and you must call WorkbookDesigner.process(sheetIndex, isPreserved) for both sheets. Please check the Microsoft Access Database file used in this code as well as the output Excel file generated by the code for reference.
Sample Code