This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Not sure what you mean 'Office Web Components'.

deep_blue(BLUE)

If you mean MS office automation, it’s better not to use. There are Considerations for server-side Automation of Office (URL http://support.microsoft.com/kb/257757).

If your excel file will be used for client-side, you can pull data from database and put data to a GridView. Then use GridView.RenderControl to get a grid string (By google Export GridView to Excel, you can get many codes).

Or on server-side, you can use OleDb to deal with Excel file as database. From following URL you can have Connection String for excel:
http://www.connectionstrings.com/?carrier=excel

(#4516299@0)
Last Updated: 2008-6-22
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / 学科技术讨论 / 请大家帮帮忙，先谢了！新上手 ASP.NET/C# ，不熟, 下周五要交差，tasks见内。 -study_work(study_work); 2008-6-21 {534} (#4515681@0)
Website 是一个交易平台，

database ： MS SQL Server
- using Microsoft.Practices.EnterpriseLibrary.Data with stored procedure to query （existing code，maybe i can change it...)
- put query results to a Excel sheet （怎样在 EnterpriseLibrary.Data 中把 query results 放到 Excel file 里去？能不能用 Office Web Components ？）
- mail this Excel file to users weekly （how to schedule a task on the server side for this requirment? which technology should I use? Better not use a new apps for the scheduling)

谢谢各位指教！

Not sure what you mean 'Office Web Components'. -deep_blue(BLUE); 2008-6-22 {597} (#4516299@0)
If you mean MS office automation, it’s better not to use. There are Considerations for server-side Automation of Office (URL http://support.microsoft.com/kb/257757).

If your excel file will be used for client-side, you can pull data from database and put data to a GridView. Then use GridView.RenderControl to get a grid string (By google Export GridView to Excel, you can get many codes).

Or on server-side, you can use OleDb to deal with Excel file as database. From following URL you can have Connection String for excel:
http://www.connectionstrings.com/?carrier=excel

OWC can do that. -giss(rr); 2008-6-22 (#4516662@0)

LZ asked to put query results to a Excel sheet rather than publishing spreadsheets to the Web. -deep_blue(BLUE); 2008-6-23 (#4517229@0)

you are right, I need to put the query result to Excel sheet directly and mail the file as a attachment. -study_work(study_work); 2008-6-23 (#4518949@0)

In addtion to approaches I mentioned before, You can also 'write' data rows to execl by using XML format excel. -deep_blue(BLUE); 2008-6-24 (#4519435@0)

I guess you should not finish it in time without help. -giss(rr); 2008-6-22 (#4516663@0)

是不是我要对manager说我需要多一点的时间？我不知道我能不能得到其他的帮助，因为我刚去这家公司上班。 -study_work(study_work); 2008-6-22 (#4516906@0)

想问问面试技巧，不熟怎么能通过面试的。请PM，谢谢！我也在找工作中。 -zgzdr( 找工作的人); 2008-6-23 (#4518401@0)

申请时不是ASP.NET /C#position,去了之后让做ASP.NET /C#就答应了，以前自己看过一点但没有hands-on 经验。面试时问了我以前的工作经验加考试。 -study_work(study_work); 2008-6-23 (#4518827@0)

谢谢大家的的回复。 -study_work(study_work); 2008-6-22 (#4516890@0)
do you have to use ASP.NET? need to input some query parameter from web page? if not you can just use c# to write some program to generate a EXE and called from windows CRON job. -thunderbolt(孙悟空); 2008-6-23 (#4517980@0)

i have found a way to do it, thanks a lot. -study_work(study_work); 2008-6-23 (#4518837@0)

with SSRS, it should be piece of cake? -mfcguy(); 2008-6-27 (#4525681@0)
再次感谢大家的指导和回复！ -study_work(study_work); 2008-6-27 {122} (#4525723@0)
不好意思，2～3年没写code了，不过我想过几个月就会慢慢熟悉coding了，我已在周四晚上完成了这个task，再次感谢大家的指导和回复！

@Florida

Not sure what you mean 'Office Web Components'.

Replies, comments and Discussions:

More Topics