How to read multiple excel sheets from a single excel file
at once????

Answer Posted / rajesh

First you have to split the excel sheets and write the
program in macros and use the dde triplet.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain the proc in sas? : Sas-administrator

843


explain about data integrator metadata reports? : Sas-di

827


Mention the difference between ceil and floor functions in sas?

903


What are the difference between sas functions and procedures?

855


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

853


what is sas and what are the functions? : Sas-administrator

753


Differentiate between sas functions and sas procedures.

874


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

973


Explain what is SAS informats?

834


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

1879


how do you pull data from equifax?tell me the process?

1579


what is operational data and operational system? : Sas-di

868


what is treatment emergent events and treatment emregent adverse event

2156


For what purposes have you used sas macros? : sas-macro

772


Explain the special input delimiters used in sas programming.

787