Extract the number of Tabs and their Names from spreadsheets

Reply
Contributor
Posts: 66

Extract the number of Tabs and their Names from spreadsheets

Hello experts,
I am working on a project where I need to find

1. Spreadsheet names ( I have done that)

2. Names of the tabs in each spreadsheet

3.Count of number of tabs in each spread sheet

from  a folder containing numerous spreadsheets(Xls files).

I am struggling on second step, if you have any resources or advice, please share with me.

Thanks,

Raghu.

Super User
Super User
Posts: 7,997

Re: Extract the number of Tabs and their Names from spreadsheets

Hi,

Set a libname to the Excel file:

libname myexcel excel "xxx.xlsx";

Then you can access sashelp.vtable to see what tabs are within.

Make sure you libname myexcel clear; afterwards.

Ask a Question
Discussion stats
  • 1 reply
  • 148 views
  • 0 likes
  • 2 in conversation