I am trying to update an Excel File by using following query(s):
update Sheet1 set Region='Central' where serial='4'
update Sheet1 set Region='Central' where serial=6
update Sheet1 set Region='North' where serial=8.0
update Sheet1 set Region='North' where serial='10.0'
But no query is updating the data in the file. It is a simple MS-Excel 2003 File.
Please Help.
Have a good day.
|
Passed test for the following sqls:
select * from sheet1;
update Sheet1 set Region='Central' where serial='4';
update Sheet1 set Region='Central' where serial=6 ;
update Sheet1 set Region='North' where serial=8.0 ;
update Sheet1 set Region='North' where serial='10.0' ;
select * from sheet1;
The echo message is:
select * from sheet1
Region JAVA_OBJECT 0 0 0
serial JAVA_OBJECT 0 0 0
null 4.0
null 6.0 null 8.0
null 10.0
The total row number of resultset: 4
1:update Sheet1 set Region='Central' where serial='4'
2:update Sheet1 set Region='Central' where serial=6
3:update Sheet1 set Region='North' where serial=8.0
4:update Sheet1 set Region='North' where serial='10.0'
1:0
2:1
3:1
4:1
select * from sheet1
Region JAVA_OBJECT 0 0 0
serial JAVA_OBJECT 0 0 0
null 4.0
Central 6.0
North 8.0
North 10.0
The total row number of resultset: 4
If you failed still, you can upload your xls sample.
|
Main
webmaster@hxtt.com