Empty Database when importing from Excel with SAP Analysis

[Paul Shlapa]

Dear Experts,

I have recently run into an issue of importing the data from an Excel File, which was filled with data that was compiled using SAP Analysis.

If one opens an Excel File, the data is visible, but Stata is somehow unable to recognize it and loads an empty file.

Has anyone run into that issue, is there a workaround?

Sincerely,

Pavlo

[Clyde Schechter]

As you do not show the command(s) you used for the importation, it is hard to know what you might have done wrong. My immediate observation is that the data does not begin in cell A1, but in B4. Also, from what you show, I cannot tell which sheet in the workbook you asked Stata to import. Anyway, I suggest double-checking that you have specified both the -cellrange()- and -sheet()- options in your -import excel- command correctly.

[Paul Shlapa]

Clyde Schechter Thank you Clyde, indeed i did not specify the sheet name, although stata seems not to have a promlem with that and always imported the first sheet, i think (not sure). Anyways, after sheetname specification the problem is being solved.