cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JP4
Level 8
Report Inappropriate Content
Message 1 of 4

Detecting number of rows in excel files

Hello,

for a DLP deployment I would like to detect sending a MS Excel file (.xlsx) wih more than 50 rows. If an endpoint user sends an email containing .xlsx file with more than fifty rows, I want to be notified.

I have tried detecting the number of rows using different regex patterns, but I have not been succesfull, because it seems that the usual end of line unprintable characters (like \n) are not used in excel. Could anyone please advice me on this matter?

Thank a lot.

Jan

Labels (2)
3 Replies
jsubbura
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 4

Re: Detecting number of rows in excel files

Hi @JP4 ,

Thank you for writing in here. 

Can those 50 rows contain any data in them or they will contain any specific data in them?

 

Regards,
Jithendran S
McAfee Employee
JP4
Level 8
Report Inappropriate Content
Message 3 of 4

Re: Detecting number of rows in excel files

Hi, there could be any data at all, the goal is to know if there are more than 50 rows.

jsubbura
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: Detecting number of rows in excel files

Hi @JP4 ,

DLP Endpoint uses Google Re2 regex patterns. 

Is your pattern validated successfully in any online regex validators? If so DLP should also validate the same.

If you are looking to write a regex pattern to identify 50 rows in excel then we advise you to get in touch with McAfee Professional Services who can help you with the regex pattern creation.

If you have a pattern and its validated in regex validators and not working only in DLP you can share us your regex pattern and the validation results so that we can look more into it.

 

Thank you.

Regards,
Jithendran S
McAfee Employee
You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community