update a CELL value in excel file

[Shain Lee <gs...@yahoo.co.uk>]

Dear Friends, 

I want to modify just a single excel CELL in a "XLS" file. but unfortunately I 
am not a good programmer. Is there any one able to help me by piece of a code 
???? 

From a external shell script I am capturing a random umber and which supposed 
update in the excel file. The location in the excel file is CELL B1. 

Can somebody help me plz, 

Thanks
Shain.

RE: update a CELL value in excel file

[Alex Panayotopoulos <Al...@vianet.co.uk>]

Hi Shain,

Have you found the Busy Developer's Guide to HSSF and XSSF?
http://poi.apache.org/spreadsheet/quick-guide.html

See the section "Reading and Rewriting Workbooks" in particular.

Thanks,
Alex Panayotopoulos

-----Original Message-----
From: Shain Lee [mailto:gsm_linux@yahoo.co.uk] 
Sent: 14 August 2011 07:05
To: user@poi.apache.org
Subject: update a CELL value in excel file

Dear Friends, 

I want to modify just a single excel CELL in a "XLS" file. but unfortunately I 
am not a good programmer. Is there any one able to help me by piece of a code 
???? 

From a external shell script I am capturing a random umber and which supposed 
update in the excel file. The location in the excel file is CELL B1. 

Can somebody help me plz, 

Thanks
Shain.

<font size="2" face="Verdana" color="grey">If you wish to view Brulines Group email disclaimer please <a href="http://www.brulines.com/investors/emaildisclaimer.aspx">click here</a></font>