When I use datalink, it will not overwrite my cell formatting like background color. When I use PI Builder to retrieve data, it overwrites all cell formatting. Can you please edit your PI Builder code to behave more like Datalink in regard to preserving cell formatting?
From one of our Customers at WAPA - Some of our PI Tag Names have a leading zero "01234567". When this key is entered into Excel, you have to set the number format to 'Text' so that Excel does not automatically remove the leading zero. When you use the "Retrieve" option in PI Builder, the add-in resets the column type to 'General' and the leading zero is removed, making the key invalid "1234567".
This would be helpful.