آموزش کامل اتوماسیون وب و Web scraping

Collapse
X
Collapse
 
  • صفحه از 1
  • زمان
  • نمایش
حذف همه
new posts
قبلی template بعدی
  • mrhartsclube

    • 2017/11/15
    • 130
    • 81.00
    #1

    آموزش کامل اتوماسیون وب و Web scraping

    سلام دوستان

    این مطلب رو اینجا میذارم چون نمیتونم توی بخش آموزشها بذارم، مدیران محترم لطفا منتقل کنن به بخش آموزش (در صورت نیاز)

    خیلی از دوستان مشکل دارن با کار کردن با وب در اکسل و VBA
    این آموزش بصورت جامع این مسائل رو توضیح میده.

    سرفصلهای آموزش:

    • Locate elements using Basic Strategies (ID, Name, Tag, Class)
    • Search for Links using Link Text or Partial Link Text!
    • Master XPath Location strategies and functions for hard to pinpoint elements
    • Deal with Popups, Alerts, Notifications, and Frames like a boss!
    • Utilize Attributes to unearth embedded content
    • Pinpoint elements using Relative or Absolute Xpath
    • Learn the secret benefits of CSS Selectors
    • View and Parse inner HTML document information
    • Use free extensions and tools to locate best Xpath or CSS Selectors
    • Capture Groups of Elements into Arrays, Lists or Straight to Excel!
    • Sort and Remove Duplicates from a List Object
    • Locate all sub-elements of a div, table, or larger parent element
    • Evaluate hidden CSS Properties, such as ‘width’, ‘background-color’, etc
    • Understand Regular Expression (RegEx) patterns and using pattern matching
    • Get element Position and Size and Scroll element into View when necessary
    • Create custom error messages to evaluate comparison (Equality, Contains, NotEquals, Matches, Fail…)
    • Discern the difference between Assert and Verify operators
    • Programmatically hover, click, click and hold, release, right-click and double click with the Mouse
    • Send Keyboard combination presses as well as regular word character presses to the browser
    • Drag and Drop elements or text to another area or drag files for Upload programmatically
    • Control Timeouts and Wait for default settings for PageLoad, Element searches, and Server timeouts
    • Wait for CSS special values change or meet conditions
    • Log In using set credentials to the site
    • Test for the presence of Dialog popups

    • Navigate with Basic Web Controls – Back, Forward, Reload, Close Driver, Close Single page, URLs
    • Save and Load specific user profile for WebDriver execution
    • Enter and Exit specific embedded Frame controls and their HTML content
    • Open, Access and toggle multiple tabs/windows and Select by Index, Title or Window Handle
    • Resize and Position Browser window to user specifications
    • Save Screenshot of Browser, Web Element(s), or entire Desktop to Excel or a file
    • Copy Image directly to Excel OR to Clipboard
    • Change image dimensions and resize
    • Compare multiple image files, generating an image of differences
    • Cast image elements into ActiveX Image Control on worksheet or Userform!
    • Convert Web-Table into TableElement Object and manipulate as an array or directly to Excel
    • Extract specific Web-Table column(s) instead of the whole table!
    • Dynamically select one or more Dropdown or Listbox options programmatically or using mouse clicks
    • Deselect all options or explore ‘Options’ collection and properties


    [CENTER][COLOR=#696969][FONT=lucida console]... [B]Programming [/B]C# - VB.Net - VC++ - ASP.Net - HTML - CSS - JS - AS2 - AutoIt - Pascal - Delphi - PHP - Python - VBA - Etc
    [/FONT][/COLOR][SIZE=2][FONT=lucida console][COLOR=#808080]... 2D & 3D [B]Graphic Designer[/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] 2D & 3D [B]Animator [/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Game [/B]Designer & [B]Hacker [/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] Data [B]Forensic [/B]Expert [/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Ethical [/B]Hacker [/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Pen[/B] Tester

    [/COLOR][/FONT][/SIZE][COLOR=#ff0000][FONT=courier new][SIZE=4][B].: Expert in doing what nobody else can :.[/B][/SIZE][/FONT][/COLOR][/CENTER]
    برچسب ها: هیچ‌کدام
    • chicamika

      • 2016/09/04
      • 89
      • 46.00
      #2
      زبان فارسیه؟

        کامنت

        • mrhartsclube

          • 2017/11/15
          • 130
          • 81.00
          #3
          نوشته اصلی توسط chicamika
          زبان فارسیه؟
          نه زبان انگلیسیه ولی من معتقدم چون کد هست و خروجیش معلومه و میتونید تست کنید میشه متوجه شد چی میگه و کسایی که انگلیسیشون ضعیفه هم راحت متوجه میشن.


          Sent from my iPhone using Tapatalk
          [CENTER][COLOR=#696969][FONT=lucida console]... [B]Programming [/B]C# - VB.Net - VC++ - ASP.Net - HTML - CSS - JS - AS2 - AutoIt - Pascal - Delphi - PHP - Python - VBA - Etc
          [/FONT][/COLOR][SIZE=2][FONT=lucida console][COLOR=#808080]... 2D & 3D [B]Graphic Designer[/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] 2D & 3D [B]Animator [/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Game [/B]Designer & [B]Hacker [/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] Data [B]Forensic [/B]Expert [/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Ethical [/B]Hacker [/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Pen[/B] Tester

          [/COLOR][/FONT][/SIZE][COLOR=#ff0000][FONT=courier new][SIZE=4][B].: Expert in doing what nobody else can :.[/B][/SIZE][/FONT][/COLOR][/CENTER]

            کامنت

            • GHAEMYS
              • 2019/08/18
              • 1
              #4
              نوشته اصلی توسط mrhartsclube
              سلام دوستان

              این مطلب رو اینجا میذارم چون نمیتونم توی بخش آموزشها بذارم، مدیران محترم لطفا منتقل کنن به بخش آموزش (در صورت نیاز)

              خیلی از دوستان مشکل دارن با کار کردن با وب در اکسل و VBA
              این آموزش بصورت جامع این مسائل رو توضیح میده.

              سرفصلهای آموزش:

              • Locate elements using Basic Strategies (ID, Name, Tag, Class)
              • Search for Links using Link Text or Partial Link Text!
              • Master XPath Location strategies and functions for hard to pinpoint elements
              • Deal with Popups, Alerts, Notifications, and Frames like a boss!
              • Utilize Attributes to unearth embedded content
              • Pinpoint elements using Relative or Absolute Xpath
              • Learn the secret benefits of CSS Selectors
              • View and Parse inner HTML document information
              • Use free extensions and tools to locate best Xpath or CSS Selectors
              • Capture Groups of Elements into Arrays, Lists or Straight to Excel!
              • Sort and Remove Duplicates from a List Object
              • Locate all sub-elements of a div, table, or larger parent element
              • Evaluate hidden CSS Properties, such as ‘width’, ‘background-color’, etc
              • Understand Regular Expression (RegEx) patterns and using pattern matching
              • Get element Position and Size and Scroll element into View when necessary
              • Create custom error messages to evaluate comparison (Equality, Contains, NotEquals, Matches, Fail…)
              • Discern the difference between Assert and Verify operators
              • Programmatically hover, click, click and hold, release, right-click and double click with the Mouse
              • Send Keyboard combination presses as well as regular word character presses to the browser
              • Drag and Drop elements or text to another area or drag files for Upload programmatically
              • Control Timeouts and Wait for default settings for PageLoad, Element searches, and Server timeouts
              • Wait for CSS special values change or meet conditions
              • Log In using set credentials to the site
              • Test for the presence of Dialog popups
              • Navigate with Basic Web Controls – Back, Forward, Reload, Close Driver, Close Single page, URLs
              • Save and Load specific user profile for WebDriver execution
              • Enter and Exit specific embedded Frame controls and their HTML content
              • Open, Access and toggle multiple tabs/windows and Select by Index, Title or Window Handle
              • Resize and Position Browser window to user specifications
              • Save Screenshot of Browser, Web Element(s), or entire Desktop to Excel or a file
              • Copy Image directly to Excel OR to Clipboard
              • Change image dimensions and resize
              • Compare multiple image files, generating an image of differences
              • Cast image elements into ActiveX Image Control on worksheet or Userform!
              • Convert Web-Table into TableElement Object and manipulate as an array or directly to Excel
              • Extract specific Web-Table column(s) instead of the whole table!
              • Dynamically select one or more Dropdown or Listbox options programmatically or using mouse clicks
              • Deselect all options or explore ‘Options’ collection and properties



              سلام
              متاسفانه لینک از کار افتاده
              امکانش هست دوباره آموزش رو قرار بدین؟

                کامنت

                • mrhartsclube

                  • 2017/11/15
                  • 130
                  • 81.00
                  #5
                  نوشته اصلی توسط GHAEMYS
                  سلام
                  متاسفانه لینک از کار افتاده
                  امکانش هست دوباره آموزش رو قرار بدین؟
                  سلام دوست عزیز

                  لینک کاملا سالم هست و اگه صفحه ای که براتون میاره انگار داره پیغام خطا میده داره میگه که فایل برای آنتی ویروس گوگل درایو خیلی بزرگه و نمیتونه اسکن کنه Download anyway رو که بزنید فرایند دانلود شروع میشه.
                  راجع به ویروس هم بگم که این فایل یه فایل زیپ هست شامل یه تعدادی فایل ویدیویی و هیچ فایل اجرایی داخلش برای هیچ سیستم عاملی نیست و باعث ویروسی شدنتون نمیشه.
                  [CENTER][COLOR=#696969][FONT=lucida console]... [B]Programming [/B]C# - VB.Net - VC++ - ASP.Net - HTML - CSS - JS - AS2 - AutoIt - Pascal - Delphi - PHP - Python - VBA - Etc
                  [/FONT][/COLOR][SIZE=2][FONT=lucida console][COLOR=#808080]... 2D & 3D [B]Graphic Designer[/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] 2D & 3D [B]Animator [/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Game [/B]Designer & [B]Hacker [/B][/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] Data [B]Forensic [/B]Expert [/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Ethical [/B]Hacker [/COLOR][COLOR=#ff0000][B]|[/B][/COLOR][COLOR=#808080] [B]Pen[/B] Tester

                  [/COLOR][/FONT][/SIZE][COLOR=#ff0000][FONT=courier new][SIZE=4][B].: Expert in doing what nobody else can :.[/B][/SIZE][/FONT][/COLOR][/CENTER]

                    کامنت

                    قبلی template بعدی
                    چند لحظه..