在Excel中将数据集导出到多个图纸中 [英] Exporting Datasets Into Multiple Sheets In Excel

问题描述

我有一个返回5个结果集的过程.现在，我想在1个Excel工作表中导出3个结果集，而在另一个Excel工作表中导出其余2个结果集.我们可以在C#.net代码中做到吗

谢谢，
Ram

Hi,

I had a procedure which returns 5 result sets. Now i want to export 3 results sets in 1 excel sheet and the remaining 2 resultsets in another excel sheet. Can we do this in C#.net code

Thanks,
Ram

推荐答案

是的，使用Aspose.Cells可以轻松实现.它是第三方工具.我记得您需要购买lisense. :)

http://www.aspose.com /demos/.net-components/aspose.cells/csharp/quick-start/data/export-data.aspx



否则，您需要遍历每个excel工作表，单元格等，并需要从每个数据表(来自数据集)中设置每个单元格的值.

谢谢
Arindam D Tewary，

Hi,

Yes this is achievable easily using Aspose.Cells. It is a third party tool. You need to purchase lisense as I remember. :)

http://www.aspose.com/demos/.net-components/aspose.cells/csharp/quick-start/data/export-data.aspx



Otherwise, you need to loop through each excel worksheet, cells etc and need to set each cells value from each data table(which is from dataset).

Thanks
Arindam D Tewary,

去这里，你也问过这里.
http://www.codeproject.com/Messages/3653856/Re-Exporting-Datasets-Into-Multiple-Sheets-In-Exce.aspx [

Go here, also you have asked here too.
http://www.codeproject.com/Messages/3653856/Re-Exporting-Datasets-Into-Multiple-Sheets-In-Exce.aspx[^]

这篇关于在Excel中将数据集导出到多个图纸中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！