Run XSFormatCleaner.xla from c# script task in Visual Studio 2008

Jun 7, 2013 at 1:14 PM
I am currently building a SSIS package that will automatically process excel files for me company that are currently being done manually. Normally we would run the XSFormatCleaner from the addin ribbon however since I am automating the rest of the process I would like to run the XSFormatCleaner via a script task but do not know how since I am pretty new to c# and VS. I tried xlApp.Run("XSFormatCleaner") but always receive an error. Any help would be greatly appreciated.