Java

prithaa wrote:

Is there an article to open an excel file

prithaa wrote:

a new file is created instead of opening the old file.

InputStream inp = new FileInputStream("d:/Writefile.xls");    
		WorkbookSettings ws = new WorkbookSettings();
		Workbook wb = Workbook.getWorkbook(inp, ws);
		Sheet sheet = wb.getSheet(0);  
		//Cell cells[] = sheet.getRow(0);     
		//Cell cell = cells[0];
		//String cellContents = cell.getContents(); 
		//Modify the cellContents here     
		//Write the output to a file 		
		Number number;
		number = new Number(0, 0, 453.25, times);
		((WritableSheet) sheet).addCell(number);
		wb.close();

((WritableSheet) sheet).addCell(number);

WritableWorkbook creates a new workbook and has no method which opens a workbook

workbook

prithaa wrote:

thanks for the article

prithaa wrote:

but i cant still open a writableworkbook

Workbook workbook = Workbook.getWorkbook(new File("d:/Writefile.xls"));
WritableWorkbook copy = Workbook.createWorkbook(new File("d:/Writefile1.xls"), workbook);
copy.write();
WritableSheet sheet = copy.getSheet("Report2");
Number number;
number = new Number(0, 0, 453.25, times);		
sheet.addCell(number);
copy.write();
copy.close();

praveen2609 wrote:

there is one class which is reading data from one of the udp socket another class is their which accepts the tcp connection from every client request and creates a thread for every client and request the same udp class