Writing 2007 Excel File
I am creating an excel file with test data and am using that for validation. I have Office 2007 installed giving me a default 2007 format when I write my file. When I go to read the file with ...
Forum Discussion
Looks like the second option is SaveAs is XlFileFormat which designates the file format.
How do we access the enumeration for the file format option?
xcl = Sys.OleObject("Excel.Application");
workb = xcl.Workbooks.Add();
...
// I tried
var ff = Sys.OleObject("Excel.XlFileFormat.xlAddIn");
workb.SaveAs("myWork.xcl",ff);
// But got an error that it could not find class.
Thanks
How do we access the enumeration for the file format option?
xcl = Sys.OleObject("Excel.Application");
workb = xcl.Workbooks.Add();
...
// I tried
var ff = Sys.OleObject("Excel.XlFileFormat.xlAddIn");
workb.SaveAs("myWork.xcl",ff);
// But got an error that it could not find class.
Thanks
