Home » Developer & Programmer » Forms » Reading cell value...
Reading cell value... [message #82016] Thu, 10 April 2003 08:15 Go to next message
Victoria
Messages: 152
Registered: July 2002
Senior Member
Hi,
The follwoing piece of code reads only first digit of the cell value for the cells whose format cells property set as custom.But i need the whatever the value available from the cell....

for i in 22..23
loop
for j in 1..6
loop
ole2.add_arg(args, i);
ole2.add_arg(args, j);
cell:= ole2.get_obj_property(worksheet, 'Cells', args);
ole2.destroy_arglist(args);
args:= ole2.create_arglist;
cell_value :=ole2.get_char_property(cell,'Value');
message(cell_value);
end loop;
end loop;

Thanks
~V~

Report message to a moderator

Re: Reading cell value... [message #82019 is a reply to message #82016] Thu, 10 April 2003 08:39 Go to previous message
sir p. coke
Messages: 1
Registered: April 2003
Junior Member
instead of
cell_value :=ole2.get_char_property(cell,'Value');

try this:
cell_value_number := ole2.get_num_property(cell,'Value');

Report message to a moderator

Previous Topic: Re: How can i display the time consume in my processing
Next Topic: incorporate group by clause in block ( D2k-Forms 5.0)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 06 19:42:28 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.