DATA Step, Macro, Functions and more

reading a formatted spreadsheet

Reply
Contributor
Posts: 73

reading a formatted spreadsheet

I'm working on a program to read an excel spreadsheet.

There is one kicker to the spreadsheet.  They have added colors to the spreadsheet and also strikethroughs with different meanings.

How can I get the spreadsheet formatting into a sas dataset?

Valued Guide
Posts: 2,177

Re: reading a formatted spreadsheet

Posted in reply to wkossack_nspirehealth_com

sounds like a serious challenge

save the workbook in XML format and see how tags are structured to define and use the colors

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