PHP xls, xlsx, ppt, pptx headers

Question

Here is my code where I am trying to send a correct header depedning on a type of a document. I figured out the headers for pdf, doc and docx but I still need to know correct header for Excel and Powerpoint files.

Any help appreciated.

    $document = urldecode($_GET['document']);
    $extension = end(explode('.', $document));
    $mimeType = '';
    switch ($extension) {
        case 'pdf':
            $mimeType = 'pdf';
            break;
        case 'doc':
            $mimeType = 'msword';
            break;
        case 'docx':
            $mimeType = 'msword';
            break;
        case 'xls':
            $mimeType = '';
            break;
        case 'xlsx':
            $mimeType = '';
            break;
        case 'ppt':
            $mimeType = '';
            break;
        case 'pptx':
            $mimeType = '';
            break;
    }       
    header('Content-type: application/' . $mimeType);

fabrik your link serves 'Error 404! The page you requested does not exist or has moved.' please remove your link from here. — Kamlesh, Dec 31 '19 at 14:24

score 100 · Accepted Answer · answered Jul 23 '10 at 13:04

.xls

application/vnd.ms-excel

.xlsx

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

.ppt

application/vnd.ms-powerpoint

.pptx

application/vnd.openxmlformats-officedocument.presentationml.presentation

And one of those you have listed is wrong:

.docx

application/vnd.openxmlformats-officedocument.wordprocessingml.document

score 5 · Answer 2 · answered Jul 23 '10 at 12:59

5

See http://www.w3schools.com/media/media_mimeref.asp .

xls is application/vnd.ms-excel, ppt is application/vnd.ms-powerpoint.

answered Jul 23 '10 at 12:59

Maerlyn

33,687
18
94
85

Good list except it does not include .docx, .xlsx or .pptx. – Jason Jul 23 '10 at 16:35

score 3 · Answer 3 · answered Jul 28 '11 at 20:51

3

Since most of the types requested are Microsoft Office related, this link has all of the office mime types (the best focused source I've found so far): http://filext.com/faq/office_mime_types.php

answered Jul 28 '11 at 20:51

Code Jockey

6,611
6
33
45

score 0 · Answer 4 · answered Feb 03 '15 at 13:20

0

You can simply echo $_FILES['input_tag_name']['type'] after upload a file to know the MIME type of that file.

answered Feb 03 '15 at 13:20

Biswadeep Sarkar

841
9
17

PHP xls, xlsx, ppt, pptx headers

4 Answers4

Linked