06-10-2014 07:19 AM
We are using PROC IMPORT for Excel and reading excel formulas as cell value. As far as we have a numeric return value as a result of this formula then getting right results in our data set. But the problem is when we have text value as a result of this formula then not recieving the result text. It seams Proc Import for excel formula function only if the return value is numeric.
How to solve this problem for getting the text values as a result of excel formula? or it is not possible?
A1 has formula =F2
A2 has formula =F3
F2 has value 1234
F3 has value ABC
When we run proc import then getting the following results:
Correct: A1 = 1234
Wrong: A2 = here come nothing or some strange text???
Any help would be greatly appreciated.
06-10-2014 08:40 AM
It works for me.
Please attach the log, with your code.
proc import dbms=excel file='C:\temp\test formler.xlsx' out=test;
06-10-2014 09:23 AM
Thanks for quick responses.
Please apply it with different excel sheets. It means if you execute same proc import again for another excel sheet with different values then you will not get the new values for new sheet. It returns only the value which read first time.
06-10-2014 09:44 AM
Excel file name is myfile.xlsx and sheet name is firstsheet.
This runs fine and return the correct values from sheet=firstsheet.
Excel file name is same myfile.xlsx and sheet name is secondsheet.
Now if you create another sheet=secondsheet; change the excel entries in this sheet and run the following for secondsheet. you will not get the result of secondsheet. It will still show you the result of firstsheet.
I hope you will understand the problem now.