Create excel file with multiple sheets

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Create excel file with multiple sheets

Author

Topic

ruchijani
Starting Member

23 Posts

Posted - 2009-08-20 : 00:58:54

Hello to all

How can i create excel file without using template file and XP_CMDSHELL and add multiple sheets to newly created excel file and also rename the newly added sheets name as per my requirement.

Is there any way of doing all this with use of SQL SERVER 2000???

Thanks
Ruchi

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-08-21 : 01:49:39

Try with the approaches available at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

ruchijani
Starting Member

23 Posts

Posted - 2009-08-21 : 02:29:38

Thank u for ur reply

I tried that example that will create only one sheet in excel file I want to add multiple sheets to newly created excel file and also want to rename that sheets name according to my requirement

Thanks
Ruchi

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources