How to use Data.ExportExcel method in a python scipt

Revit
, ,
6

Oh yes. My bad. I will change that in my post :+1:

import clr
import sys
sys.path.append('C:\Program Files (x86)\IronPython 2.7\Lib')
import System
from System import Array
from System.Collections.Generic import List as IList
clr.AddReference('ProtoGeometry')
from Autodesk.DesignScript.Geometry import *
clr.AddReference("RevitNodes")
import Revit
clr.ImportExtensions(Revit.Elements)
clr.ImportExtensions(Revit.GeometryConversion)
clr.AddReference("RevitServices")
import RevitServices
from RevitServices.Persistence import DocumentManager 
from RevitServices.Transactions import TransactionManager 

clr.AddReference("RevitAPI")
clr.AddReference("RevitAPIUI")

import Autodesk 
from Autodesk.Revit.DB import *
from Autodesk.Revit.UI import *

doc = DocumentManager.Instance.CurrentDBDocument
uiapp = DocumentManager.Instance.CurrentUIApplication 
app = uiapp.Application 
uidoc = uiapp.ActiveUIDocument

clr.AddReference("DSOffice")
import DSOffice
from DSOffice import *

filePath = IN[0]
sheetName = IN[1]
startRow = IN[2]
startCol = IN[3]
data = IN[4]
overWrite = False

list = []
for l in data:
	list.append(Array[object](l))

list2 = Array[object](list)	
list3 = Array[Array[object]](list2)

DSOffice.Data.ExportExcel(filePath, sheetName, startRow, startCol, list3, overWrite)
2 Likes