By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,089 Members | 2,254 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,089 IT Pros & Developers. It's quick & easy.

read csv file in iframe as text file

P: n/a
Hi,
I am trying to load a csv file in Iframe element. I just want to
load it as a text file.
however when i load the file in iframe it asks to open the file and
finally opens it with excel in IE window itself. If i save the save
file as .txt it is being read properly.I need to save the file in csv
format only so that it can be edited externally with excel easily.
Later on i want to display the read csv file in javascript and do some
processing on it.
Does any know how do this. The basic problem is to stop IE from
invoking excel to open csv file and instead read the file as text.

Following code works for .txt file

<iframe name="loader" id="frm" width="1000" height="300"
style="visibility:hidden;display:none" src="Book1.txt"></iframe>

and when i use this line it tries to open the file using excel which i
don't want.

<iframe name="loader" id="frm" width="1000" height="300"
style="visibility:hidden;display:none" src="Book1.csv"></iframe>

Any suggestions?
Thanks
Sukhmeet

Jan 15 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Jan 15, 1:18*am, sukhm...@gmail.com wrote:
Hi,
* I am trying to load a csv file in Iframe element. I just want to
load it as a text file.
however when i load the file in iframe it asks to open the file and
finally opens it with excel in IE window itself. If i save the save
file as .txt it is being read properly.I need to save the file in csv
format only so that it can be edited externally with excel easily.
Later on i want to display the read csv file in javascript and do some
processing on it.
* Does any know how do this. The basic problem is to stop IE from
invoking excel to open csv file and instead read the file as text.

Following code works for .txt file

<iframe name="loader" id="frm" width="1000" height="300"
style="visibility:hidden;display:none" src="Book1.txt"></iframe>

and when i use this line it tries to open the file using excel which i
don't want.

<iframe name="loader" id="frm" width="1000" height="300"
style="visibility:hidden;display:none" src="Book1.csv"></iframe>

Any suggestions?
* Thanks
Sukhmeet
Bart is correct. However, why not just change the file extension?
Book1.xxx, for example. Or don't use a file extension at all. Later on
why you want to open it up in excel, just go into excel and open the
file. You may have to change the file type on the open file dialogue
window. Just don't allow Excel to create a new file extension
association with 'xxx' or whatever you use.
Jan 15 '08 #2

P: n/a
Doug Gunnoe wrote:

[...]
Bart is correct. However, why not just change the file extension?
Book1.xxx, for example. Or don't use a file extension at all. Later on
why you want to open it up in excel, just go into excel and open the
file. You may have to change the file type on the open file dialogue
window. Just don't allow Excel to create a new file extension
association with 'xxx' or whatever you use.
If the objective is that admin edits the CSV-file directly in Excel
(e.g. when opening it using a FTP-path in Excel and saves it back),
then I believe it's better to keep the .csv-extension. This way the
editing can be performed with maximum user-friendliness for admin. The
extension doesn't matter for XMLHttpRequest as it always parses the
raw data.

--
Bart
Jan 15 '08 #3

P: n/a
On Jan 15, 7:40*am, Bart Van der Donck <b...@nijlen.comwrote:
If the objective is that admin edits the CSV-file directly in Excel
(e.g. when opening it using a FTP-path in Excel and saves it back),
then I believe it's better to keep the .csv-extension. This way the
editing can be performed with maximum user-friendliness for admin.
OK. I didn't catch that. I just though the OP wanted to open in it up
in Excel from time to time and edit it, but did not want the browser
to open it up like a spreadsheet.
The extension doesn't matter for XMLHttpRequest as it always parses the
raw data.
But changing the extension keeps IE from associating the file with
Excel and trying to open it up as a spreadsheet in the browser.

But I see your point. It would be a pain if you had to edit the file
frequently or if you had multiple users who needed to edit the file.

Jan 15 '08 #4

P: n/a
On Jan 15, 7:40 am, Bart Van der Donck <b...@nijlen.comwrote:
If the objective is that admin edits the CSV-file directly in Excel
(e.g. when opening it using a FTP-path in Excel and saves it back),
then I believe it's better to keep the .csv-extension. This way the
editing can be performed with maximum user-friendliness for admin.
OK. I didn't catch that. I just though the OP wanted to open in it up
in Excel from time to time and edit it, but did not want the browser
to open it up like a spreadsheet.
The extension doesn't matter for XMLHttpRequest as it always parses the
raw data.
In regard to the way the OP was doing it, changing the extension keeps
IE from associating the file with Excel and trying to open it up as a
spreadsheet in the browser.

But I see your point. It would be a pain if you had to edit the file
frequently or if you had multiple users who needed to edit the file.

Your solution is the best way.
Jan 15 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.