|
|
Posted by McHenry on 04/26/06 02:21
"robert" <ab@no.spam-alama-ding-dong> wrote in message
news:%dq3g.1093$yX.546@fe07.lga...
> "Gernot Frisch" <Me@Privacy.net> wrote in message
> news:4b6mcuF10cvr7U1@individual.net...
> |
> | > Can PHP not manipulate the objects that Excel exposes ?
> |
> | php = cross-platform. Excel = Microsoft. No easy way to access COM
> | objects with php.
>
> i've done plenty of com work in php and have only had few occassions where
> it was rough...and that would have been just as rough as with using vba.
>
> other than that, you are *absolutely* correct, gernot! you must pick the
> tool that best fits the job. excel is NOT that tool when it comes to
> getting
> and parsing content from web pages. the only reason that functionality is
> there is so that it can pull in *entire* web content in the form of
> <table></table>...it can't handle any other kind of content by default
> (very
> well)!
The best tool for the job is the one that doe the job as required.
>
> the best solution would be to use sql server (since he's a windows guy),
> hit
> a page, parse it (you can even use regular expressions in sql server now),
> and store it. dts packages work wonders for segmenting and scheduling the
> work. there are downloadable versions of sql server 2k5 that are
> "free-enough" that could be used.
Thanks for telling me what you think the best solution is ??
The process presently works and works well, read the OP and you'll see what
I actually asked, you may find this information useful in answering the
question.
The solution current parses the web page downloaded by Excel and extract
data items and stores them in an SQL Server 2005 db using ADO. I am looking
at migrating this function over to MySQL and PHP hence the original post
which simply asked "can I control Excel objects in php too ?"
>
> then again, i assume he's not a full-time programmer since vb is
> preferable
Rule no 1 Robert, never assume anything, regardless of how good you think it
makes you sound. The old addage... when you assume you make an ASS of U and
ME except this itme you've only made an ASS of U :)
> to vba and wouldn't require excel's cheesy web toolbar to hit the
> internet...he could use vb's cheesy web ocx's. that means he probably
> doesn't have sql server either since it would seem excel is where he
> stores
> his results.
In your mind how did you incorrectly conclude that SQL Server was not used
and results were stored in Excel ? I am curious as I never stated this or
were you just rambling too caught up in the moment to stop and think about
what you wre typing ?
>
> so, your original two sentence reply is entirely correct. "can you
> tounge-kiss a dog? sure you can, *but why would you*?"
>
> cheers
>
>
Navigation:
[Reply to this message]
|