How can I give name to a file I exported to Excel from a webpage?

Question

Similar to: How can I export tables to excel from a webpage.

There is just one little problem. The .xls file is being saved with a random name. But I need to set my own name to the Excel file. Is there any way of doing it?

This is the JavaScript I am using:

window.open('data:application/vnd.ms-excel,'+document.documentElement.innerHTML);

score 0 · Answer 1 · answered Jul 02 '13 at 09:16

0

You need server side code for that. Except in chrome you can use <a download="abc.xls" /> attribute

answered Jul 02 '13 at 09:16

chetan

2,876
1
14
15

Would that not go to the server as well? – mplungjan Jul 02 '13 at 09:21
@mplungjan nop. try it without server.(plain html in a folder) – chetan Jul 02 '13 at 09:23
it will try to get the stream from href attribute, name the file as in download attribute and let you download. – chetan Jul 02 '13 at 09:43
Cool. sounds like what OP needs – mplungjan Jul 02 '13 at 09:49

score 0 · Answer 2 · answered Jul 02 '13 at 09:21

0

You can't do this with client-side JavaScript, you need to set the response header...

.NET

Response.AddHeader("Content-Disposition", "inline;filename=filename.xls")

Php

$filename = 'somehting.xls';

header('Content-Disposition: attachment; filename="'.$filename.'"');

answered Jul 02 '13 at 09:21

Tredged

586
2
17

I told you and the beginning of my comment that its not possible with Javascript because you need to set a response header. – Tredged Jul 02 '13 at 10:17

How can I give name to a file I exported to Excel from a webpage?

2 Answers2