Usecase : Extract customer csv data sent weekly via Email and populate it into an existing Excel master report with dynamic columns based on week numbers.

Shambhu Tiwary
The need was to extract customer csv data sent weekly via email and populate it into an existing Excel master report with dynamic columns based on week numbers.

Steps 
  • Get the email's CSV attachment
  • Create some variables and arrays for week numbers and column letters 










Cookie Consent
We serve cookies on this site to analyze traffic, remember your preferences, and optimize your experience.
Oops!
It seems there is something wrong with your internet connection. Please connect to the internet and start browsing again.
AdBlock Detected!
We have detected that you are using adblocking plugin in your browser.
The revenue we earn by the advertisements is used to manage this website, we request you to whitelist our website in your adblocking plugin.
Site is Blocked
Sorry! This site is not available in your country.