How to check if a shortcode is being executed in a widget or post

Using conditional tag in_the_loop inside your shortcode function may serve the purpose.

if( in_the_loop() ) {
    //add stylesheet for post/page here...
} else {
    //add stylesheet for widget here...
}