结果到Excel [英] Results to Excel
问题描述
如何将填写表单的结果保存到Microsoft Excel
电子表格?
我可以将结果插入Access表,但是报告来自Access,这是非常繁琐的工作。
使用Excel作为数据源很容易生成报告。
因为不会有多个表或查询,我真的不需要
访问。
使用Response.ContentType(" application / vnd.ms-excel")
" dancer" < da **** @ microsoft.comwrote in message
news:uG ************** @ TK2MSFTNGP05.phx.gbl ...
如何将填写表格的结果保存到Microsoft Excel
电子表格?
我可以插入将结果放入Access表中,但是从Access获得的报告非常繁琐。
使用Excel作为数据源很容易生成报告。
由于不会有多个表或查询,我真的不需要
访问。
"舞蹈家" < da **** @ microsoft.comwrote in message
news:uG ************** @ TK2MSFTNGP05.phx.gbl ...
如何将填写表格的结果保存到Microsoft Excel
电子表格?
我可以插入将结果放入Access表中,但是从Access获得的报告非常繁琐。
使用Excel作为数据源很容易生成报告。
由于不会有多个表或查询,我真的不需要
访问权限。
后退一步 - 你的意思是什么?报告......?
显然你可以不要谈论Microsoft Access中的报告引擎,
,因为你涉及服务器端自动化,这是不支持的......
将数据添加到Excel电子表格非常简单:
http://www.google.co.uk/search?sourc...22ADO %2eNET%22
然后是什么......?您打算在
浏览器中显示此电子表格吗??
-
Mark Rae
ASP.NET MVP
http://www.markrae.net >
我希望信息以表格或网格的形式出现在我的电脑上,这样我就可以随意报告。
" Mark Rae [MVP]" < ma ** @ markNOSPAMrae.netwrote in message
news:u4 ************** @ TK2MSFTNGP02.phx.gbl ...
< blockquote class =post_quotes>
" dancer" < da **** @ microsoft.comwrote in message
news:uG ************** @ TK2MSFTNGP05.phx.gbl ...
>如何将填写表单的结果保存到Microsoft Excel
电子表格?
我可以将结果插入Access表但是报告从Access中做起来非常繁琐。
报告很容易使用Excel作为数据源。
由于不会有多个表或查询,我不会真的需要
访问权限。
回到这里 - 你的意思是什么?报告" ...?
显然你可以不要谈论微软的报告引擎
Access,因为你涉及服务器端自动化,这不是支持
...
将数据添加到Excel电子表格非常简单:
http://www.google.co.uk /search?sourc...22ADO%2eNET%22
但那又是什么......?您打算在
浏览器中显示此电子表格吗??
-
Mark Rae
ASP.NET MVP
http://www.markrae.net
How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don''t really need
Access.
Use Response.ContentType("application/vnd.ms-excel")
"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don''t really need
Access.
"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...
How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don''t really need
Access.One step back here - what exactly do you mean by "reports"...?
Clearly you can''t be talking about the reporting engine in Microsoft Access,
as that you involve server-side automation, which isn''t supported...
Adding data to an Excel spreadsheet is simple enough:
http://www.google.co.uk/search?sourc...22ADO%2eNET%22
But then what...? Do you intend to display this spreadsheet in the
browser...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
I want the information to come to my computer in table or grid form, so that
I can make reports at will.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:u4**************@TK2MSFTNGP02.phx.gbl..."dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...
>How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don''t really need
Access.
One step back here - what exactly do you mean by "reports"...?
Clearly you can''t be talking about the reporting engine in Microsoft
Access, as that you involve server-side automation, which isn''t
supported...
Adding data to an Excel spreadsheet is simple enough:
http://www.google.co.uk/search?sourc...22ADO%2eNET%22
But then what...? Do you intend to display this spreadsheet in the
browser...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
这篇关于结果到Excel的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!