Databases
StackOverflow2013
Postsdbo
POJoomla article exporting to excel
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJoomla article exporting to excel
    primarykey
    data
    text
    <p>A bit more info on what we are trying to achieve.</p> <p>We have had reports written in PHP that will create a table on the screen and then if they select the Excel radio button and rerun the report it will output the table to Excel simply by outputting the following headers before outputting the table header("Content-Type: application/x-msexcel"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Disposition: attachment; filename=discussion.xls");</p> <p>When we have tried to reproduce the same report inside a Joomla article the report works fine but when we then try to output the report to Excel it does create an excel file but seems to output the whole page content and not just the table from the report (hope that makes sense)</p> <p>You can see the link at <a href="http://commculturecommunity.cloudaccess.net" rel="nofollow">http://commculturecommunity.cloudaccess.net</a> if you select test1 it will create the Excel output but when you open it you can see the test data but can also see the rest of the page content.</p> <p>Any help would be really appreciated.</p> <p>Thanks Richard</p> <p>================================================================================</p> <p>We have created an article in Joomla and have embedded this code (using sourcerer) as part of the article.</p> <pre><code>{source} &lt;?php $filename ="excelreport.xls"; $contents ="testdata1 \t testdata2 \t testdata3 \t \n"; header('Content-type: application/ms-excel'); header('Content-Disposition: attachment; filename='.$filename); echo $contents; ?&gt; {/source} </code></pre> <p>When we go to the page an Excel file is downloaded but when we open it in Excel it has included the whole form and not just the test data created above.</p> <p>Any help would really be appreciated</p> <p>Thanks Richard</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPerryW
    1. USPerryW
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CONot clear about what's happening...Do you have a sample link to try
      singulars
      1. POJoomla article exporting to excel
      1. USGDP
    2. COExcel's format is binary, not an open text format, so you can't just create it as easily as that; like VampiRUS says, you need to use a library that has backwards-engineered the format. Alternatively, you could output a CSV file; that IS an open, textual format which is easy to work with, and absolutely trivial if you use php's csv functions.
      singulars
      1. POJoomla article exporting to excel
      1. USBobby Jack
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload