Excel跟进 [英] Excel follow-up
问题描述
我通过Curt的示例代码阅读了使用ASP创建电子表格
（.xls）。我想我理解基础知识，但我仍遇到问题。
我在Intranet应用程序上这样做，所以我将页面保存到HTML文件中，并且
将其放在 http://www.middletree.net/sort .htm 供查看回答这个问题。
问题。我想要一个可点击的按钮，它可以获取您在该表中看到的信息，并生成一个电子表格。但是，我希望它不包含那个菜单，而且还不包括隐藏的div（单击选项
复选框以查看我的意思）
就像现在一样，当我使用一些基于Curt示例的代码时，它给了我
该页面上的所有内容。
任何人都可以指导我吗？不确定如何去做。
" middletree" < MI ******** @ htomail.com>在消息中写道
新闻：u7 ************* @ TK2MSFTNGP10.phx.gbl ...我读过Curt''使用ASP创建电子表格的示例代码
（.xls）。我想我理解基础知识，但仍然遇到
问题。
我在内联网应用程序上这样做，所以我将页面保存到HTML文件中，然后放置它在 http://www.middletree.net/sort.htm 查看回答这个问题。我想要一个可点击的按钮，它可以获取您在该表中看到的信息
，并生成一个电子表格。但是，我希望它不包含该菜单，也不包括隐藏的div（单击
选项复选框以查看我的意思）
现在是当我使用Curt的例子中的一些代码时，它给了我那个页面上的所有内容。
任何人都可以指导我吗？不确定如何去做。
你从什么构建表 - 数据库？
为什么不生成Excel文件在你建造桌子的同时？
" McKirahan" <氖** @ McKirahan.com>在消息中写道
news：oK ******************** @ comcast.com ...<你从什么构建表 - 数据库？
是的。
为什么不在构建表格的同时生成Excel文件？
这就是我要问的怎么做。我希望用户能够根据几个标准（当您选中选项复选框时可以看到
）返回您所看到的
数据集，并且有一个按钮或链接，他们可以在这个网页上看到他们只看到b $ b生成的相同数据的电子表格。
" middletree" < MI ******** @ htomail.com>在消息中写道
news：uv ************** @ TK2MSFTNGP10.phx.gbl ..." McKirahan" <氖** @ McKirahan.com>在消息中写道
新闻：oK ******************** @ comcast.com ...
来自你建立了什么表 - 数据库？
是的。
为什么不在构建表的同时生成Excel文件呢？ / blockquote>
这就是我要问的怎么做。我希望用户能够根据您看到的数据返回一组数据（基于几个标准（当您选中选项复选框时可以看到
），并且有一个按钮或链接
可以有一个他们在该网页中看到的相同数据的电子表格，他们
刚生成。
您的Excel文件是否可以与页面的初始显示一致？
或者它是否必须反映在网页上选择的排序选项？
你想要以下哪些（伪代码）？
1）Excel =静态网页
读取数据库表
构建网页表
构建Excel文件
循环
保存Excel文件
显示网页
用户点击一个按钮：
下载Excel文件
2）Excel =动态网页
读取数据库表
构建网页表
循环
显示网页
用户点击按钮：
构建Excel文件
保存Excel文件
下载Excel文件
I read through Curt''s sample code for using ASP to create a spreadsheet
(.xls). I think I understand the basics, but am still running into problems.
I''m doing this on an Intranet app, so I saved a page to an HTML file, and
placed it at http://www.middletree.net/sort.htm for viewing to answer this
question. I''d like to have a clickable button that would take the info you
see in that table, and generate a spreadsheet. However, I want it to not
include that menu, and also to not include the hidden div (click the Options
checkbox to see what I mean)
As it is now, when I use some code built on Curt''s example, it gives me
everything on that page.
Can anyone guide me on this? Not sure how to go about it.解决方案"middletree" <mi********@htomail.com> wrote in message
news:u7*************@TK2MSFTNGP10.phx.gbl...I read through Curt''s sample code for using ASP to create a spreadsheet
(.xls). I think I understand the basics, but am still running into problems.
I''m doing this on an Intranet app, so I saved a page to an HTML file, and
placed it at http://www.middletree.net/sort.htm for viewing to answer this
question. I''d like to have a clickable button that would take the info you see in that table, and generate a spreadsheet. However, I want it to not
include that menu, and also to not include the hidden div (click the Options checkbox to see what I mean)
As it is now, when I use some code built on Curt''s example, it gives me
everything on that page.
Can anyone guide me on this? Not sure how to go about it.
From what do you build the table -- a database?
Why not generate the Excel file at the same time as you build the table?
"McKirahan" <Ne**@McKirahan.com> wrote in message
news:oK********************@comcast.com...
From what do you build the table -- a database?
Yes.
Why not generate the Excel file at the same time as you build the table?
That''s what I am asking how to do. I want the user to be able to return a
set of data like you saw, based upon several criteria (which you can see
when you check the Options checkbox), and have a button or link where they
can have a spreadsheet of the same data they see in that web page they just
generated.
"middletree" <mi********@htomail.com> wrote in message
news:uv**************@TK2MSFTNGP10.phx.gbl..."McKirahan" <Ne**@McKirahan.com> wrote in message
news:oK********************@comcast.com...
From what do you build the table -- a database?
Yes.Why not generate the Excel file at the same time as you build the table?
That''s what I am asking how to do. I want the user to be able to return a
set of data like you saw, based upon several criteria (which you can see
when you check the Options checkbox), and have a button or link where they
can have a spreadsheet of the same data they see in that web page they
just generated.
Can your Excel file be consistent with the initial display of the page?
Or does it have to reflect the sort options selected on the Web page?
Which of the following (pseudo-code) do you want?
1) Excel = static Web page
read database table
build Web page table
build Excel file
loop
save Excel file
display Web page
User clicks a button to:
download Excel file
2) Excel = dynamic Web page
read database table
build Web page table
loop
display Web page
User clicks a button to:
build Excel file
save Excel file
download Excel file
这篇关于Excel跟进的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
