Excel and Dynamo


#1

Hi everyone!

 

I was wondering if there’s a way to keep my Excel formatting during sync with Dynamo. Like for example I would like to keep my Column titles and assigned cell colors for each column. Every time I click Run in Dynamo it rewrites my excel spreadsheet and I would have to manually adjust the formatting again (to make it more presentable).

 

Thanks!


#2

What I’d usually do is have 2 sheets in excel. Sheet1 will hold the data. Sheet 2 will hold my formatting( column and/or roll names) and would then reference the data from Sheet1 (=Sheet1!A1)


#3

Thanks Dimitar Venkov.