Auto Expand Column/Cell Excel Writing in Java

Auto Expand Column/Cell Excel Writing in Java: When you are writing an excel sheet through java program you will come to these kind of requirements. By default excel file will be generated without any auto fit to text or auto column width properties. We need to set the sheet and cell styles/properties for this externally.   Prerequisite: You need all

251 total views, 1 views today

» Read more

Google Webmaster Console Keyword Position Report Program in Java

Google Webmaster Console Keyword Position Report Program in Java: This post will be very helpful for one who has website and already configured in google webmaster console. Google webmaster console is a place whee you can add your sites sitemap and check the keyword position, total impressions and clicks of each keyword details.   This java program will compare current

265 total views, no views today

» Read more

3 Simple Steps to Install Certificate in Java

3 Simple Steps to Install Certificate in Java In java all the certificates should be installed in the below file: C:\Program Files\Java\jre1.8.0_111\lib\security\cacerts Path and version vary based on your own system configuration, path where you installed and version what you installed. You can find a file named “cacerts” which is the one will have all the certificate details installed on

163 total views, no views today

» Read more

How to connect to CPanel Remote MySql in Java ?

How to connect to CPanel Remote MySql in Java ? When you are having your code in local and you want to connect your remote mysql which is in your cpanel, then you need to follow below steps to connect to it.   Step 1: Login to CPanel and Navigate to Remote MySql   Login to cpanel and navigate to

141 total views, 1 views today

» Read more

Remove all special characters except percentage (real time use case)?

How to remove all special characters except percentage (real time use case)? If you are running a coupon website, then you will have this issue sometime while parsing/scrapping coupons from merchants.   For example, you will have these three types of strings: 1. Get 10% Cashback 2. Get Rs. 10/- Cashback 3. Get 10/- Cashback 4. Get (Indian rupee symbol)

112 total views, 1 views today

» Read more

Reading Empty / Blank Cell in Excel using Java

Reading Empty / Blank Cell in Excel using Java: Somedays back I published how to read excel file in java, but one of the user reported me that it is not working as expected when it come across the empty/blank cell(s) in the excel sheet. So I rewritten the excel reading program in java (which also reads or handles empty/blank

126 total views, 1 views today

» Read more

How to read .txt file line by line in Java?

How to read .txt file line by line in Java? .txt file can be read line by line using bufferedreader. BufferedReader takes filereader as input and it takes .txt file as input. readLine() method can be used to find whether any text is there or not in that line or last line is reached using br.readLine()!=null condition and line can

99 total views, no views today

» Read more

XLSX to CSV Convert in Java

XLSX to CSV Convert in Java: We have realtime business scenarios to convert xlsx file to csv file using Java. When I searched for the existing solutions for this usecase I could find some program in github, but the solution can not be used directly, it requires some modifications. I have mentioned the github source code link below for reference.

133 total views, 1 views today

» Read more

5 Ways to Remove Null from ArrayList

5 Ways to Remove Null from ArrayList: Removing null from arraylist become some realtime business scenario many times. Removing null from arraylist is actually easy as it can be. We have many ways to remove null from arraylist.   5 Ways to Remove Null From ArrayList: Using collections.singleton Using removeAll with one null value list Using Iterator Using while loop (rarely used)

115 total views, no views today

» Read more
1 2 3 20