public partial class mergeExcel_WebForm4 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Excel.Application app = new Excel.Application(); Excel._Workbook result = app.Workbooks.Add();
Excel._Workbook wb1 = app.Workbooks.Open(Path.GetFullPath(@"D:/zjj/a.xlsx"));
Excel._Workbook wb2 = app.Workbooks.Open(Path.GetFullPath(@"D:/zjj/b.xlsx")); foreach (Excel._Worksheet each in wb1.Sheets)
{
each.Copy(result.Worksheets[1]);
} foreach (Excel._Worksheet each in wb2.Sheets)
{
each.Copy(result.Worksheets[1]);
} result.SaveAs(@"D:\zjj\result.xlsx"); Response.Write("<script>alert('merge successfully');</script>");
wb1.Close();
wb2.Close();
app.Quit();
{
protected void Page_Load(object sender, EventArgs e)
{
Excel.Application app = new Excel.Application(); Excel._Workbook result = app.Workbooks.Add();
Excel._Workbook wb1 = app.Workbooks.Open(Path.GetFullPath(@"D:/zjj/a.xlsx"));
Excel._Workbook wb2 = app.Workbooks.Open(Path.GetFullPath(@"D:/zjj/b.xlsx")); foreach (Excel._Worksheet each in wb1.Sheets)
{
each.Copy(result.Worksheets[1]);
} foreach (Excel._Worksheet each in wb2.Sheets)
{
each.Copy(result.Worksheets[1]);
} result.SaveAs(@"D:\zjj\result.xlsx"); Response.Write("<script>alert('merge successfully');</script>");
wb1.Close();
wb2.Close();
app.Quit();
解决方案 »
- DataGridView使用困惑
- c# 为excel单元格添加链接时,总是出现异常来自 HRESULT:0x800A03EC
- 如何在winform 中把图片控件导出到Excel中????
- 多线程引起的奇怪问题!
- 字符串中隐藏的特殊字符
- textbox在智能设备上的焦点问题
- WinForm: ScrollBar 怎么实现对用户控件滚动显示和重绘
- 窗体的布局问题!
- [超级难题]WinForm中DataGrid绑定了外键,如果取得DataGrid总行数?
- 一个小问题,大家近来,分不够加!
- C#获取服务详细信息ExecutionEngineException异常
- c#的Image,在界面放大缩小显示的时候,能否设置放大缩小显示的算法?
static bool IsEmpty(Excel._Worksheet arg) {
bool result = false;
if (arg.UsedRange.Count == 1) {
if (arg.Cells[1][1].Value == null) {
result = true;
}
}
return result;
}