How to find out a number of rows coming through from Excel.

Software technical issues not related to any of the other categories

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
babis95
Enthusiast
Posts: 20
Joined: Fri Feb 08, 2019 6:56 pm

How to find out a number of rows coming through from Excel.

Post by babis95 » Mon Nov 11, 2019 12:54 pm

I am trying to get a number of unique rows coming through from Excel to Nice label after i filter them out.

I have a large Excel Database with different order numbers - Which I use in NiceLabel to filter and access set order.
Eg. Order number: 123456789 (I would type that into NiceLabel Filter field to only access rows with that number.
There are 4 rows in the Excel Database with this order number (meaning 4 different labels would be created).

I somehow need to get that '4'(number of rows with that order number) printed on the label (Either header or tail). Is there a way to get this valuer in a variable without manual input?

User avatar
Kyleodonnell
NiceLabel Support
NiceLabel Support
Posts: 720
Joined: Mon Aug 28, 2017 3:07 pm

Re: How to find out a number of rows coming through from Excel.

Post by Kyleodonnell » Mon Nov 11, 2019 1:32 pm

Babis95,

This could be done with a powerform as the form can save the number of rows selected to a variable. However, this cannot be done in the designer as it uses a data initialization object which does not have that option

babis95
Enthusiast
Posts: 20
Joined: Fri Feb 08, 2019 6:56 pm

Re: How to find out a number of rows coming through from Excel.

Post by babis95 » Mon Nov 11, 2019 4:12 pm

Thank you

Post Reply