澄清什么可以导出为excel iPad上 [英] Clarification on what can be exported to excel on ipad
问题描述
试图修复一个旧的.asp网站在iPad上运行。特点之一是下载他们的搜索结果到Excel工作表的用户的能力。在code用途：
Trying to fix an old .asp site to work on an ipad. One of the features is the users ability to download their search results into an excel worksheet. The code uses:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment;filename=results.xls"
Response.CharSet = "iso-8859-1"
在查看iPad上的网站，当链接点击与code以上它什么也不做的页面，只是旋转。难道我尝试导出为Excel，我看了一些帖子它是如何编码数据的事实！我应该转换code的结果页面导出为CSV文件，然后允许用户在任何打开它，他们希望/可用？什么是做打大多数设备的最佳途径......
When viewing the site on the ipad, when the link is click for the page with the code above it does nothing, just spins. Is it the fact that I am trying to export the data as excel, I have read in some posts how it is the encoding! Should I convert the code to export the results page as a csv file and then allow the user to open it in anything they want/have available? What's the best way to do it to hit the most devices...
感谢
推荐答案
在过去我一个同样的情景让我所做的：
In the past i'd a same scenario so what i did:
文件：DOWNLOAD.ASP
FILE: DOWNLOAD.ASP
<%
' get the file to download
myFile = request.querystring("File")
myFullPath = "c:\name_folder\" & myFile ' example of full path and filename
' set headers
Response.ContentType = "application/octet-stream"
Response.AddHeader "Content-Disposition", "attachment; filename=" & myFile
' send the file using the stream as
Set adoStream = CreateObject("ADODB.Stream")
adoStream.Open()
adoStream.Type = 1
adoStream.LoadFromFile(myFullPath)
Response.BinaryWrite adoStream.Read()
adoStream.Close
Set adoStream = Nothing
%>
文件：HTML
<a href="DOWNLOAD.ASP?File=result.xls">Download Excel file</a>
这个例子充满了与iPad 工作用自带浏览器Safari浏览器。
文件 Result.xls 下载并在浏览器中加载whitout的能力是编辑。
This example is full working with Ipad using the native browser Safari.
The file Result.xls is downloaded and loaded in the Viewer whitout the capability to be edit.
我的iPad用户使用App的QuickOffice，让该文件被保存在一个虚拟文件夹，重命名文件，删除......但他们不能编辑该文件，该应用仅仅是管理文件的和心不是下载所需的文件
My iPad users use the App QuickOffice to let the file be saved in a virtual folder, rename the file, delete, ... but they cant edit the file, that App is just for manage the files and isnt required for download the file.
如果您的用户还需要编辑iPad上的XLS文件，我建议使用（例如）谷歌应用程序文件，它让用户编辑和管理直接在浏览器的文件
If your user need also edit the XLS file on the iPad i suggest to use (for example) the Google App Document, it let the user to edit and manage the file directly in the browser.
希望它能帮助
这篇关于澄清什么可以导出为excel iPad上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
