I am trying to expand on the python script that was posted in this post:
My Revit schedule looks like the following:
The first column will be text data and the following information will be dimensional data.
The problem that I have is all data that is called via the getcelltext() function is purely that, only text. Is there a function that can pull numerical data from a cell in the Revit API? From what I could tell there was not. I tried the obvious getcellvalue() type functions, but to no avail.
My changed code looks like the following:
table = schedule.GetTableData().GetSectionData(SectionType.Body) nRows = table.NumberOfRows nColumns = table.NumberOfColumns #Collect all of data from the schedule dataListRow =  for row in range(nRows): #Iterate through the rows. The second row is always a blank space dataListColumn =  for column in range(nColumns): #Iterate through the columns if column == 0: dataListColumn.Add( TableView.GetCellText(schedule, SectionType.Body, row, column) ) else: dataListColumn.Add( TableView.GetCell(schedule, SectionType.Body, row, column) ) dataListRow.Add( dataListColumn ); # "End" the transaction TransactionManager.Instance.TransactionTaskDone() OUT = dataListRow
All data with the default python script is string data:
Any easy workarounds to get numerical data from a cell?