Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

Search In

How to highlight duplicate values in Google sheet

Hi Guy, I am doing some analysis on my Google sheet (Google Excel). One of the column i.e 'E' of this contain the URLs. Need to highlight all Duplicate URL in same column certain color like RED. I know this is possible. But don't know step for doing

How to Export Data Reports in Excel Using Codeigniter Framework

Excel is a spreadsheet which contains cells in form of rows and columns. We can say it is a computer program which is used to record and manipulate data in rows and columns. In this blog we will learn how export data reports in excel format using Co

How to parse and Excel file in PHP

Hello Reader! If you want to read a Excel file in PHP then you can learn the library code below read('excel_file.xls'); // reads and stores the excel file data // Test to see the excel data stored in $sheets property var_export($excel->sheets

How to Write Image to Excel File in Same Workbook but Different Sheet in Python

I can write all other filed to excel sheet, but not having any luck with writing image to excel sheet.   I am trying to grab image file name from setimage function and that is where i am stuck.   I am not sure how i can use variable fro

Exporting SQL Server table data to Excel

Hi Readers ! In this Blog we will find how we can Export SQL Server table data to Excel using .net code . using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; us

How To Import Excel files into MySQL with PHP

Hellow Reader's ! In This Blog we are going to import excel file into MySql table using PHP. If you have Excel files that need to be imported into MySQL, you can import them easily with PHP. First you need to download Excel reader File. In this b

How to Read Excel file & Insert data into MySQL Database using PHP?

Hello Reader's , Today I am going to give you this blog on how to read excel file and insert data into MySQL DB using PHP.Here we are using php-excel-reader.php library to get excel data in MySQL database. Let's Start. Create Database and

How to use Bottom Sheet in android ?

A Bottom Sheet is a layout that slides up from the bottom side of the screen. This layout slides up on user triggered action. There are two options to implement this functionality, the first one  creates main container view with a BottomSheetBeh

How to remove Blank Rows in Google Spreadsheet?

Hi, While working on Google spreadsheet, I need to delete the blank rows from my sheet, as shown in screenshot below. In the above screenshot in column B, I have Names and after each Name there is an empty row, I want no empty row in between

How to Read Multiple Rows in Excel Sheet by Using XLRD in Python

I am currently using xlrd in python to read excel sheet. In column 1 contains test titles and column 37 contains test step. In column 1, there are some cell values like heading/Test case etc. I want to read all the rows in column 37 which are in bet

prev 1 3 11
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: