Excel Writer (JAVA)


package writer;

import java.io.File;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class ExcelWriter
{
                public void writeExcel(String filepath,String values[][]) throws Exception
                {
                                File file = new File(filepath);
                                WritableWorkbook writableWorkbook =null;
                                if(!file.exists())
                                {
                                                writableWorkbook = Workbook.createWorkbook(file);
                                }
                                else
                                                writableWorkbook = Workbook.createWorkbook(file,Workbook.getWorkbook(new File(filepath)));
                                int noOfSheets = writableWorkbook.getNumberOfSheets();
                                writableWorkbook.createSheet("Sheet"+noOfSheets,noOfSheets);
                                WritableSheet writableSheet = writableWorkbook.getSheet(noOfSheets);
                                WritableCellFormat headingCellFormat = getHeadingCellFormat();
                                WritableCellFormat contentCellFormat = getContentCellFormat();
                                int curcol = writableSheet.getColumns();
                                int currow = writableSheet.getRows();
                                for(int j=0;j<values[0].length;j++)
                                                if(curcol<=values[0].length)
                                                                writeCell(writableSheet,headingCellFormat,j,0,values[0][j]);
                                if(currow==0)
                                                currow++;
                                for(int i=1;i<values.length;i++)
                                                for(int j=0;j<values[0].length;j++)
                                                                writeCell(writableSheet,contentCellFormat,j,currow+i-1,values[i][j]);
                                writableWorkbook.write();
                                writableWorkbook.close();
                }

                private WritableCellFormat getHeadingCellFormat() throws Exception
                {
                                WritableCellFormat wcf = new WritableCellFormat(new WritableFont(WritableFont.TIMES,10,
                                                                                                                                                                                                                WritableFont.BOLD,false,UnderlineStyle.SINGLE,Colour.BLACK));
                                wcf.setWrap(true);
                                wcf.setAlignment(Alignment.CENTRE);
                                return wcf;
                }

                private WritableCellFormat getContentCellFormat() throws Exception
                {
                                WritableCellFormat wcf = new WritableCellFormat(new WritableFont(WritableFont.TIMES,10,
                                                                WritableFont.NO_BOLD,false,UnderlineStyle.NO_UNDERLINE,Colour.BLACK));
                                wcf.setWrap(true);
                                return wcf;
                }

                private void writeCell(WritableSheet ws,WritableCellFormat wcf,int col,int row,String str)throws Exception
                {
                                Label label = new Label(col,row,str,wcf);
                                ws.addCell(label);
                }

                public static void main(String[] args)
                {
                                String[][] values = {{"Name","Age","Gender"},{"Ram","24","M"},{"Shyam","36","M",}};
                                ExcelWriter excelWriter = new ExcelWriter();
                                try
                                {
                                                excelWriter.writeExcel("e:\\FileToWrite.xls",values);
                                }
                                catch (Exception e)
                                {
                                                System.err.println("Error Occuered: " + e.getMessage());
                                }
                }
}

Comments

Post a Comment

Popular posts from this blog

Index MySQL datadase table in Solr

Prerequisites Download the following jars. 1. MySQL jar 2. Solr Data Import Handler jar Data Configuration File Create a data-config.xml file in conf folder & add following content to it. <dataConfig>     <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://<host>:<port>/<database name>" user="<user>" password="<password>" batchSize="1" />     <document name="userdoc">         <entity name="userentity" query="select ID, FIRST_NAME, LAST_NAME from users">             <field column="id" name="ID"/>             <field column="first_name" name="FIRST_NAME" />             <field column="last_name" name="L...
Read more

Hibernate Sharding Example

It is a simple implementation of Hibernate Sharding in java. In this we are using two databases i.e. shard1 and shard2. All data related to "India" goes to shard1 where as others go to shard2. Project Contents: File Name Use DatabaseCreator.java Used to create tables in databases named shard1 and shard2. User.java POJO class. User.hbm.xml Mapping file. Used to map POJO to database tables. hibernate0.cfg.xml Hibernate configuration file for database named shard1 hibernate1.cfg.xml Hibernate configuration file for database named shard2 IdGenerator.java Class for Id generation HibernateShardUtil.java Class for loading hiberante session factory. UserShardResolutionStrategy.java Class for implementing shard resolution strategy. UserShardSelectionStrategy.java Class for implementing shard selection strategy. Main.java Clie...
Read more

Shallow Copy

In Shallow copy all the fields are just copied from source object to destination object. If the source object is containing any field that holds a reference to another object then only the reference will be copied i.e. source and destination objects field(that particular field) will point to same memory location. Java code for Shallow Copy package shallow; class JobDescription {     private String designation;     public JobDescription(String designation) {         this.designation = designation;     }     public String getDesignation() {         return designation;     }     public void setDesignation(String designation) {         this.designation = designation;     }     @Override     public String toString() {...
Read more