RE: AW: Word COM Object

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



No prob, hope it helps.   Usually, if Word or whatever application you're working with knows how to do something then usually you can work it backwards (start with the finished product and trace it back a little) to figure out how they do it or what standard they use get the job done.  Sometimes there are some special little codes that aren't really obvious that will do the job.

Try exporting an Excel spreadsheet to HTML ("Save for web" or whatever) and take a look at THAT code.  If you have a formula like "=B2+5" and B2 is "2", the cell with the formula will have the value "7" between the <td></td> but then there's a code embedded in there that's ignored by web browsers that actually has the formula so Excel knows how to reconstruct it.  It's kind of cool but definitely useful to know that you can do things like that.

I did a thing once that generated an HTML table with some embedded Excel tags.  It displayed correctly in HTML and then you could click a "Download" or "Open in Excel" button and just send some custom headers to pretend it was an .XLS file and the document would open in Excel with all the formulas and things in the right place...  all without having to mess with PEAR Excel Writer (??) or creating an .XLS file itself.

Anyway, good luck.  I think there are probably lots of ways to skin this particular cat.  Play around with different methods.

-TG

= = = Original message = = =

Wow thanks!

I will try this out.

I really appreciate the help.

Ron

>From: tg-php@xxxxxxxxxxxxxxxxxxxxxx
>To: php-windows@xxxxxxxxxxxxx
>Sent: 01/07/2005 9:54 AM
>Creating a new document in Word, inserting Page Breaks then saving it as
a web page revealed that Word seems to use CSS tags to show the line
breaks in HTML. The only odditiy I see is that when I load the HTML back
into Word, mine is still set to "View -> Web Page Layout" or something
(Word 2003) which doesn't show the page breaks (since you don't have page
breaks in HTML) but if you set it to "View -> Normal" the page breaks are
in there.
>
>Anyway, generating HTML like the following should give you page breaks
when loaded into Word:
>
><html>
>
><head>
><meta http-equiv=Content-Type content="text/html; charset=windows-1252">
><meta name=Generator content="Microsoft Word 11 (filtered)">
><title>Test 1</title>
><style>
><!--
> /* Style Definitions */
> p.MsoNormal, li.MsoNormal, div.MsoNormal
>~margin:0in;
>~margin-bottom:.0001pt;
>~font-size:12.0pt;
>~font-family:"Times New Roman";
>@page Section1
>~size:8.5in 11.0in;
>~margin:1.0in 1.25in 1.0in 1.25in;
>div.Section1
>~page:Section1;
>-->
></style>
></head>
><body lang=EN-US>
>
><div class=Section1>
>
><p class=MsoNormal>Test 1</p>
>
><span style='font-size:12.0pt;font-family:"Times New Roman"'><br
clear=all
>style='page-break-before:always'>
></span>
>
><p class=MsoNormal>Test 2</p>
>
><span style='font-size:12.0pt;font-family:"Times New Roman"'><br
clear=all
>style='page-break-before:always'>
></span>
>
><p class=MsoNormal>Test 3</p>
>
></div>
>
></body>
>
></html>
>
>
>Really you probably just need this as the page break:
>
><br clear=all style='page-break-before:always'>
>
>Not sure what "clear=all" does, but the "page-break-before" is standard
CSS (CSS2 I believe) that's telling it to insert the page break before the
<BR> tag (right? I think that's right).
>
>Maybe that helps.. if not, post again   "Ask again later" - Magic 8 Ball
:)
>
>-TG
>
>
>= = = Original message = = =
>
>Thank you for reply.  I figured out how to do that but now my issue is
>that since my styling is all done in HTML...I'm trying to bring over the
>HTML for each person's BIO, followed by a page break then the next
>person's BIO followed by a page break...and so on...
>
>The obvious problem is that if I use the Word COM object to insert the
>HTML...the HTML isnt parsed and all I get is the HTML source code...but
>the page breaks work great.  If I save the file first as HTML then open
it
>using the Word COM object then save it as a doc, it parses
correctly...but
>since there is no HTML page break function...all of the bios run one
after
>the other, when what I really need is each Bio starting on a new page.
>
>This is killing me!
>Ron
>
>>From: Sven Schnitzke
>>To: ''
>>Sent: 01/07/2005 8:15 AM
>>Hi,
>>sorry for accidentally sending private mail first ! Now to  the  list:
>>
>>to insert a pagebreak just leave out the parameter entirely. It's
>default:
>>
>>~$word->Selection->InsertBreak();
>>
>>but for clarity you may want to specify it, so do it the positional way
>(it's the 1st one):
>>
>>~$word->Selection->InsertBreak(wdPageBreak);
>>
>>Named parms don't seem to be supported by PHP COM.
>>
>>HTH
>>-- 
>>Sven
>>
>>> -----Urspr~ngliche Nachricht-----
>>> Von:~Ron.Herhuth@xxxxxxxxxxxxxxxxx
[SMTP:Ron.Herhuth@xxxxxxxxxxxxxxxxx]
>>> Gesendet am:~Mittwoch, 5. Januar 2005 18:55
>>> An:~php-windows@xxxxxxxxxxxxx
>>> Betreff:~ Word COM Object
>>>
>>>
>>> I have successfully made a PHP script that takes dynamically generated
>>> HTML and creates a Word Doc then saves it to the server and creates a
>link
>>> to itself.  This is fine and dandy but now I have to do a multipage
>>> document using several dynamically generated pages...this isnt a
>problem
>>> BUT I need to put a page break following each dynamically generated
>page.
>>> Is there some MS WORD command that I could embed in the HTML I am
>>> generating that will cause a page break?
>>>
>>> This seemingly simple task is killing me.
>>>
>>> Ron
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>-- 
>>PHP Windows Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>
>
>___________________________________________________________
>Sent by ePrompter, the premier email notification software.
>Free download at http://www.ePrompter.com.
>
>
>


___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux