from inside C# I am able to open an excel file by using
Connection object and read the cells etc. However when i
try to save it, it saves but the file has no formatting,
no cells etc. (see attached file) And this saved file
can't be opened again through the connection object. It
errors out on the following line - objConn.Open();
I think it is a problem with the save as statement I am
using,
theWorkbook.SaveAs
(filename,5,"","",false,false,0,0,true,"","");
What is wrong with it?
Thanks
Rao