topic reading a formatted spreadsheet in SAS Programming https://communities.sas.com/t5/SAS-Programming/reading-a-formatted-spreadsheet/m-p/129034#M26349 <HTML><HEAD></HEAD><BODY><P>I'm working on a program to read an excel spreadsheet.</P><P></P><P>There is one kicker to the spreadsheet.&nbsp; They have added colors to the spreadsheet and also strikethroughs with different meanings.</P><P>How can I get the spreadsheet formatting into a sas dataset?</P></BODY></HTML> Wed, 06 Mar 2013 18:58:44 GMT wkossack_nspirehealth_com 2013-03-06T18:58:44Z reading a formatted spreadsheet https://communities.sas.com/t5/SAS-Programming/reading-a-formatted-spreadsheet/m-p/129034#M26349 <HTML><HEAD></HEAD><BODY><P>I'm working on a program to read an excel spreadsheet.</P><P></P><P>There is one kicker to the spreadsheet.&nbsp; They have added colors to the spreadsheet and also strikethroughs with different meanings.</P><P>How can I get the spreadsheet formatting into a sas dataset?</P></BODY></HTML> Wed, 06 Mar 2013 18:58:44 GMT https://communities.sas.com/t5/SAS-Programming/reading-a-formatted-spreadsheet/m-p/129034#M26349 wkossack_nspirehealth_com 2013-03-06T18:58:44Z Re: reading a formatted spreadsheet https://communities.sas.com/t5/SAS-Programming/reading-a-formatted-spreadsheet/m-p/129035#M26350 <HTML><HEAD></HEAD><BODY><P>sounds like a serious challenge</P><P>save the workbook in XML format and see how tags are structured to define and use the colors</P></BODY></HTML> Wed, 06 Mar 2013 23:46:40 GMT https://communities.sas.com/t5/SAS-Programming/reading-a-formatted-spreadsheet/m-p/129035#M26350 Peter_C 2013-03-06T23:46:40Z