Proc Import excel that is html

[Reeza]

@paul2877 Still a no go, files won't open in Excel and if I change the extension to HTML there's no HTML so that approach won't work. 

Please test your files before uploading. You should be able to open it with Excel and if you change the extension to HTML I'd expect to see HTML if I open it in a text editor rather than gibberish. Please also include a screenshot of what the file should look like so that we can ensure it's opening correctly because at this point I'm not sure I'd trust what I'd see.

[paul2877]

do you have any other options to be able to upload a file of this sort without seeing it?

[Reeza]

---

@paul2877 wrote:

do you have any other options to be able to upload a file of this sort without seeing it?

---

I'm not sure what you mean? You can upload the file to a public dropbox type if you think you're having issues  with the forum, but in general, there's no way we can help with your problem without a sample file. 

You can attempt to read the file as HTML/text and see what you get I suppose. Most likely a lot of text, but perhaps you can figure out how to parse that. There are the HTMLDECODE functions to help with some of that. Good Luck.

data test;
length x $32000;
infile 'path to xls file' lrecl=32000;
input;
x=_infile_;
run;

[ChrisHemedinger]

I do not think that attached file represents a complete file.  It's missing the data sheets (Sheet001.htm) referenced inside of it.

Oh, but that second on (samplefile2.xls) has some data I see.