The excel plug-in works great, allowing us to push data to excel for additional analysis. Has anyone found a way to retain formatting of the target template when writing data? We're looking for more polish in the presentation of data, and writing data removes the colors, fonts, etc. of the template. Thanks!...
OriginalPostID-90067
Discussion posts and replies are publicly visible
Is there any update about this issue, apart from the "xmlss" workaround?
One approach we have done is to have a second sheet that has formulas that pulls the data from the sheet that Appian wrote to. We have used macros, etc. Hope that helps...
Hi ChristineH,
I tried your suggestion of using macros. But, when i pass the macro enabled file [.xlsm] as the document to update in Export DSE to Excel it is throwing me an error.
Any inputs on this will be really helpful.
Also, Mike Schmitt you seem to have been very active on Excel related topics. Your views on this will be much appreciated.
Thanking you guys in advance. Hoping for a solution.
Regards,
Karthik
Try using just formulas and not a macro file