I’m going through a process of using BVN Batch Processor to test multiple Revit files. The idea is, there is a template Excel file that already has all the categories in it and for each Revit file getting tested, the information will be inserted under each appropriate categories. Also it is important to include a piece of graph or code that saves each file separately - we don’t want those multiple Revit file results to override each other.
thanks to @Kulkul who helped me with the code and it saves a separate Excel file for each Revit file. The trouble that I’m seeing is that those results are not in a form of my template Excel file, rather all the information get inserted in an empty Excel sheet.
if you see the code
OUT = IN+’_’+doc.Title+’.xlsx’
this part seems very straight forward and should be using whatever the file that is in the file path - which i set as my template Excel file.
this is the template Excel file. when I run the script without that Python code, the information get inserted in this file. With the code, it uses an empty Excel sheet instead of my template.
Thank you very much guys!