Excel question

[SimpleMan75]

Here's the scenario I've been approached with -
We have an Excel template - what I need to do, is use that Excel template,
hit a database, and refresh the data within the Excel sheet with the new
data.
Anybody have a link on a VB.Net sample, for something like this?

 

[Lit]

From Google search...

http://www.vbdotnetheaven.com/Uploa...adsheet04182005093012AM/ExcelSpreadsheet.aspx


Lit

 

[SimpleMan75]

Thank you, but that did not answer my question - - -

I know how to create an Excel sheet - basically, I know how to open an
existing file

I need to know how to open a file/existing template, and hit a stored
procedure, to get/refresh the data, and then, put that data inside the open
file, in the correct place, based on the template

 

[Mark Rae [MVP]]

Thank you, but that did not answer my question - - -

I know how to create an Excel sheet - basically, I know how to open an
existing file

I need to know how to open a file/existing template, and hit a stored
procedure, to get/refresh the data, and then, put that data inside the
open file, in the correct place, based on the template

For that, you'll need Aspose:
http://www.aspose.com/Products/Aspose.Cells/Default.aspx

 

[Lit]

http://forums.devx.com/showthread.php?t=155202

Lit

 

[Mark Rae [MVP]]

http://forums.devx.com/showthread.php?t=155202

Ignore that completely...

Server-side Office automation is not supported by Microsoft because it
doesn't work:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2
http://support.microsoft.com/default.aspx/kb/288367