Importing an excel sheet using c#

[Anonymous]

How can one import an excel file to Revit and create a schedule from it. Please include source code.

[Anonymous]

You can't. Schedules are related to Revit elements and parameters. It can't be used to display random data.

[Anonymous]

Thanks you for your response. I have another question then, how would u
then display random revit elements and parameters

[devonpowell]

It might help if you explained a bit more about what you are trying to accomplish, and the reason. Often we have an excel file (for example a calculation) that isn't a schedule of Revit elements but is just tabular information we need to communicate on drawings. We use an add-in called rushforth tools that converts the excel file to a drafting view. You could write an add-in/macro that would do that if you don't want to pay for an add-in. 

In general this forum will not give you complete solutions to your entire development project, but will help you solve specific issues you are having with development. 

you can always place some random families and give them random shared parameters, then schedule those. 

OR print the excel file to a image file, and link/import that into a view/sheet. 

Hope this helps. 

[Anonymous]

I have done all of the following way of bringing in Excel data to Revit.

1. Convert Excel to Images and place the images on sheets.

2. Convert Excel to text and place text in drafting views.

3. Convert Excel to elements and create a note schedule from the elements.

For options 2 and 3 I used the ClosedXML project to help access the Excel file (https://github.com/ClosedXML/ClosedXML)

[Anonymous]

you could use https://zetexcel.com/. Currently, I am working on a cross-platform application and it helps me a lot to create excel spreadsheets.