- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Problem Summary
I am developing an add-in for Revit 2023 using C# and the Revit API. The goal is to export all schedules (ViewSchedules) to an Excel file, with each schedule being saved on a separate sheet. However, during the data extraction process, I encountered the following issues:
Certain fields or values are missing in the export:
- The column headers export correctly.
- Some parameter values, particularly custom parameters (e.g., "Código"), do not appear in the corresponding rows or are left blank in the Excel file.
Details of the Approach Used:
- I am using TableData and TableSectionData to access the schedule data.
- Column headers are retrieved using GetCellText(0, col).
- Row data is retrieved using GetCellText(row, col).
Data Verification in Revit:
- Using RevitLookup, I have verified that the missing parameter values are present and correctly assigned in the schedules.
- These parameters are visible in Revit and properly configured in the schedules.
Technical Setup:
- I am working with Revit 2023 and Visual Studio 2022.
- The method GetCellElementId, which was previously used in older API versions to get the ElementId associated with a cell, is no longer available in the Revit 2023 API.
Specific Questions
- Why are some parameter values not exported correctly to the Excel file, even though they are visible in Revit?
- Is there a reliable way to access all custom parameters or linked values in schedules using the Revit 2023 API?
- Should I consider an alternative approach to extract detailed data from TableData or ViewSchedule in this API version?
Solved! Go to Solution.