# Sorting schedule as shown in Revit to Excel **URL:** \ **Category:** Revit\ **Tags:** dynamo\ **Created:** [September 25, 2019, 1:06pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069 "2019-09-25T13:06:42Z")\ **Posts on this page:** 16\ **Page:** 2
**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\ **Post date:** [September 26, 2019, 2:24pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/21 "2019-09-26T14:24:15Z")
it’s a little weird. doing otherwise ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/1/11599a4473d010e4e890b1d919778eac2d69880c.png) ---
**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\ **Post date:** [September 27, 2019, 11:19am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/22 "2019-09-27T11:19:19Z")
That worked, Thanks! Now I have another question if I may :). If I want to change the data in Excel and import it back to Excel I could do it from row 1 in Excel. But I only need to import the data from row 13 in excel. In Dynamo I could fill in the settings for the start row and column but those settings I can’t see at the “data.importexcel”. I also couldn’t find these information anywhere else on the internet ![Dynamo%20error%209](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/8/d865737cd31d3ec7deea2300bbf7430a9f50fa80.jpeg) ---
**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\ **Post date:** [September 27, 2019, 3:16pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/23 "2019-09-27T15:16:52Z")
use List.RemoveitemAt index" to remove unwanted items ---
**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\ **Post date:** [September 30, 2019, 7:07am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/24 "2019-09-30T07:07:50Z")
Sorry for my late answer. I tried to figure out in the weekend but I really feel like a noob now. I don’t know how to use the remove at index in this situation. Row 12 should be the text in Revit to change the parameters. ![Knipsel1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/9/69df30fe0f0a2eacf93d8c4eac62cb86c73a257b.jpeg) ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/1/c15adf5a6d064303e9d071f2a7d5dddd9700e8da.png) ![Knipsel2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/c/ccaf5ff0a469d02c45720ac4aa93fb32a619d539.jpeg) ---
**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\ **Post date:** [September 30, 2019, 9:33am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/25 "2019-09-30T09:33:12Z")
I did not understand your worries ---
**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\ **Post date:** [September 30, 2019, 9:52am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/26 "2019-09-30T09:52:05Z")
I did export the sheet information to excel with your help. Now I’d like to import excel back to Revit with the sheet information on Excel. But without the first 10 rows. That is just project information which I doesn’t need in Revit. Also there is an image in Excel which should not to be export. only the sheet information ---
**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\ **Post date:** [September 30, 2019, 11:42am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/27 "2019-09-30T11:42:57Z")
just enter the number of the list that corresponds to what you want to delete ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/8/f81ca52f6136bda94e9afa64c04664af852d753d.png) ---
**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\ **Post date:** [September 30, 2019, 12:40pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/28 "2019-09-30T12:40:13Z")
Of course! ^^. Will try to do the rest of it by myself. Let you know if I finish it. Thanks. ---
**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\ **Post date:** [September 30, 2019, 1:49pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/29 "2019-09-30T13:49:13Z")
Hi! I tried one column as an example. I changed the sheet number “MV-00” to “MM-00” in Excel. Now I want to export this to Revit. What goes wrong here? Also I see in “List.GetItemAtIndex” lot of empty spaces from Excel. Can I turn that “null” off? ![Knipsel4](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/f/1f9a01d7865c8e9fd997eca296bb635a0a7f9040.jpeg) ![Knipsel3](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/6/d6bb42e1ecfae1630e69f35cf9222866844b0add.jpeg) ---
**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\ **Post date:** [September 30, 2019, 2:38pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/30 "2019-09-30T14:38:23Z")
You change the number of the sheet, so the entry must be an element not a name also, pay attention to the order during your import ![PNG](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/8/3825066e38c8003b1ec8af84ad22be5543613db7.jpeg) ---
**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\ **Post date:** [September 30, 2019, 7:24pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/31 "2019-09-30T19:24:43Z")
Sorry I don’t get it : ( By which element should it be. Now they indeed say “Sheet Number” is already in use. I did look on the internet for examples but couldn’t find same situations like this. ![Knipsel5](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/4/c4947f6d6813c0f1d5014df569aaa6cc95b368b9.jpeg) ---
**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\ **Post date:** [October 1, 2019, 6:33am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/32 "2019-10-01T06:33:15Z")
If the number exists you can not rename Solution: first give a temporary number, then inject the true value you use the SetParameters nod twice ---
**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\ **Post date:** [October 1, 2019, 7:14am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/34 "2019-10-01T07:14:45Z")
> [@Akli.baliche](#): > > If the number exists you can not rename > Solution: first give a temporary number, then inject the true value > you use the SetParameters nod twice I don’t understand. I use GetParameter once and SetParameter once. Could u maybe show it if you mind? ---
**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\ **Post date:** [October 1, 2019, 7:41am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/35 "2019-10-01T07:41:09Z")
![PNG](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/7/37099cbd2173bb69383a9f6a61a5c66c33f9cd74.jpeg) ---
**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\ **Post date:** [October 1, 2019, 8:23am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/36 "2019-10-01T08:23:49Z")
Yeah but they still say the “String” “Sheet Number is already in use” I just like to change the Sheet Number in Revit from Excel but have the feeling it is not possible? ![Knipsel7](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/4/147bb15923b01cff1508d9d7777d129a9cee21ae.jpeg) ![Knipsel8](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/4/24d3b8172aed9c626aad8861cc8bcd43b9dacb6d.jpeg) ---
**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\ **Post date:** [October 1, 2019, 8:44am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/37 "2019-10-01T08:44:18Z")
> [@muis.r](#): > > mais avez-vous l If it’s possible, for simplicity, could you send your dynamo [Previous page](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069.md?page=1)