Wednesday, November 5, 2014

C#: Convert Excel File to Unreadable format or .err file

   public string Excelfilepath = string.Empty;          
Excelfilepath = @"C:\Users\abc\Desktop\xyz\pqr.xls";
FileInfo f = new FileInfo(Excelfilepath);
                string filefullname = f.Name;
                string fileextension = f.Extension;
                string filename = string.Empty;
                filename = filefullname.Substring(0, filefullname.Length - fileextension.Length);
                if (File.Exists(f.DirectoryName + "\\" + filename + ".err"))
                {
                    File.Delete(f.DirectoryName + "\\" + filename + ".err");

                }
                if (File.Exists(f.DirectoryName + "\\" + filename + ".xls"))
                {
                    f.MoveTo(Path.ChangeExtension(Excelfilepath, ".err"));
                }

No comments:

Post a Comment