phpexcel - PHP Excel - extracting data to a variable -

-

i've been working phpexcel, , have been able take dataset data , create arrays on large data sets. if want allow client draw data single cell, can't seem make work.

what i'm looking take data single cell in excel , place in php variable.

assuming you're using phpexcel library.

to "raw" cell value:

$cella1value = $objphpexcel->getactivesheet()->getcell('a1')->getvalue();

or calculated value cell containing formula:

$cellb2value = $objphpexcel->getactivesheet()->getcell('b2')->getcalculatedvalue()

or formatted value cell:

$cellc3value = $objphpexcel->getactivesheet()->getcell('c3')->getformattedvalue()

Popular posts from this blog

Php - Delimiter must not be alphanumeric or backslash -

-
this question has answer here: delimiter must not alphanumeric or backslash , preg_match 5 answers this question has been asked don't know how fix problem in situation. getting following php errror: php message: php warning: preg_match(): delimiter must not alphanumeric or backslash in... on line 227 line 227 following: if (preg_match($match, $_server['http_user_agent'])) and function: $oslist = array ( 'windows 3.11' => 'win16', 'windows 95' => '(windows 95)|(win95)|(windows_95)', 'windows 98' => '(windows 98)|(win98)', 'windows 2000' => '(windows nt 5.0)|(windows 2000)', 'windows xp' => '(windows nt 5.1)|(windows xp)', 'windows server 2003' => '(windows nt 5.2)', 'windows vista' => '(windows nt 6.0)', 'w...
Read more

Delphi interface implements -

-
i expect reference counting should work on outer aggregating object in interface implementation. if can refer example: clarity in classes implementing multiple interfaces (alternative delegation): here minimal reproduction of behaviour: program so16210993; {$apptype console} type ifoo = interface procedure foo; end; tfooimpl = class(tinterfacedobject, ifoo) procedure foo; end; tcontainer = class(tinterfacedobject, ifoo) private ffoo: ifoo; public constructor create; destructor destroy; override; property foo: ifoo read ffoo implements ifoo; end; procedure tfooimpl.foo; begin writeln('tfooimpl.foo called'); end; constructor tcontainer.create; begin inherited; ffoo := tfooimpl.create; end; destructor tcontainer.destroy; begin writeln('tcontainer.destroy called');//this line never runs inherited; end; procedure main; var foo : ifoo; begin foo := tcontainer.create; foo.foo; end; begin main; readln...
Read more

How to do NTLM Authentication using Indy 10 in Delphi 7? -

-
i want ntlm authentication indy 10 components in delphi 7 . here source code : uses windows, messages, sysutils, variants, classes, graphics, controls, forms, dialogs ,stdctrls, idbasecomponent, idcomponent, idtcpconnection, idtcpclient, idhttp,idauthenticationsspi , idauthentication , idauthenticationdigest , idheaderlist; procedure tform1.button1click(sender: tobject); begin memo1.lines.add( idhttp1.get('http://www.google.co.in')); end; procedure tform1.idhttp1proxyauthorization(sender: tobject; authentication: tidauthentication; var handled: boolean); var username: string; usernamelen: dword; begin authentication.username := 'xxxxx'; authentication.password := 'xxxx'; handled := false; // tried setting true , no changes in error end; procedure tform1.idhttp1selectproxyauthorization(sender: tobject; var authenticationclass: tidauthenticationclass; authinfo: tidheaderlist); begin // first check ntlm au...
Read more