Export Panel Schedules to Excel

 

هناك طريقة لكنها مكلفة

http://apps.exchange.autodesk.com/RVT/en/Detail/Index?id=appstore.exchange.autodesk.com%3Apanelscheduleexporter_windows32and64%3Aen



 

لو حد استطاع الحصول عليها يا ريت يرسلها حتى اشرحها

 

هناك طريقة اخري بواسطة اداة مجانية لمن اشتري نسخة ريفيت

 

Go to Add-ins > External Tools > DB Link



On the ODBC Tab select "Select New Connection" and hit Export.

On the Select Data Source dialog, hit New.

Select "Microsoft Access Driver (*.mdb, *.accdb) and hit Next.

On the next window hit Browse and browse to the location where you want the Database file. Once there, enter a name and hit Save, then Finish.

On the ODBC Microsoft Access Setup dialog, hit Create.

In the New Database window enter the final name of the Database file and hit Ok. You should get a message saying your .mdb file was created successfully.

Hit Ok twice, and you should get back to the screen below:



 

Hit Ok, and an export progress bar should come up.

 

Once the export is finished, Open it with Excel and select Electrical Circuits. The Headers are the parameters associated with Circuits.

 

 

هناط كريقة اخري لو تعرف برمجة

http://inside-the-system.typepad.com/my_weblog/revit_mep_tips/

 

 

You will need some flavor of Microsoft Visual Studio to build the sample.  You can download Microsoft Visual C# 2010 for free.

From the installation image or DVD for Revit, upzip the file \DVD\Utilities\SDK\RevitSDK2014.exe

In Visual C# 2010 Express:


  1. File > Open Project

  2. Browse to the folder \Software Development Kit\Samples\PanelSchedule\CS

  3. Select the file PanelSchedule.csproj

  4. Click Open



Make sure the Solution Explorer is visible


  1. View > Other Windows > Solution Explorer

  2. In the Solution Explorer, expand References



Depending on your flavor of Revit (from a Suite, or stand-alone MEP), you may see a yellow warning icon on RevitAPI and RevitAPIUI. If you don’t see the yellow warning icon, skip to step 21.


  1. Select RevitAPI and RevitAPIUI.

  2. Right click, and select Remove.

  3. If prompted that they will be removed, click OK.

  4. Right click on References, and click Add Reference…

  5. In the Add Reference window, select the Browse tab.

  6. Browse to the appropriate folder, depending on your installation




  • From a Suite:

    • C:\Program Files\Autodesk\Revit 2014



  • Stand-alone MEP:

    • C:\Program Files\Autodesk\Revit MEP 2014






  1. Scroll to RevitAPI.dll

  2. Click to select it.

  3. Scroll to RevitAPIUI.dll

  4. Hold the CTRL key, and click to add to the selection.

  5. Click OK.

  6. In the Solution Browser, select RevitAPI and RevitAPIUI.

  7. Right click, and select Properties

  8. In the Properties window, make sure Copy Local is set to False



Build the sample


  1. From the Debug menu, click Build Solution.

  2. If prompted with a Save of Read-Only File, click Overwrite.

  3. In the Save File As window, click Save to accept the default save location.

  4. Close Visual C# 2010 Express.



 

In Windows Explorer:


  1. Browse to the folder \Software Development Kit\Samples\PanelSchedule\CS

  2. Copy the file




  • PanelSchedule.addin



to


  • C:\ProgramData\Autodesk\Revit\Addins\2014




  1. Browse to the sub-folder \bin\Release

  2. Copy the files




  • PanelSchedule.dll

  • template.html



to


  • C:\ProgramData\Autodesk\Revit\Addins\2014



Launch Revit


  1. Open a project (or create a new one)

  2. On the Add-Ins tab > External panel > External Tools



You should see three new commands:


  • Panel Schedule Sample – Export Data

    • Exports all panel schedules (as .csv or .html) to the folder where the PanelSchedule.dll exists.



  • Panel Schedule Sample – View Instance Creation

    • Creates the panel schedule using the default template for the panel currently selected in the model.



  • Panel Schedule Sample – Sheet Instance Creation

    • Places all panel schedules in the current sheet view.





 

طريقة رابعة

 

صدرها ل pdf او كاد ثم حوله لاكسل



http://revitoped.blogspot.com/2008/09/revit-mep-panel-schedule-export.html



 

تعليقات

إرسال تعليق

المشاركات الشائعة