Skip to Main Content
Coming Soon: On April 2nd, all Suggestion Boxes will be migrating to The Network, Trimble's online user community. Your posts, votes, comments, and user accounts will transfer. This site will become read-only after the migration, and this banner will have a link to the new location for ProjectSight suggestions.
Categories API
Created by Guest
Created on Mar 21, 2023

Create an Excel Report Builder API that allows you to query and connect to data in ProjectSight in real time without having to export the data into excel.

During the Prolog and Converge era, Trimble had a product that allowed data to be connected directly to Excel directly through an API. This connected Excel file maintained all security and was very useful in extracting the data and then formatting the data in a consistent way. This file allowed you to skip the process of exporting the data manually, instead allowing you to open the excel file directly, authenticate yourself, then hit refresh to download and refresh the data. The advantage is the data view can be customized much easier this way than through Crystal Reports, and gives the user control of the data in a more useful way.

  • Attach files