Re: read csv file in iframe as text file

On 2008-01-15, Adrienne Boswell <arbpen@xxxxxxxxx> wrote:
Gazing into my crystal ball I observed sukhmeet@xxxxxxxxx writing in
news:9f721bde-c030-47e2-a458-3149311e99e3@xxxxxxxxxxxxxxxxxxxxxxxxxxx:

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



There really isn't anything you can do - it depends on the user's
browser and system. If the user's system wants to do that, it will.

Might it depend on the MIME type header delivered with the file? If the
extension is csv the server might send it as application/ms-excel or
something and that's what causes IE to try to open it in Excel? If so
the server can be configured to send it as text/plain instead.

It's equally possible IE itself just looks at the extension and ignores
the MIME type anyway. In which case there's nothing you can do.
.

Relevant Pages

  • Re: CSV Downloads
    ... Open/Save As prompt when you click your bank statement (.CSV file). ... > am presented with a file download box. ... On the XP machine I select CSV and Excel is opened ... >> opens in IE, just do File/Save As and save it as .xls or whatever. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: in which folder can you save a .CSV file?
    ... For sure you saved as an Excel *.xls workbook but get the "cannot access the ... Excel opens and the info gets copied to an Excel worksheet. ... open it and re-save as a *.csv to that folder. ... To save your email address book as a *.CSV file you must do that though Oulook, ...
    (microsoft.public.excel.misc)
  • Re: in which folder can you save a .CSV file?
    ... For sure you saved as an Excel *.xls workbook but get the "cannot access the ... Excel opens and the info gets copied to an Excel worksheet. ... open it and re-save as a *.csv to that folder. ... To save your email address book as a *.CSV file you must do that though Oulook, ...
    (microsoft.public.excel.misc)
  • Re: read csv file in iframe as text file
    ... load it as a text file. ... finally opens it with excel in IE window itself. ... 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 ...
    (comp.lang.javascript)
  • Re: Excel 2000 & NAV 2003
    ... > when Excel exits and restored when Excel opens. ... when I immediately close the CSV file. ... > "Jim Rech" wrote in message ...
    (microsoft.public.excel.misc)