I am writing a C# WPF application to load an Excel file, fill out named ranges with data, display it in progress during the process then save a new Excel file all filled out at the end. The template(ish) Excel file has formulas, conditional formatting and images in it. The program will fill the named ranges with text and numeric information as well as other illustrations images.
So far I’ve gotten as far as loading the file, filling out text and numeric information, inserting images, displaying in progress and saving out an excel file. However in progress and in the saved out file the conditional formatting is gone and the images in the original are gone. It seems like the load process discards conditional formatting and the images. Any idea why images and conditional formatting would be lost on load?