Fabrication in Revit® > Dynamo for Autodesk┬« Revit

exporting data to Excel

<< < (2/3) > >>

craigjonnson:
Have you had a look at DiRoots sheetlink. Its free and misght be a lot closer to your requirements. There is an option to export as per your Revit formatting, but doesnt allow bidirectional data if you choose that option.
All of DiRoots tools i use on a daily basis.

Darren Young:
Use two spreadsheets or export to CSV.

One Spreadsheet/CSV is the raw data. Second Spreadsheet imports the other with Power Query into a table that you can sort/filter/format.

When the underlying data changes, just refresh the Power Query in the other sheet.

 

cnash:

--- Quote from: Darren Young on Jul 20, 2022, 06:39:19 AM ---Use two spreadsheets or export to CSV.

One Spreadsheet/CSV is the raw data. Second Spreadsheet imports the other with Power Query into a table that you can sort/filter/format.

When the underlying data changes, just refresh the Power Query in the other sheet.

 

--- End quote ---

Hey! That's what I said... Just worded a whole lot better.  haha!

bitterfitter:
A huge thank you to everyone for giving me quite a few options.  I ended up making the Macro in Excel since it was super easy and takes just one click to run it.  By saving it and placing it in my taskbar in Excel, it is there in all my workbooks and as simple as a single click and all the data is formatted.  Also really easy to change the Macro if needed.  I am going to look into the other options everyone gave and see if there is an easier way.  Thanks again!!

cadbyken:
Not a power Excel user but enjoy using "what I know" (and relearning it when I don't use it that often, lol).  Never heard of the Power Query function.  That opens up a whole new world of possibilities.  Thanks.

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version