Hi ,
I have requirement to read from excel file (XLSM) only the values in the excel sheets. If I use the Read Excel Plugin I can read the functions or formula used in rows and columns but not actual value . Is there any option to read the values instead of associated functions or formula. I have also tried with excel interface functions but didn't work .
Thanks in advance
Akash
Discussion posts and replies are publicly visible
This means, you want to read the results of all the formulas? AFAIK there is nothing available.
If i understood correctly, you want to read cell values from excel file.
If yes, can you try this function readexcelsheet()
Hi Akash,
when I use the Read Excel Plugin, I see the value that is being returned by the formula. I tested this with sum() on an Excel file that I saved as *.xlsm. So this works, in principle.
Can you give us some more insight into when and with which formulae the error occurs? It might well be something that is difficult to replicate in testing, depending on how the macro functionalities of Excel are used in your sheet.
Cheers
I also checked that it works with sum(). But it doesn't work with concat(), Sheet(), transpose(). I have used all this in excel file having multiple sheets.
I tried to read the excel with readexcelsheet() function on an interface and getting error "Error evaluating cell Sheet1!CellNo."
please suggest some alternative if available.