Category: File

Merge/Unmerge Cells In this example I am going to show you how to merge and unmerge cells in excel sheet using Python script. You can merge two or more columns in a single row or multiple rows in excel file. For merging cells you need to specify the range of rows and columns in the…

Borders in Excel File In this example I am going to show you how to create borders in excel file. I will create two sheets in the same excel file. In one sheet I will show how to create borders around rows and columns without writing any text. In the other sheet I will show…

Introduction Here I am going to show you how to insert line break in excel cell data using Apache POI in Java language. There may be requirements where you need to write long text in a cell or in multiple cells of excel file, but the long text is not fit within the view port…

Introduction In this short example code I will show you how to create a new file for writing into it or if the file already exists then append to it instead of creating a new file using Java programming language. If you have a requirement that either you need to log some data into an…

Table of Contents Introduction Prerequisites Project Setup Detect Hidden Rows/Cells in Excel Java Code Testing Hidden Rows/Cells Source Code Introduction Here in this example I am going to show you how to detect hidden rows in excel file using Apache POI library with the help of Java program. The following data are used in the…

Table of Contents Introduction Prerequisites Project Setup Merge Cells in Excel Testing Merged Cells Source Code Introduction Here I am going to show you how to merge cells in excel sheet using Apache POI in Java programming language. In other words I will merge two or more columns from single row or multiple rows in…

Introduction Here in this tutorial example, I will show you how to download large file in PHP program. Generally, when you download a file, your file is stored into file system or you load it into memory as a byte array. This is not a problem when you deal with a small file but when…

Introduction Apache POI is the most popular library when comes to manipulate word, excel, ppt based documents. In this example I am going to show you how to read large excel file using Apache POI library. Your large excel file may contain various kind of information, such as, Human Resource data, Sales data, Credit Cards,…

Introduction Here I am going to show you how to use AJAX in Django framework and how to upload files using Django jQuery and AJAX. This example can be used to upload both single and multiple files to the server. Only thing is you need to select single file if you want to upload only…

Here I am going to show an example how you can add images to word file in Python programming language. Generally you write headings, paragraphs, etc. to describe an event or something in the word file. To explain better pictorially about the same thing you need to insert or add images. python-docx is a Python…

In this tutorial I will show you how to upload single and multiple files using PHP based CodeIgniter framework 4. In many enterprise applications files upload is an important task for various purposes. CodeIgniter makes working with files uploaded through a form much simpler and more secure than using PHP’s $_FILES array directly. This extends…

Most of the applications require at least one file needs to be upload for a reason, such as, for uploading bulk data or processing file data for business requirement. This example will show you how to upload single or multiple files using Django REST framework. REST is an acronym that stands for Representation State Transfer…