Hello, in Errors and exception handling in studio, practise 1. Im always having this error at the end (see picture) even though i have downloaded the excel sheet and the name in the excel sheet is named CashFlow. Can someone help me understand what im doing wrong ?
Could you please show the read range activity what you have configured in activity? might be sheet name is different
Hi @hlina23 Can you check the in excel file Sheet name and also make sure you are passing correct sheetname? could you please share the excel file let me try and send you the xaml?
why you are passing variable in excel path can you show me the variables for sheet name and workbook path?
Can you go the file where it is and right click copy as path and pass that value in default value or directly in excel activity or try with Workbook activity instead of excel application scope if you are using excel application scope excel should be installed on your machine try with workbook read range activity?
Atatched screenshot for your reference
Hello @hlina23 place your excel file in your directory where main.xaml exist and try passing the sheet name as hardcoded like by copy the sheet name from excel and check if there is any space exist in excel sheet name try adding hardcoded.
Cheers
Welcome to the community
- Is the excel file you are using in same folder as main.xaml? or are you referring to same file as mentioned in error?
- in excel activities you can select file and sheet..just to make sure click on the push in read range where to write field and it should display the sheetnames if it does not either you are connected to different excel or sheet is protected
cheers