creating an excel report

[azaidi7]

I have a table that displays dynamically generated data from a database to the user. I need to put this information into a an excel spreadsheet report.

[erikwebb]

I honestly don't have a solution, but that would be ridiculously hard to format and I doubt that is possible with a non-commercial solution.

[BuzzLY]

Ì håvë åbsølûtëly nø ídëå høw tø dø thís. Sø, Ì typëd "HTML tø Éxcël cønvërsíøn" ín Gøøglë. Thë fífth línk døwn gåvë më thís sítë.

Tøtål tímë: åbøût 45 sëcønds

Plëãsë gîvë më ã sëcønd tø fînd ãn ãpprøprîãtë ãcrønym. Ì hãvë sø mãny øf thëm ãccùmùlãtëd øn my dësk.

RTFM? nø... LØL? mãybë, bùt nø... RØFLM-- nø, nøt thãt ønë ëîthër. Hmmm. Âh. Hërë ît îs.

STFW

🙂

[hkucsis]

http://hk.php.net/manual/en/ref.com.php

There is some sample code in User Contributed Notes, check to see if it is useful.

[ahundiak]

It's very easy to do using this pear project.
http://pear.php.net/package-info.php?package=Spreadsheet_Excel_Writer
Here is a code sample:

  /* Load the object */
  require_once 'Spreadsheet/Excel/Writer.php';

  /* Create a workbook */
  $workbook = new Spreadsheet_Excel_Writer();

  /* Send the headers */
  $workbook->send('player_ratings.xls');

  /* Create the worksheet */
  $worksheet =& $workbook->addWorksheet('ratings');

  /* Cycle through */
  $row = 0;
  foreach($d->players as $player)
  {
    $ratingDesc = $d->ratingPickList->getValueForID($player->rating);

$worksheet->write($row, 0, $player->playerID);
$worksheet->write($row, 1, $player->lastName);
$worksheet->write($row, 2, $player->firstName);
$worksheet->write($row, 3, $player->dob);
$worksheet->write($row, 4, $ratingDesc);
$worksheet->write($row, 5, $player->note);
$row++;
  }

  /* Send It */
  $workbook->close();

[Castle]

I thought this was a little easier if your not against the idea of java script.... Although i hate it i do use it some times.

this put the out put in excel. and uses the table tags to set columns

function openExcel()
{
window.open("file.php?step_name=" + stuff you want to send);
}

[erikwebb]

Castle, I think you're just talking about a tab-deliminated table.

[Castle]

yea but the OpenExcel function will that table to excel.

[erikwebb]

My bad, your post just doesn't appear to be clear at all.