Excel format with BB Style only lasts a second :S


#1

Hi all,

I’m trying to format an Excel file. In the same graph I’m exporting data to Excel with Excel.WriteToFile node and formatting the spreadsheet with BB Style and Format Excel.

It works, however the style only lasts for a split second and then the style formatting is reverted.

I’ve tried Automatic and Manual mode, using passthroughs but makes no difference. Do I need to write the excel data with the nodes from the Bumblebee package as well?

Any clue on why this is happening?

Thanks


#2

Not necessarily, but you definitely need to delay th formatting until after the data is written.

Add wait for method acordingly.


#3

Thanks. I’ve tried with transaction end and passthrough nodes with no luck.

What seems to make a difference is setting the overWrite Boolean to false in the Excel.WriteToFile node.