You can run sql query on excel
Example :
SELECT [PO],[Product], sum(Qty) as quantity,sum(`Line Item`) as lineitem
from [Sheet1$]
group by [PO],[Product]
Excel Connection String :
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%excelfile%;Extended Properties="Excel 12.0 Xml;HDR=yes";
If you use gmail, you have to turn on
Allow less secure apps to access your Gmail account
https://devanswers.co/allow-less-secure-apps-access-gmail-account/
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.