package altersheim;
import java.io.File;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import javax.swing.GroupLayout.Alignment;
import javax.swing.border.Border;
import jxl.Cell;
import jxl.LabelCell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.biff.XFRecord;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableCell;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
public class Altersheim
{
public static void main(String[] args)
throws BiffException, IOException, WriteException, InterruptedException
{
WritableFont titelFont = new WritableFont(WritableFont.ARIAL, 17, WritableFont.BOLD,false, UnderlineStyle.NO_UNDERLINE, Colour.AQUA);
WritableCellFormat titelFormat = new WritableCellFormat();
titelFormat.setFont(titelFont);
WritableFont untertitelFont = new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, Colour.BLUE_GREY);
WritableCellFormat untertitelFormat = new WritableCellFormat();
untertitelFormat.setFont(untertitelFont);
SimpleDateFormat format = new SimpleDateFormat("HH:mm:ss");
String getTime = new String(format.format(Calendar.getInstance().getTime()));
WritableWorkbook wworkbook;
wworkbook = Workbook.createWorkbook(new File("C:/Users/rs/Desktop/Altersheim.xls"));
WritableSheet wsheet = wworkbook.createSheet("Messungen Altersheim", 0);
Label Titel = new Label(0, 0, "Messungen Altersheim", titelFormat);
Label timeTitle = new Label(0, 3, "Zeit", untertitelFormat);
Label temp = new Label(1, 3, "Temperatur", untertitelFormat);
wsheet.addCell(Titel);
wsheet.addCell(timeTitle);
wsheet.addCell(temp);
int spalte = 0;
int zeile = 5;
for(int a = 0; a < 10; a++)
{
wsheet.addCell(new Label(spalte, zeile, getTime));
wworkbook.write();
zeile++;
Thread.sleep(0);
}
wworkbook.write();
wworkbook.close();
}
}