Tuesday, May 24, 2011

how to find difference between two dates in java

public String getTimeDiff(Date dateOne, Date dateTwo) {
String diff = "";
long timeDiff = Math.abs(dateOne.getTime() - dateTwo.getTime());
diff = String.format("%d hour(s) %d min(s)", TimeUnit.MILLISECONDS.toHours(timeDiff),
TimeUnit.MILLISECONDS.toMinutes(timeDiff) - TimeUnit.HOURS.toMinutes(TimeUnit.MILLISECONDS.toHours(timeDiff)));
return diff;
}

Wednesday, April 13, 2011

convert excel file to .csv file

import java.io.*;
import jxl.*;
import java.util.*;

class ConvertExcelToCSV
{
public static void main(String[] args)
{
try
{
String filename = "C:/Documents and Settings/motidara/Desktop/test.xls";
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale("en", "EN"));
Workbook w = Workbook.getWorkbook(new File(filename),ws);

File f = new File("C:/Documents and Settings/motidara/Desktop/new.csv");
OutputStream os = (OutputStream)new FileOutputStream(f);
String encoding = "UTF8";
OutputStreamWriter osw = new OutputStreamWriter(os, encoding);
BufferedWriter bw = new BufferedWriter(osw);


for (int sheet = 0; sheet < w.getNumberOfSheets(); sheet++)
{
Sheet s = w.getSheet(sheet);


bw.write(s.getName());
bw.newLine();

Cell[] row = null;

for (int i = 0 ; i < s.getRows() ; i++)
{
row = s.getRow(i);

if (row.length > 0)
{
bw.write(row[0].getContents());
for (int j = 1; j < row.length; j++)
{
bw.write(',');
bw.write(row[j].getContents());
}
}
bw.newLine();
}
}
bw.flush();
bw.close();
}
catch (Exception e)
{
System.err.println(e);
}

}
}

Friday, December 24, 2010

How To set Frame Icon in java

private void loadFrameIcon() {
URL imgUrl = null;
ImageIcon imgIcon = null;
imgUrl = MainMenu.class.getResource("flr..png");
imgIcon = new ImageIcon(imgUrl);
Image img = imgIcon.getImage();
this.setIconImage(img);
}