Challenge #19: Excel Record Locator
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
nini
8 - Asteroid
01-12-2019
02:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Aidan_K
11 - Bolide
01-14-2019
03:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
PhilBalderson
8 - Asteroid
01-14-2019
09:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
PhilBalderson
8 - Asteroid
01-14-2019
09:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
KeithTroutt
8 - Asteroid
01-18-2019
11:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
jdunkerley79
ACE Emeritus
01-18-2019
02:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Verakso
11 - Bolide
01-21-2019
01:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Must admit that I have skipped a few challenges, but the prior ones was still to turf for me at my current level, so this was nice and basic
Spoiler
So the obvious trick was to use a wildcard while reading in all the *.xls files.
I am just happy that we was not supposed to read in the other sheets, since there seems to be some major differences between .xls and .xlsx files,
So this was my weekly challenge #30
Br
/Thomas
Suzu
9 - Comet
01-22-2019
11:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
TharunReddy
8 - Asteroid
01-25-2019
07:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
rfergus
8 - Asteroid
01-25-2019
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Added some extra steps so I could reuse this later by having an input text with row and column names.