A guide to read excel file using Python

This tutorial shows a guide on how to read excel file using Python. We know that excel is great for generating reporting data. It also allows us to perform calculation on data, build complex formula which could be used to apply on different data. You can use this easily accessible excel tool to organize, analyze and store your data in tables. What’s more, this software is widely used in many different application fields all over the world and it also applies to data science.

We have seen various operations on excel files using wonderful API – Apache POI in Java technology and it requires few more code has to be written to read from or write to excel files.

But to read excel file using Python is very easy with a few lines of code. We will use a sample excel file here to read the excel file. You may also download the sample excel file through Google search and give it a try.

Let’s move on to the example…

Continue reading “A guide to read excel file using Python”

A guide to read excel file using Python was last modified: June 14th, 2018 by Soumitra Roy Sarkar

Generate Excel Report from MySQL Database using Codeigniter

Here we will see how to generate excel report from MySQL database using Codeigniter. Codeigniter is one of the popular PHP framework for web applications and it’s easy to work with Codeigniter for building web applications.

Why excel reporting?

Most people in your organization are likely to be familiar with excel, hence it ensures a short (or nonexistent) learning curve during implementation.

It allows you to use templates and formulas to aggregate data.

It has very easy-to-use charting functionality compared to other software, and several helpful built-in features.

It is also great because you have the ability to cut and paste into reports. Most people write reports in Word, so it’s easy to cut and paste data or charts from Excel into Word.

Here we will create a web application to generate excel report from MySQL database using Codeigniter.

We will create a table in MySQL database and retrieve the records from the table and display on a web page in table format. We will provide a hyper link to generate the excel file from the table data. You will be given a popup asking to save the generated excel file. Then you can choose your convenient location for saving the file.

Continue reading “Generate Excel Report from MySQL Database using Codeigniter”

Generate Excel Report from MySQL Database using Codeigniter was last modified: June 4th, 2018 by Soumitra Roy Sarkar

How to Convert CSV to XML using PHP

The example, convert csv to xml using PHP , shows conversion of csv data to xml data. As the title suggests to convert csv to xml using PHP, so we will convert either csv file to xml file or csv string to xml string. When we convert csv string to xml string you will see the output on the browser and when we convert csv file to xml file then you will see the xml document saved into a file on the physical drive location. So here in this example we will see both examples that may help you to choose the example according to your situations.

People working with different types of data may come across the problem that they need to convert between different data formats. Comma Separated Values (CSV) and the Extensible Markup Language (XML) are the most widely used formats for data, and conversion between these two formats needs often to be accomplished. Especially to XML, because this format is very well supported by modern applications, and is very well suited for further data manipulation and customization.

Continue reading “How to Convert CSV to XML using PHP”

How to Convert CSV to XML using PHP was last modified: May 28th, 2018 by Soumitra Roy Sarkar

How to Convert XML to CSV using PHP

The example, convert xml to csv using PHP , shows conversion of xml data to csv data. As the title suggests to convert xml to csv using PHP, so we will convert either xml file to csv file or xml string to csv string. When we convert xml string to csv string you will see the output on the browser and when we convert xml file to csv file then you will see the csv document saved into a file on the physical drive location. So here in this example we will see both examples that may help you to choose the example according to your situations.

People working with different types of data may come across the problem that they need to convert between different data formats. Extensible Markup Language (XML) and Comma Separated Values (CSV) are the most widely used formats for data, and conversion between these two formats needs often to be accomplished. Especially to XML, because this format is very well supported by modern applications, and is very well suited for further data manipulation and customization.

Continue reading “How to Convert XML to CSV using PHP”

How to Convert XML to CSV using PHP was last modified: May 28th, 2018 by Soumitra Roy Sarkar

Generate PDF Report from MySQL Database using Codeigniter

Here we will see how to generate pdf report from MySQL database using Codeigniter. Codeigniter is one of the popular PHP framework for web applications.

PDF format reports allows professionals to edit, share, collaborate and ensure the security of the content within digital documents.

Reports are mostly generated in PDF format because a PDF file is a “read only” document that cannot be altered without leaving an electronic footprint whereas other formats like image, word, excel etc. can easily be altered without leaving an electronic footprint.

PDF files are compatible across multiple platforms whereas a word document may not be viewable easily in Mac system.

Here we will create a web application to generate report from MySQL database using Codeigniter. We will create a table in MySQL database and retrieve the records from the table and display on a view in table format. We will provide a hyper link to generate the PDF from the table data. You will be given a popup asking to save the generated pdf file. Then you can choose your convenient location for saving the file.

Continue reading “Generate PDF Report from MySQL Database using Codeigniter”

Generate PDF Report from MySQL Database using Codeigniter was last modified: May 25th, 2018 by Soumitra Roy Sarkar

Generate HTML Table from MySQL database using Codeigniter

Here is an example showing you how to generate HTML table from MySQL database using Codeigniter. We will write here an example to create a table from a multi-dimensional array. The Table Class provides functions that enable you to auto-generate HTML tables from arrays or database result sets.

Here we will create a web application to generate HTML table from MySQL database using Codeigniter. We will create a table in MySQL database and retrieve the records from the table and display on a view in table format.

Continue reading “Generate HTML Table from MySQL database using Codeigniter”

Generate HTML Table from MySQL database using Codeigniter was last modified: May 5th, 2018 by Soumitra Roy Sarkar

MongoDB PHP 7 CRUD Example

We know MongoDB is very popular open source, document based NoSQL database. In this tutorial we will create MongoDB PHP 7 CRUD Example.  CRUD means Create, Read, Update and Delete operations. So basically you will add new data (create), fetch data (read), edit existing data (update) and remove existing data (delete) from database.

Please make sure you have read how to configure MongoDB with PHP 7 for XAMPP before reading MongoDB PHP 7 CRUD Example.

Continue reading “MongoDB PHP 7 CRUD Example”

MongoDB PHP 7 CRUD Example was last modified: April 30th, 2018 by Soumitra Roy Sarkar

Search AutoComplete using Codeigniter jQuery

Here in Codeigniter jQuery AutoComplete example we will see how to do search AutoComplete using Codeigniter jQuery.  Autocomplete allows you to easily create autocomplete and auto-suggest boxes for text input fields. When you start a search on Google or other search engines, you can find the information you are looking for using search predictions. Search predictions are possible search terms you can use that are related to the terms you are typing and what other people are searching for.

Autocomplete is a feature in which an application predicts the rest of a word a user is typing. In graphical user interfaces, users can typically press the tab key to accept a suggestion or the down arrow key to accept one of several.
Autocomplete speeds up human-computer interactions when it correctly predicts the word a user intends to enter after only a few characters have been typed into a text input field. The autocomplete is a normal text input enhanced by a panel of suggested options.

Continue reading “Search AutoComplete using Codeigniter jQuery”

Search AutoComplete using Codeigniter jQuery was last modified: April 26th, 2018 by Soumitra Roy Sarkar

Configure MongoDB with PHP 7 for XAMPP on Windows

This tutorial will show you how to configure MongoDB PHP 7 for XAMPP on Windows. XAMPP is an open source, easy to install Apache distribution containing PHP, Perl and MySQL. It’s very easy to install after downloading the Windows exe inataller file.

MongoDB is one of the widely used NoSQL(Not only SQL) database in market today. MongoDB is a document database with the scalability and flexibility that you want with the querying and indexing that you need. Often we come across a situation where we end up using MongoDB with PHP in XAMPP stack.

Continue reading “Configure MongoDB with PHP 7 for XAMPP on Windows”

Configure MongoDB with PHP 7 for XAMPP on Windows was last modified: April 30th, 2018 by Soumitra Roy Sarkar

Disable Bitlocker Recovery on Windows Startup

This tutorial will show you how to disable Bitlocker Recovery option in Microsoft Windows 10 Home edition. If you have Microsoft account and if you used the same credentials while installing or factory resetting your Windows 10 operating system then you can easily get the Bitlocker Recovery key using your Microsoft account. But the problem is every time you start your system you have to input the Recovery key and it’s really annoying or irritating. So here I am going to tell you different solutions to turn off Bitlocker Recovery in Windows 10 Home edition.

Continue reading “Disable Bitlocker Recovery on Windows Startup”

Disable Bitlocker Recovery on Windows Startup was last modified: April 21st, 2018 by Soumitra Roy Sarkar