Create Spreadsheet (Excel) on the client from translated Revit files

February 15, 2017

The idea is read all properties from a Revit translated project and create a spreadsheet, which is a common workflow for Revit users. A previous sample implemented this using C# on the server, now this post uses the same idea in JavaScript (pure browser). This is possible with the Sheet JS library to manipulate and generate XLSX files (note this is for Excel 2017+). 

Only Revit files were tested and that's where this sample is expected to work, other formats may have different ways of organizing data which may not make sense to export like this. 

Source code at Github and live version on Github pages. As you may see, it uses a Revit project used on different samples :-)

To use it just add reference to the libraries and call downloadXLSX:

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

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

// download using the URN and a data:read token
// the status callback is optional
ForgeXLS.downloadXLSX(theURN, access_token, statusCallback /*Optional*/);

 

Posts by author

Augusto Goncalves
Developer Advocate, Autodesk

Developer Advocate at Autodesk since 2008, working with both desktop and web/cloud apps using top technologies, like C#, JavaScript, NodeJS and any other that can solve problems and improve workflo