aps-extract-spreadsheet

KO | EN

gitlite — search

#hacktoberfest #go #android #linux #docker #macos #java #windows #awesome #cli #vue #awesome-list #mcp #open-source

aps-extract-spreadsheet

(★ 18)

Extract Revit Properties into Excel:This sample uses Model Derivative API endpoints to read Revit project properties and create an XLSX spreadsheet with one sheet for each type/category with all objects on it.

aps-extract-spreadsheet Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Extract Revit Properties into Excel

JavaScript sample to extract Revit files from [Model Derivative API](https://developer.autodesk.com/en/docs/model-derivative/v2) as Spreadsheet (Excel XLSX)

[![Viewer](https://img.shields.io/badge/Viewer-v7-green.svg)](http://developer.autodesk.com/)
[![License](http://img.shields.io/:license-mit-blue.svg)](http://opensource.org/licenses/MIT)
[![Model-Derivative](https://img.shields.io/badge/Model%20Derivative-v2-green.svg)](http://developer.autodesk.com/)

# 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](https://github.com/autodesk-platform-services/model.derivative-csharp-context.menu) for desktop.

![thumbnail](https://raw.githubusercontent.com/autodesk-platform-services/aps-extract-spreadsheet/master/thumbnail.png)

## Demonstration

Run it live at [this page](https://viewerxls.autodesk.io), or locally by following these steps:

- create an APS application if you don't have one yet ([tutorial](https://aps.autodesk.com/en/docs/oauth/v2/tutorials/create-app/))
- make sure you have at least one file prepared for viewing ([tutorial](https://aps.autodesk.com/en/docs/model-derivative/v2/tutorials/prep-file4viewer/))
- clone this git repository
- navigate to the repository root folder and install npm dependencies
  - on Windows/macOS/Linux: `npm install`
- prepare required environment variables
  - on Windows:
    ```
    set APS_CLIENT_ID=<your client id>
    set APS_CLIENT_SECRET=<your client secret>
    set APS_BUCKET=<your data bucket>
    ```
  - on macOS/Linux:
    ```
    export APS_CLIENT_ID=<your client id>
    export APS_CLIENT_SECRET=<your client secret>
    export APS_BUCKET=<your data bucket>
    ```
- run the application
  - on Windows/macOS/Linux: `npm run dev`
- go to http://localhost:3000

# Usage

Add reference to the ExportXLS file:

```
<script src="ExportXLS.js"></script>
```

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

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

## Dependencies

This project depends on [Sheet JS](https://github.com/SheetJS/js-xlsx) to manipulate spreadsheet files. The [FileSaver](https://github.com/eligrey/FileSaver.js/) library is used to create & download a file on the client. [BlobJS](https://github.com/eligrey/Blob.js) is required for older browsers ([see compatibility](https://github.com/eligrey/FileSaver.js/#supported-browsers)). [jQuery](https://jquery.com) 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](http://opensource.org/licenses/MIT).
Please see the [LICENSE](LICENSE) file for full details.

## Written by

Augusto Goncalves [@augustomaia](https://twitter.com/augustomaia), [APS Partner Development](http://aps.autodesk.com)

aps-extract-spreadsheet

aps-extract-spreadsheet Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

aps-extract-spreadsheet

aps-extract-spreadsheet Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README