The question is: What tells you in the Excel sheet what's header, what's body and what's footnote? Excel has simply columns and rows. You would need to implement some kind of logic to identify the header/footer section. I've had to do stuff like this in the past and it's ugly. My solution was to first convert the Excel to a csv and then implement some logic which determined if this was header or data section. In my case I needed to read only the data section into a SAS table, in your case you would then convert the text file to a html. In the Excel sheet structur you show us a Proc Import with enough "guessingrow" would do as there will be at least one row (the column headings) with character values so all variables would be "character". Once you have the data in a SAS table you need to find logic to split it up into header, data and footer section and then write the data as you wish to a html. If you have PC File Server then you could simply define a libname for your Excel workbook and by querying the sashelp.vstable it shouldn't be hard to get all the names of the sheets in this workbook. May be the libname would already convert the Excel sheets into a format sufficient for further processing. I've made mixed experiences and it was always "try and error" for me.
... View more
