Exporting data to a pre-existing excel file on client machine from vb.net
Posted on 2008-02-01
I need to copy a set of data which include some parameters and table name to a pre-existing excel file on a client machine...
what I am trying to achive is that we currently have excel file in a particular path that takes input like tablename and couple of parameters ..this excel file have VBA code and macro that read the content of the table supplied as a parameter from the sqlserver and generate reports... currently this is done using a desktop application which passes the required parameter ..
I want to pass the same set of parameter from a web page , so that we can use this existing excel template for generating report ..while converting the desktop application to web based interface.
I will appreciate any help or idea on this ...