Jump to content

Archived

This topic is now archived and is closed to further replies.

ibanez270dx

Importing to Excel

Recommended Posts

Hi,
I am seriously at my wit's end about this... I need to be able to click a link, which opens up a dynamically created Excel page with X number of rows and 9 columns. I am currently using a script called "excelwriter", but I can't seem to get it to work properly - that is, write all the rows into the excel file (I can only write one dynamically, which is a little useless...). So, my question would be: How would I be able to accomplish this if I rewrote the whole script? I'm talking from scratch... Also, is it possible to import my data as an HTML table to Excel? I think that would be easiest.

Thanks in advance,
- Jeff

Share this post


Link to post
Share on other sites
You might be interested into learning how CSV works  ;)

http://forums.dreamincode.net/showtopic10131.htm

Share this post


Link to post
Share on other sites
sweet - it pretty much works the way I want. How would I be able to format cells though? For example, have the cell labels in bold or something? Here is my code:

[code]
$cr = "\n";
$title = "TITLE" . ',' . $monthname . ',' . $year . $cr;
$catanames =
"Type" . ',' . "Date" . ',' . "Downtime" . ',' . "Hours Down" . ',' .
"ATA" . ',' . "Discrepancy" . ',' . "Resolution" . ',' . "Logged" . ',' .
"Logged By" . $cr;

$data .=
$dwntime_type . ',' . $dwntime_date . ',' . $dwntime_times . ',' .
$dwntime_hrs . ',' . $dwntime_ata . ',' . $dwntime_reason . ',' .
$dwntime_solution . ',' . $dwntime_log . ',' . $dwntime_log_by . $cr;
}

$fp = fopen($filename2,"a");
if($fp)
{
fwrite($fp, $title);
fwrite($fp, $catanames);
fwrite($fp, $data);
fclose($fp);
echo "File saved successfully. <a href=$filename.csv>click here to access $filename2</a>";
} else {
echo "Error saving file!";
}
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.