Skip to content
Extract Revit Properties into Excel: This sample uses Model Derivative API endpoints to read a Revit project properties and create a XLSX Excel file with one sheet for each type/category with all objects on it
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
samples server side for deploy Mar 31, 2017
server server side for deploy Mar 31, 2017
www Viewer 3.3 Dec 11, 2017
.gitignore server side for deploy Mar 31, 2017
LICENSE Update LICENSE Nov 2, 2017
README.md Renamed thumbnail to thumbnail.png Sep 17, 2018
app.json server side for deploy Mar 31, 2017
package.json server side for deploy Mar 31, 2017
start.js server side for deploy Mar 31, 2017
thumbnail.png Renamed thumbnail to thumbnail.png Sep 17, 2018

README.md

viewer-javascript-extract.spreadsheet

JavaScript sample to extract Revit files from Model Derivative API as Spreadsheet (Excel XLSX)

License Model-Derivative

Description

This sample uses Model Derivative API endpoints to read a Revit project properties and create a XLSX Excel file with one sheet for each type/category with all objects on it. Non-Revit files are not supported (different structure). Here is another version for desktop.

thumbnail

Demonstration

Run it live at this page

Usage

Add reference to the ForgeXLS file:

<script src="ForgeXLS.js"></script>

Then call downloadXLSX method passing the URN and a data:read token.

function downloadExcel() {
   ForgeXLS.downloadXLS(theURN, token, statusCallback /*Optional*/);
}

Dependencies

This project depends on Sheet JS to manipulate spreadsheet files. The FileSaver library is used to create & download a file on the client. BlobJS is required for older browsers (see compatibility). jQuery is also used.

<script src="jquery.min.js"></script>
<script src="Blob.js"></script>
<script src="FileSaver.min.js"></script>
<script src="xlsx.core.min.js"></script>

License

This sample is licensed under the terms of the MIT License. Please see the LICENSE file for full details.

Written by

Augusto Goncalves @augustomaia, Forge Partner Development

You can’t perform that action at this time.