BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
nrose
Quartz | Level 8

Hi all,

This is probably more of a question for Chris, but if anyone knows, I am not sure how to implement custom tasks so that they can read in data from Excel as input. The usual call in C# is to use:

SasData data = new SasData(this.Consumer.InputData[0] as ISASTaskData2

but this assumes the data is SAS based from a library. When you run the task in Excel, and the user chooses Excel data, a window appears that allows the user to select the cells that contain the data of interest, but when the variable selector appears, no data variables appear in the selection, presumably because the Excel data was not able to be read in. A workaround is for the user to first copy the Excel data to the work library, and to run the task on this, but there must be a way of reading in the data as part of the custom task.

Any help appreciated.

Nick

                    );

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

Nick,

In this case, you will need to rely on a different API to get to information about this "unrealized data" -- data that is in the spreadsheet but not yet copied to SAS.  The Office Add-In supports these APIs (as does EG) to surface information about data sources independent of the easier-to-use SasData classes.

The technique uses ISASTaskDataAccessor and ISASTaskDataColumn APIs, which are shown in the Top N Report example in my Custom Tasks book (see Chapter 9).  You can access the sample code in my GitHub repository - see the TopNReportForm.cs file.

Hope this helps,

Chris

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

View solution in original post

2 REPLIES 2
ChrisHemedinger
Community Manager

Nick,

In this case, you will need to rely on a different API to get to information about this "unrealized data" -- data that is in the spreadsheet but not yet copied to SAS.  The Office Add-In supports these APIs (as does EG) to surface information about data sources independent of the easier-to-use SasData classes.

The technique uses ISASTaskDataAccessor and ISASTaskDataColumn APIs, which are shown in the Top N Report example in my Custom Tasks book (see Chapter 9).  You can access the sample code in my GitHub repository - see the TopNReportForm.cs file.

Hope this helps,

Chris

Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
nrose
Quartz | Level 8

Thanks Chris, that worked.

Although the SaSData class is a bit easier to use, the API you mentioned has the advantage of allowing Excel data to be used, without much extra effort.

Nick

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1006 views
  • 0 likes
  • 2 in conversation