topic Reading Excel Points in Revit API Forum

Reading Excel Points

ahmadkhalaf7892 — Wed, 14 Dec 2022 08:13:00 GMT

Hi Everyone, is there any way I can read the points from an excel file ? For example here you can see that we have a set of XY Points, like in the Photo, P0 would have the coordinates of (76,-145,0), P1 would have the coordinates of (66,127,0)..., Is there any way I can read them?
Also can we create a model line from P0 to P1, then from P1 to P2, etc..., I'd appreciate any help
Thanks

Re: Reading Excel Points

moturi.magati.george — Wed, 14 Dec 2022 12:33:58 GMT

Hi @ahmadkhalaf7892,

If I understood your question correctly, you want to know if you can read data from an MS Excel file. If that is the case, I believe you can achieve what you want by using c# or python languages. After reading the data in the worksheet, you can then pass it to the Revit API. There are several examples on how to do that and I will share a few on how to read excel files in c#:

https://stackoverflow.com/questions/9155642/how-to-read-an-excel-file-in-c-sharp-without-using-microsoft-office-interop-exce

https://www.c-sharpcorner.com/UploadFile/01a5f9/read-and-write-the-spreadsheet-without-any-dependency/

https://csharp.hotexamples.com/examples/NPOI.XSSF.UserModel/XSSFWorkbook/-/php-xssfworkbook-class-examples.html

Let me know if this works for you

Re: Reading Excel Points

jeremy_tammik — Wed, 14 Dec 2022 12:50:07 GMT

Also please note you you can vastly simplify your workflow by exporting from Excel to CSV format. The result is a simple comma-delimited text file that you can easily parse yourself in any language you like:

https://duckduckgo.com/?q=csv+parser

Re: Reading Excel Points

ahmadkhalaf7892 — Wed, 14 Dec 2022 12:51:36 GMT

Hi @moturi.magati.george
Thanks a lot for your help , I'll check them now

Re: Reading Excel Points

ahmadkhalaf7892 — Wed, 14 Dec 2022 12:52:51 GMT

Hi Jeremy,
By that you mean I can read them using a normal text file not an excel sheet right ?
do you have any idea how I can create the points though? Thanks

Re: Reading Excel Points

jeremy_tammik — Wed, 14 Dec 2022 13:27:15 GMT

In Excel, simply save as CSV.