RE: Re: Exporting HTML to Excel

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

 



> To all who've helped.
> 
> Thanks for your input. [embarrassment] Truthfully, when I gave that 
> example in my original email, I didn't try that specific one. But it 
> did work for me also when I attempted that one. [/embarrassment]
> 
> The reason I was getting a blank spreadsheet was b/c I was 
> only showing 
> specific columns based on whether certain $_SESSION variables 
> were set. 
> However, the page that's supposed to export to excel, I did 
> not include 
> my `session_start()`, so none of the variables were ever TRUE. Once I 
> saw that and fixed it, it worked like a charm!
> 
> But I have run across a small dilemma at this point. I cannot 
> open the 
> excel file using IE. However, I can through Mozilla and Safari. Guess 
> this is something else I have to look at and try to tackle!
> 
> Thanks again!
> ~Philip

> >>>> <table>
> >>>>     <tr>
> >>>>         <td>Something</td>
> >>>>         </td>Something else</td>
> >>>>     </tr>
> >>>> </table>


Btw: the example above has a </td> instead of a <td> on the second cell
so it puts the values in A1 and A2 instead of A1 and B1.

Another note, I put a <td>=A1+B1</td> and it worked fine (put the
formula in and it evaluates just fine that is).

Also, if you're having trouble in IE (I didn't, it worked fine) you
might try changing the MIME type to something that'll download and give
the option of save/open.  There was another thread on this list about
creating folders (not with PHP, but opening a file dialog so the user
could create a folder for the download) that had a lot of good info
about forcing the browser to open that dialog box.

What problem are you having in IE right now?  Is it opening INSIDE IE as
an Excel sheet embedded or something (like PDFs do with Acrobat Reader)?
I had that happen once or twice while testing the code above.

Anyway, good luck. Glad you figured out the session problem, that can be
frustrating.

-TG

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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux