[RESOLVED] Embedding Excel(.xls) Stylesheet

[obrienkev]

My client wants to be able to display a .xls spreadsheet on a webpage eachday.

Is this possible?

How is this done?

Thanks,

Kevin.

[Weedpacket]

Yes, it's possible.

By providing a link to the spreadsheet, and telling the web server to serve it with a Content-Type of application/vnd.ms-excel.

[obrienkev]

How do I do this please?

[leatherback]

Hi,

Have a look at setting headers in the manual

[obrienkev]

I don't want to link to the .xsl file. It must be displayed on the webpage itself.

How do I do this?

thanks,

Kevin.

[leatherback]

What do you want with the excel file? Show it as and excel spreadsheet? Of table, or?

Anyway. there is a bnch of functions out there. If it is CSV you could just read the file with fgetcsv

[obrienkev]

OK I'll explain the entire olan. Please could you help me out with it.

1/ Admin uploads excel file into database table.

2/ Webpage displays the contents of excel file - either as table or as an excel file embedded in html.

3/ So the end user just visits the webpage and before his/her eyes are the contents of the excel file.

How do I do this please?

Thanks,

Kevin.

[leatherback]

Hi,

Just did a little search for you in google, and found this project:

http://sourceforge.net/projects/phpexcelreader/

Hope it helps you?

[obrienkev]

Thanks leatherback.

Been looking at that. Doesn't give any examples on displaying the excel file content though.

Do you know where I can find any examples or tutorials on this?

Thanks,

Kevin.

[obrienkev]

Anyone know of any tutorials on the Spreadsheet_Excel_Reader???

[leatherback]

from the helpfile INCLUDED in the package:

INTRODUCTION
Read data from Excel spread sheets without Microsoft!
Provides an API to allow any application to read Excel
documents. Written in PHP. Based on the the Java version by Andy Khan.

LINKS

OpenOffice.org's Documentation
http://sc.openoffice.org/excelfileformat.pdf

OLE2 Storage Documentation
http://jakarta.apache.org/poi/poifs/fileformat.html

Java API for reading, writing and modifying the contents of Excel spreadsheets
http://www.andykhan.com/

CONTACT
Vadim Tkachenko
[e-mail]

INFO
For use encoding you must have installed iconv extension, otherwise data output in unicode

HOW TO USE
see example.php

[obrienkev]

Hi,

The below code is to display all data from an excel page in a table. How do I fix the table right for it to display correctly.

How do I set font type, size, color, etc. I want to make it small enough to fit on my webpage.

thanks.

<table>
<tr>
<?php

echo '<table>';
echo '<tr><td></td><td>';

for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
	for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
		echo '</td><td></td><td>';
		echo $data->sheets[0]['cells'][$i][$j];
		echo '</td></tr>';
	}
	echo "\n";

}

echo '</td><tr></tr>';
echo '</table>';

Kevin.

[obrienkev]

OK. It displays roight now. Only that it add a load of empty rows and columns.

Any idea why this is so??

Here's my code now...

echo '<table>';
echo '<tr><td></td><td>';

for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) 
{
 	echo '<tr><td>';
	for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) 
	{
		echo $data->sheets[0]['cells'][$i][$j];
		echo '</td><td></td><td>';
	}
	echo '</td></tr>';
	echo "\n";

}

echo '</td><tr></tr>';
echo '</table>';

Using CSS for the formatting anyway.

Cheers,

Kevin.