I want to pour my excel sheet data into a templated excel sheet
I want to pour my excel sheet data into a templated excel sheet. i have a templete for good desiging now i want to pour my data in that template
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
vipin sainiPosted Jul 28, 2011, 3:51 AM
Jiteendra SampathiraoPosted Jul 28, 2011, 3:03 AM
write this:
In class file....
public void SaveAs(string strFileName)
{
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;
oDoc.SaveAs(fileName, missing, missing, missing, missing, missing, missing, missing, missing, missing,
missing);
}
in code behind page...
test.Saveas(filepath + "tempfilenamewitjfileextension");
Here test means object instance of Class file.....
oDoc means object instance of Excel Document....