Posts

Python Selenium click code

Using class name and JavaScript Method:
driver.execute_script("document.getElementsByClassName('value')[0].click()")

Using ID name and JavaScript Method:
driver.execute_script("document.getElementById('btnOneViewBack').click()")

Normal method:
driver.find_element_by_class_name('value').click()

Excel fill empty cell with above value

In some cases your sheet might have a column where the value is present only one time for a set of values. It happens when you export the report with group by option in SQL.

So we would like to have all our rows to have the corresponding value. Let's see how this can be done in Excel.

1. Select the column which you want to fill the empty cell with the value above. Only select the range which you want to fill. To select the range first click on the start cell and press F5. Then enter the last value, for example if the last value is in 500th row, then enter A500 and press SHIFT and OK.

2. Once the range of rows are selected, Click on Home -> Find & Select  ->  Go To Special. In Go To Special dialog box will appear, then check Blanks option.

3. Once you click OK the blank cells will be selected. On the blank cell enter the formula for above cell. For example: if value is in A3, enter A3 in the blank cell and press CTRL + ENTER.

Costliest phone from Samsung that you can buy in India

Every year Samsung showcase their new flagship phone. This year we have bezel less flagship phone Galaxy S8. Now it is available for sale from major retail and e-tail.

Galaxy S8 cost you ₹57,900, however the costliest phone from Samsung is it's Galaxy Note 7 with the price tag of ₹62,900. Galaxy Note 7 shipping has been stopped due to the reported battery problem. This leaves us with Galaxy S8 as their costliest phone for now.

Other S series from Samsung Galaxy costed about 30k to 40k range. Galaxy Note 8 is expected to release this year which will costlier than S8.
Features of Galaxy S8: 8MP Front-Facing Camera Take clearer, sharper, more detailed selfies with Samsung’s best smartphone camera yet.
Fingerprint Scanner
Easily unlock your device using a new fingerprint scanner on the back of the device.
Water & Dust Resistance With an IP68 water resistant rating, the Samsung Galaxy S8 can resist a splash or accidental dunk.
Bixby Bixby Vision - Intelligent Interface with natural…

Python Selenium code to scrape Craiglist

This code will post ads on you behalf. You need to make changes in variables to be modified section.

from __future__ import print_functionfrom selenium import webdriverfrom selenium.common.exceptions import NoSuchElementExceptionfrom selenium.webdriver.common.keys import Keysimport time
#Variables to be modifiedemail="Your Email"psswd="You Password"title="Title of the post"location="Atlanta"postal_code= "30303"post_body = "Content Goes Here"
driver = webdriver.Chrome('C:\Python27\chromedriver')driver.get("https://accounts.craigslist.org/login")
#fill login formtime.sleep(3)element = driver.find_element_by_xpath('//*[@id="inputEmailHandle"]')element.send_keys(email)element = driver.find_element_by_xpath('//*[@id="inputPassword"]')element.send_keys(psswd)element = driver.find_element_by_xpath('/html/body/section/section/div/div[1]/form/div[3]/button')time.sleep(3)element…

Sikuli for Windows 10 install

For installing Sikuli in Windows 10, first you need Java JRE 6 and user Sikuli Version.

Sikuli - Sikuli-X-1.0rc2-win32
Java JRE - jre-6u45-windows-i586

Above two file name is IMPORTANT. I have tried with different combination but failed. So just use the above two binaries in Windows 10.

To download Sikuli: Go to this link https://launchpad.net/sikuli/sikulix/x1.0-rc2 and download for you platform. I prefer to use portable version.

To download Java 6: Go to this link http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase6-419409.html#jre-6u45-oth-JPR

Download JRE not jdk. You need to register to Oracle website in-order to download this.


Hello Kitty theme for Vivo Y51

Image
Download Hello Kitty theme for Vivo Y51. Below is the download link for itz file.

Mega Download Link - https://mega.nz/#!BFsnHbpT!0bu4eIgfbudRtLV4sJlNKmopyPlyYO9BkbqjNRil6xA


Theme Name - hello kitty v2 by Me.itz
Theme Size - 13.3 MB

Below are few screenshots of the theme.



Oppo F1s after update 6.0 Font change option available?

After updating Oppo F1s to Android 6.0 you will lose the font change option. Below are the list of changes that will happen after you update your Oppo F1s to Android 6.0.

Added:
Transparent Status Bar

Camera Blur Effect on Front Camera

Search feature when you swipe up on home screen

New Category on Album for Rarely Used Photos

New Category on Album for Recently Deleted Photos

Unknown Sources on Messages

Panorama for Front Camera

Google Duo

Removed:
Video multi-tasking

1st panel on music player for playlist

Font Style Changing

Replaced:
Google Calendar replace Color OS Stock Calendar

Others:
Better Photo preview on album

Faster Capturing of pictures

App icon on home screen automatically arrange itself

Better Overall User Interface

Better Battery Performance

Camera is better on Lollipop version

Contact thumbnail is disable by default, just enable it on settings.