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

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 ...

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 us...

Export data into excel sheet using CakePHP

Hello friends, I am writing this blog which will help you to export data to excel sheet or you can say that it will write data into excel sheet with the help of 'php-export-data-class' library.   Lets start by creating function...

How to generate random number in MS-Excel

Random number generator is used to generate random no as much as you want and also you can specify the range in which you want the numbers.   Steps to use random number generator: Select Data Analysis from them Data menu: ...

Export from a list containing objects to excel file in java

Suppose you have a list containing objects. You can export it to the excel file.  You will require the following jars for this: xmlbeans-2.3.0.jar poi-3.9-20121203.jar poi-ooxml-3.9-20121203.jar poi-ooxml-schemas-3.9-20121203....

Sort and align duplicates valueson the same rows in Excel or Google Spreadsheet?

Hello friend, I found this interesting question on reddit so after answering their I thought to share this with you here doing sorting and align duplicates in excel are both different lets discuss this one bu one separately.   1. ...

How to Find Duplicate Values in Google Sheet or Excel?

Hello Friend, Many times we need to find and remove duplicate data in the spreadsheet and may of us do this task manually. But what if one have a large data containing thousand of columns will you then do this one by one, for me it will be ...

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...

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 r...

How to solve #NUM! error in excel?

Hello friends, Many times while doing a calculation in excel we got stuck with errors such as, #N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! or #NUM!. So here in this blog I am picking up #NUM! error and providing you the solution for this,...

My number value is overwritten by #NUM!

The column which now shows #NUM! had values like 20000, 4000. It earlier had values like mentioned above. I copied a row, pasted it in another row and darn! It got messed up... FYI- This sheet uses Tables.

Blue Line in Excel

Hi Guys, Can anyone tell what is this blue line I am seeing in my excel? This excel has lot of data and formula. Thanks

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...

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.Web...

How to import/export data using CSV in PostgreSQL

To export a table data from Postgres database to a CSV file, use the "COPY to" command. You can create a CSV file using MS-Excel or directly create a file from the command. Syntax: COPY (SELECT * FROM table_name) to E'C:\Users\main\Documents\...
Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: