Hello, is there any method in dynamo to automatically adjust the column widths of excel spreadsheets according to the contents of each instead of visually narrow? Is it possible to add formatting such as bold, font size, all through the dynamo itself? See the problem: [image] Thanks!

Yes, rather than accessing a single worksheet by index you can loop through each of the worksheets. import clr clr.AddReferenceByName('Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c') from Microsoft.Office.Interop import Excel ex = Excel.Applicat…

Formating Excel with Dynamo... Is it possible?

Revit

Glauber_Omma August 21, 2019, 2:26pm 3

Uau, thanks thanks! But, there is one problem: my Excel contains more than one sheets in the same file…

The python code need to be different… is it ok?

Duplicate Excel worksheet and Rename

Topic		Replies	Views
After writing to an excel file, do another operation on it Revit excel	2	189	February 21, 2023
¿How to customize excel files with dynamo and Python...? Developers python , dynamo	11	895	June 30, 2021
How to auto size in excel after export from dynamo? Revit python , dynamo	4	540	June 9, 2022
Format Excel Through Dynamo Packages bumblebee	2	1197	June 15, 2017
Excel and Dynamo Packages	2	355	November 3, 2014

Formating Excel with Dynamo... Is it possible?

Related Topics