Hi,
I spent a few hours on google now but what I found was pretty crappy, most stuff 3 years old and not using a ms excel template so hence I writer here now.
The problem is to dump my dataset into a ms excel worksheet using the great worksheet template I already designed.
the browser should then prompt the user with the download. - I dont want to store it on the server.
I dont just want to throw the dataset on the sheet either, but do each cell individually . so e.g. UPDATE F3:F5 value ="Mike Testable",
UPDATE F3:F5 value ="Please sign here MR" + user.id
whereas F3 is formatted in the ms excel document.
how is that done the most efficient way, using .net 2 ? ..I head office objects is one way but was not able to find a template attribute that lets me define a template.
...
Go to the complete details ...