現在、添付ファイルの取得した後の処理にてつまづいております。
Excelアプリケーションスコープを利用して、edgeにてアクセスしたURLのサイトから割引値の情報を取得しセルに書き込む処理を実施しましたが、下記のエラーが発生します。
参照先を読み込むように設定していない時に発生するエラーのようです。
保存したエクセルファイルの情報を読み込む処理を記載しましたが、Excelのファイルの読み込み処理が不適切なのでしょうか？
お忙しいところお手数をおかけしますがご教示いただけますか。
Object reference not set to an instance of an object
This error usually appears if any of your variable is not correct or does not contain value. I would suggest you to put message box before each activity to recheck on the value stored in each of the passing values. This will help you to focus more on the error occurring area.
Hey @yukka_88 San the following value and variable you are passing in the Excel application can you check the like before write that variable in the excel activity pass this value in Log message and check what output you are getting.Because as per my understanding This value you are passing Could be the problem . and better Run your project in Debug mode and use Log Message to better trace .
cheers
@sharazkm32 san
Hello.
Thank you for your advice.
I checked the variables you set and confirmed that “CourseEmails” and “RetrievedEmail” were “null.”
I would like to get the values of “CourseEmails” and “RetrievedEmail,” but while I was correcting the variable settings, I forgot how to correct them.
I have set variables for each of them.
In a case like this, could you please tell me how to correct the errors?
Main.xaml (34.5 KB)
@singh_sumit san
Hello.
Thank you for your advice.
I checked the variables you set and confirmed that “CourseEmails” and “RetrievedEmail” were “null.”
I would like to get the values of “CourseEmails” and “RetrievedEmail,” but while I was correcting the variable settings, I forgot how to correct them.
I have set variables for each of them.
In a case like this, could you please tell me how to correct the errors?
Main.xaml (34.5 KB)
Since you have given screenshots and I am not able to translate it
I could suggest one thing while assigning variables- Instead of creating and assigning some value in the output variables - Click Ctrl+K and create variable from the output field of each of the required activity. This will help to create the variables in the expected format
@yukka_88 San are you having issues with the variable type if yes create a new variable using ctrl+k in the property panel of which ever activity you want to create . And or you asking something else .
