Skip to main content

Posts

Python openpyxl - Excel Automation Functions

  import openpyxl from openpyxl import Workbook import pandas as pd from openpyxl.utils.dataframe import dataframe_to_rows class Excel_Operation ():     def Create_Workbook ( self , strWorkbookPath ):         """Create New excel workbook in the given folder location         Parameters:         strWorkbookPath (String): Path to store excel workbook         Returns:         Object: Workbook         """         wb = Workbook()         wb.save(strWorkbookPath)         return wb     def Load_Workbook ( self , strWorkbookPath ):         wb = openpyxl.load_workbook(strWorkbookPath)         return wb     def Change_worksheetName ( self , strWorkbookPath , strOldSheetName , strNewSheetName ):         wb = openpyx...
Post a Comment
Read more
Recent posts

Python Selenium Webdriver Function

  #****************************************************************************************************** #Reference Links     #https://selenium-python.readthedocs.io/     #https://selenium-python.readthedocs.io/api.html #******************************************************************************************************* #Import Selenium Webdriver Common from selenium import webdriver from selenium.webdriver.support import expected_conditions as EC from selenium.webdriver.common.by import By import selenium.webdriver.support.ui as ui from selenium.common.exceptions import TimeoutException from selenium.webdriver.chrome.options import Options from selenium.common.exceptions import ElementNotVisibleException from selenium.common.exceptions import NoSuchElementException from selenium.common.exceptions import WebDriverException from selenium.webdriver.common.keys import Keys from distutils.dir_util import copy_tree from selenium import we...
Post a Comment
Read more

VBA uiautomationcore.dll to save internet explorer download

Copy file  C:\Windows\System32\UIAutomationCore.dll  file to users Documents i.e  C:\Users\admin\Documents  then add reference  UIAutomationClient  to your macro file. Paste below code in your module: Option Explicit Dim ie As InternetExplorer Dim h As LongPtr Private Declare PtrSafe Function FindWindowEx Lib "user32" Alias "FindWindowExA" ( ByVal hWnd1 As LongPtr , ByVal hWnd2 As LongPtr , ByVal lpsz1 As String , ByVal lpsz2 As String ) As LongPtr Sub Download () Dim o As IUIAutomation Dim e As IUIAutomationElement Set o = New CUIAutomation h = ie . Hwnd h = FindWindowEx ( h , 0 , "Frame Notification Bar" , vbNullString ) If h = 0 Then Exit Sub Set e = o . ElementFromHandle ( ByVal h ) Dim iCnd As IUIAutomationCondition Set iCnd = o . CreatePropertyCondition ( UIA_NamePropertyId , "Save" ) Dim Button As IUIAutomationElement...
Post a Comment
Read more

Kivy Document

https://github.com/kivy/kivy.git Kivy Innovative user interfaces made easy. Kivy is an open source, cross-platform  Python  framework for the development of applications that make use of innovative, multi-touch user interfaces. The aim is to allow for quick and easy interaction design and rapid prototyping whilst making your code reusable and deployable. Kivy is written in Python and  Cython , based on OpenGL ES 2, supports various input devices and has an extensive widget library. With the same codebase, you can target Windows, macOS, Linux, Android and iOS. All Kivy widgets are built with multitouch support. Kivy is MIT licensed, actively developed by a great community and is supported by many projects managed by the  Kivy Organization .       Installation, Documentation and Examples Extensive installation instructions as well as tutorials and general documentation, including an API reference, can be found at  https://kivy....
Post a Comment
Read more