Remove First Row of Every Excel Worksheet
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have an issues where I am using the directory to pull all excel sheets in a certain folder and then a macro to pull them into Alteryx. Well every Excel sheet has data on the first row that I do not want. I want the second row to be the column titles (which I know can be done with a Dynamic Rename) but I need to get rid of all the first rows to start. I know I could filter but it is causing these first rows of data to mark them as column titles which I do not want. Each month I am going to add a new Excel sheet and that will add a new column title. Any suggestions for deleting the first row of data on each excel sheet before the macro?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If I put it right after the directory, then it just removes one of my Excel sheets on the macro input.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You need to do it inside the macro.
You can also set the Input data tool in the macro to start reading on line 2, then you don't need the sample tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Wow, didn't even think of that! This is perfect, thank you 🙂
