07-21-2015 12:10 PM
I am tryin to import an Excel file that has three sheets, but when I try to use a libname statement to access the sheet names, it only seems to pick up 2 sheets. Does anyone have experience with this and can tell me what the issue might be?
The code I'm using is:
libname xl "C:\....\Sample File.xls";
Thanks a lot
07-21-2015 05:41 PM
For example, the sheet names are:
1) Cash and Liquidity Cushion Mgt
2) Cash Movement Summary
3) Fees & Misc.
I have a few hundred Excel files with varying numbers of sheets, but the first sheet ("Cash and Liquidity Cushion Mgt") is never identified. I tried renaming or re-ordering but to no avail.
07-21-2015 05:46 PM
Then it's something in the sheet.
How does this one differ from the others?
Copy the workbook and delete sections of the sheet at time (binary search) until you narrow it down.
07-21-2015 06:43 PM
Excel sheets can have blanks that aren't seen unless you highlight the name like preparing to rename. And even then depending on the font may not be noticeable. I was suspecting long names which is why I asked earlier.