如何在excel文件的不同表格中导出不同选项卡的内容？ [英] How can I export content of different tabs in different sheet of a excel file?

查看：105
本文介绍了如何在excel文件的不同表格中导出不同选项卡的内容？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

这是我的.aspx页面的鳕鱼



This is my cod of .aspx page

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>jQuery UI Tabs - Default functionality</title>
<link rel="stylesheet" href="//code.jquery.com/ui/1.10.4/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css">
<script>
$(function() {
$( "#tabs" ).tabs();
});
</script>
</head>
<body>
<div id="tabs">
<ul>
<li><a href="#tabs-1">Nunc tincidunt</a></li>
<li><a href="#tabs-2">Proin dolor</a></li>
<li><a href="#tabs-3">Aenean lacinia</a></li>
</ul>
<div id="tabs-1">
<table border="1" style="width:300px">
<tr>
  <td>Jill</td>
  <td>Smith</td>		
  <td>50</td>
</tr>
<tr>
  <td>Eve</td>
  <td>Jackson</td>		
  <td>94</td>
</tr>
<tr>
  <td>John</td>
  <td>Doe</td>		
  <td>80</td>
</tr>
</table>
</div>
<div id="tabs-2">
<table border="1" style="width:300px">
<tr>
  <td>Suman</td>
  <td>Milon</td>		
  <td>50</td>
</tr>
<tr>
  <td>Eve</td>
  <td>Jackson</td>		
  <td>94</td>
</tr>
<tr>
  <td>Jamal</td>
  <td>Karim</td>		
  <td>80</td>
</tr>
</table>

</div>
<div id="tabs-3">
<table border="1" style="width:300px">
<tr>
  <td>Hena</td>
  <td>Mena</td>		
  <td>58</td>
</tr>
<tr>
  <td>Jamila</td>
  <td>Munira</td>		
  <td>94</td>
</tr>
<tr>
  <td>Habib</td>
  <td>Sourav</td>		
  <td>80</td>
</tr>
</table>

</div>
</div>
</body>
</html>





现在我要添加导出按钮。如果我单击导出按钮，我将获得一个excel文件，其中不同选项卡的内容将保存在此excel文件的不同表格中。



任何人都可以为此提供代码问题使用C＃.Net？



Now I want add a export button. If i click the export button I will get a excel file where content of different tab will save in different sheet of this excel file.

Can anyone provide the code for this issue using C#.Net?

推荐答案

（ function （）{


（ ＃tabs）。tabs（）;
}）;
< / script >
< / head >
< body >
< div id = < span class =code-keyword>标签 >
< ul >
< li > < < span class =code-leadat致敬> a href = ＃tabs-1 > Nunc tincidunt < / a > < / li >
< li > < a href = ＃tabs-2 > Proin dolor < / a > < / li >
< li > < a href = ＃tabs-3 > ; Aenean lacinia < / a > ; < / li >
< / ul > ;
< div id = tabs-1 >
< table border = 1 style = width：300px >
< tr >
< td > Jill < / td >
< td > Smith < / td >
< td > 50 < / td >
< / tr >
< tr >
< td > Eve < / td >
< td > 杰克逊< / td >
< td > 94 < / td >
< / tr >
< tr >
< td > John < ; / td >
< td > Doe < / td >
< td > 80 < / td >
< / tr >
< ; / table >
< / div >
< div id < /跨度> = tabs-2 >
< table border = 1 样式 = 宽度：300px >
< tr >
< td > Suman < / td >
< td > Milon < / td >
< td > 50 < / td >
< / tr >
< tr >
< td > Eve < / td >
< td > 杰克逊< / td >
< td > 94 < / td >
< / tr >
< tr >
< td > Jamal < / td >
< td > Karim < / td >
< td > 80 < / td >
< / tr >
< / table >

< / div >
< div id = tabs-3 >
< 表 border = 1 样式 = width：300px >
< tr >
<td>Hena</td>
<td>Mena</td>\t\t
<td>58</td>
</tr>
<tr>
<td>Jamila</td>
<td>Munira</td>\t\t
<td>94</td>
</tr>
<tr>
<td>Habib</td>
<td>Sourav</td>\t\t
<td>80</td>
</tr>
</table>

</div>
</div>
</body>
</html>
( "#tabs" ).tabs(); }); </script> </head> <body> <div id="tabs"> <ul> <li><a href="#tabs-1">Nunc tincidunt</a></li> <li><a href="#tabs-2">Proin dolor</a></li> <li><a href="#tabs-3">Aenean lacinia</a></li> </ul> <div id="tabs-1"> <table border="1" style="width:300px"> <tr> <td>Jill</td> <td>Smith</td> <td>50</td> </tr> <tr> <td>Eve</td> <td>Jackson</td> <td>94</td> </tr> <tr> <td>John</td> <td>Doe</td> <td>80</td> </tr> </table> </div> <div id="tabs-2"> <table border="1" style="width:300px"> <tr> <td>Suman</td> <td>Milon</td> <td>50</td> </tr> <tr> <td>Eve</td> <td>Jackson</td> <td>94</td> </tr> <tr> <td>Jamal</td> <td>Karim</td> <td>80</td> </tr> </table> </div> <div id="tabs-3"> <table border="1" style="width:300px"> <tr> <td>Hena</td> <td>Mena</td> <td>58</td> </tr> <tr> <td>Jamila</td> <td>Munira</td> <td>94</td> </tr> <tr> <td>Habib</td> <td>Sourav</td> <td>80</td> </tr> </table> </div> </div> </body> </html>





Now I want add a export button. If i click the export button I will get a excel file where content of different tab will save in different sheet of this excel file.



Can anyone provide the code for this issue using C#.Net?



Now I want add a export button. If i click the export button I will get a excel file where content of different tab will save in different sheet of this excel file.

Can anyone provide the code for this issue using C#.Net?


you can use epplus serverside.



create a generic method that gives the datasource and split the usage between rendering and exporting.
you can use epplus serverside.

create a generic method that gives the datasource and split the usage between rendering and exporting.


这篇关于如何在excel文件的不同表格中导出不同选项卡的内容？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发语言最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆