<div>
it will be a job of copy and paste and because you are using ASP.Net, I strongly suggest to use 3rd party tool like <a href="http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx" rel="ugc">http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx</a>&nbsp;(instead of Office Automation)
</div>


it will be a job of copy and paste and because you are using ASP.Net, I strongly suggest to use 3rd party tool like http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx [http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx] (instead of Office Automation)

<div>
should i use an url instead of filename at here : xlApp.Workbooks.Open(filen<wbr />ame) ?<br />
because other parts also creating by program dynamically ?
</div>


should i use an url instead of filename at here : xlApp.Workbooks.Open(filename) ?
because other parts also creating by program dynamically ?

<div>
Here file name represents the file in the physical folder. &nbsp;i don't know exactly whether we can use url or not. what is the problem to specify file name in your dynamic program.
</div>


Here file name represents the file in the physical folder.  i don't know exactly whether we can use url or not. what is the problem to specify file name in your dynamic program.

<div>
3XLcom<br />
What to use for the filename depends on where the file is located,<br />
In Excel VBA you can use URL's but I've rarely seen that and I don't know what the VB.NET position woud be on the subject.<br />
Where does the dynamic thing come into it? What is being created dynamically?<br />

</div>


3XLcom
What to use for the filename depends on where the file is located,
In Excel VBA you can use URL's but I've rarely seen that and I don't know what the VB.NET position woud be on the subject.
Where does the dynamic thing come into it? What is being created dynamically?


<div>
yes it is creating dynamically by a generic handler and writing on a page as a xls mime type
</div>


yes it is creating dynamically by a generic handler and writing on a page as a xls mime type

<div>
Sorry i forget that comment help me to solve the question
</div>


Sorry i forget that comment help me to solve the question

<div>
<div class="content wysiwyg-content">
I want to combine multiple excel tables into one excel file with datasheets <br />
how should i do it ?<br />
<br />
thanks
</div>
</div>


I want to combine multiple excel tables into one excel file with datasheets 
how should i do it ?

thanks

combine excel files vb.net

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).