Aspose Smart Marker

Aspose.Cells Product Family
1

Hi,

I have created an excel template with two tables side by side. Each table will have a different number of rows.

I have used smart markers to populate the data into the two tables (each table has two columns). Unfortunately, the result is that there are blank rows in the table that has less rows as rows are being inserted for the data.

Example:

Table 1 (has 3 rows) Table 2 (has 6 rows)
Col A | ColB Col C | Col D
1 | 2 1 | 2
2 | 2 2 | 2
3 | 2 3 | 2
blank| blank 4 | 2
blank| blank 5 | 2
blank| blank 6 | 2

How can I get the first table to not repeat the blank rows that are inserted because table 2 has more data? I see there is a parameter called shift but I don’t know how to use it?

Any help is greatly appreciated!

Thanks,

Richard

2

@rpcassidy,

Thanks for the details.

Could you please use “noadd” parameter while defining smart markers in the template Excel file. Do you still find any issue after adding the suggested parameter? If so, kindly do share your template Excel file and paste sample code (runnable) to reproduce the issue, we will check it soon.