如何在密码保护的情况下将数据集的数据导出到多个Excel工作表 [英] How to Export Data for Dataset to Multiple Excel sheet with Password protected

问题描述

尊敬的团队，

请帮助将数据库数据快速导出到多个Excel工作表.

Forcelly将其描述为不按单元导出"，具有快速导出的批量导出..


成绩
Rohit Singh

Dear Team ,

Please help to fast export data for database to Multiple excel sheet.

Forcelly describe to Not cell wise export Bulk Export with Fast Export ..


regrads
Rohit Singh

推荐答案

通过下面的链接

9将数据导出到Excel for ASP的解决方案. NET [ ^ ]

用于Excel/CSV的一键式ASP.NET导出按钮控件文件 [ ^ ]

谢谢
--RA

go through the below links

9 Solutions to Export Data to Excel for ASP.NET[^]

One click ASP.NET export button control for Excel/CSV file[^]

Thanks
--RA

如果要手动将数据库导出，请使用SQL2005导出和导入向导将其导出到Execl文件.

0.以2003格式创建一个Execl文件.
1.转到您的数据库
2.右键单击DB->任务->导出数据..
3.现在，您可以看到导出向导.
4.单击下一步，检查数据库是否正确，如果不正确，请进行更改. ->下一个
5.选择目标作为Microsoft Excel.提供您在其中创建Execl文件的文件路径. ->下一个.
6.选择第一个选项->下一个
7.如果要导出所有表，请全选，或根据需要选择. ->下一个
8->完成.
9.打开Execl文件，默认的前三页可能为空白.之后，您可以在每个页面中查看表格.

认为它在SQL2008中是相同的.
谢谢

***如果要向Execl文件添加密码
1.转到另存为.
2.在保存"按钮旁边有一个名为工具"的选项，单击它->常规选项
3.根据需要潜水密码.

谢谢.

If you want to export a database manually, to a Execl file by using SQL2005 export and Import Wizard this is the way.

0. Create a Execl file in 2003 format.
1. Go to your Database
2. Right click on the DB-> Tasks -> Export Data ..
3. Now you can see the export Wizard.
4. Click Next,check if the database is correct, If not change it. -> Next
5. Select the Destination as Microsoft Excel.-> Give the file path where you created the Execl file. -> Next.
6. Select 1st option -> Next
7. If you want to export all tables select all, or select as you want. -> Next
8. -> Finish.
9. Open the Execl file, the default first 3 pages may be blank. After that you can see your tables in each page.

Think it is the same in SQL2008.
Thanks

*** if you want to add a password to Execl file
1. Go to Save as.
2. There is a option called Tools near Save button, click it -> General Options
3. Dive the Password as you want.

Thanks.

这篇关于如何在密码保护的情况下将数据集的数据导出到多个Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！