# Read Range: Value cannot be null. (Parameter 'Workbook') **URL:** \ **Category:** Community\ **Tags:** community, question, microsoft-office365, excel, forum, activities\ **Created:** [November 28, 2022, 8:55am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180 "2022-11-28T08:55:45Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 8:55am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/1 "2022-11-28T08:55:45Z")
Hello guys i have automation using office 365 scope activity and inside that scope i have a find files and folders. And then i want to read excel on that specific folder but it give me error like this Read Range: Value cannot be null. (Parameter ‘Workbook’) What it does mean? \*PS I have a value in that xlsx file ![image](https://global.discourse-cdn.com/uipath/original/4X/1/e/8/1e87fe2869442c7963cea38855712be6085b98b4.png) ---
**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\ **Post date:** [November 28, 2022, 8:57am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/2 "2022-11-28T08:57:05Z")
Hi @Kelvin1 Can you show the properties of read range please Did you provide a input range ? And is your find files returning a file or folder? Cheers ---
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 8:59am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/3 "2022-11-28T08:59:39Z")
Hi @Anil_G here is my properties of my read range ![image](https://global.discourse-cdn.com/uipath/original/4X/7/2/1/721ca9d3f1488c311b0b58f718122e77e80a2edb.png) I didnt provide a input range, is it matter ? my find files returning a file ---
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 9:00am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/4 "2022-11-28T09:00:32Z")
I tried to provide the range but its still giving me error like that ---
**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\ **Post date:** [November 28, 2022, 9:01am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/5 "2022-11-28T09:01:53Z")
Hi @Kelvin1 Can you print what is there in output and check i beleive that ia not having the required information Cheers ---
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 9:02am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/6 "2022-11-28T09:02:57Z")
@Anil_G Which output did you mean? i cant do read range, how can i print the output? ---
**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\ **Post date:** [November 28, 2022, 9:08am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/7 "2022-11-28T09:08:49Z")
Hi @Kelvin1 I see you are using a variable output which I believe is the output from Find files for first occurrence. Can you check if that is retrieving the correct file In log message try giving output.Name or output.WebUrl to check if it is getting the correct file or not cheers ---
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 9:14am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/8 "2022-11-28T09:14:08Z")
Hi @Anil_G i tried it , its give me error like this now Log Message: Object reference not set to an instance of an object. ---
**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\ **Post date:** [November 28, 2022, 9:17am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/9 "2022-11-28T09:17:54Z")
Hi @Kelvin1 That means you are not getting anything from file files…your find files is not retrieving any data. You gave to first correct that. Please check the query and sub folder properties in find files Cheers ---
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 9:18am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/10 "2022-11-28T09:18:13Z")
I dont know why the system read the variable is null. When i start using the find files and folder i was uploading the file using upload file activity with that variable as a destination ---
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 9:21am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/11 "2022-11-28T09:21:34Z")
@Anil_G Before that i already use that same find files and i did some upload file. Everythings goes smoothly, but idk why it giving me error now ---
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 9:22am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/12 "2022-11-28T09:22:02Z")
@Anil_G even now i can did upload another file, do u know why this issue occur? ---
**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\ **Post date:** [November 28, 2022, 9:22am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/13 "2022-11-28T09:22:15Z")
Hi @Kelvin1 Try giving the variable in Result field(variable1) and do variable1.count to know if find files is retrieving any files or not. Clearly your output variable is empty so find files is not giving any data. Check the properties to get the correct details ![image](https://global.discourse-cdn.com/uipath/original/4X/1/3/1/131d4ba7e2304307642467196155375377419135.png) else please give a screenshot here of sharepoint and the properties of find files cheers ---
**Author:** ![Kelvin1](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/kelvin1/32/264590_2.png) [@Kelvin1](https://forum.uipath.com/u/Kelvin1)\ **Post date:** [November 28, 2022, 9:25am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/14 "2022-11-28T09:25:44Z")
Hi @Anil_G ah i see, i already solved the problem. There is an issue in sub folder in find files and folder ---
**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\ **Post date:** [December 1, 2022, 9:26am UTC](https://forum.uipath.com/t/read-range-value-cannot-be-null-parameter-workbook/494180/15 "2022-12-01T09:26:28Z")
Closed on December 1, 2022, 9:26am UTC This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.