we have given the parameters correct only and checked in imediate panel as well, but still bot is failing - so any help would be greatful
@Sathish_Kumar5 Is it working when you try to hard code values?
Redacting the most important information does not help someone trying to help you.
Check if your Excel sheet name is correct.
Since the values are coming correctly in the Immediate panel, it looks like the issue may not be with the parameters directly, but with how the Excel range is being resolved at runtime.
In the Insert Rows activity, please check whether the sheet name passed in Excel.Sheet(…) exactly matches the actual Excel sheet name. Sometimes even an extra space or different sheet name can cause this “The range does not exist” error.
Also, please validate the row number value before the activity. The row index should be a valid number and should not be blank, 0, negative, or outside the available Excel range.
As a quick check, try hardcoding the sheet name and row number once, for example:
Excel.Sheet(“MasterData”)
Row number = 2
Number of rows = 1
If it works with hardcoded values, then the issue is most likely with one of the dynamic/config values passed at runtime.
This would not work if the sheet has filters first
next try with hardcoded values to first check and validate
and use log message and use excel.sheet(“Sheetname”).FullRangeName this ensures you verify if the sheet is being read properly for full range or not
cheers
Can you check what the value coming for Row number field? if it not a valid and then try to change.
And also check the columns as well is there any extra columns are you getting.
Its not working with hardcoded values
sheet name is correct
yes first value is postivie , sheetname has no space, i have hardcoded every detail still facing the issue
Yes removed the filters, tried with hardcoded, log message - ‘Sheet1 data’!A:XFD
yes tried it no use in it, no duplicate columns as well
Okay then try below trails,
Close your all opened excel files, if opened by the process then ensure that is not in read only mode.
instead of the variables try pass direct values in sheetname, range and number of rows.
Try these methods if it with hardcoded then you are getting issue input data that you are passing as variables.
I tried with your use case, for me it inserting the rows, find the below screenshot
Hope it helps
Fullrange looks like the issue as you should be getting only the columns where data is present and the row like sheet!A2:D25 like this
for now just try to give rtange as well in input and check if that works
cheers
as mentioned you need to delete the rows
I see why ou have rows may be for formatting you can have single row and insert should trigger formatting as well and remove formatting for columsn where it is not needed else who is considered as range
Alternately if its something that you are preparing define as table then can use table name which will get the table as well
cheers
This error usually happens when the Excel range or row reference becomes invalid during runtime, even if the values look correct in Immediate panel. Most of the time it’s because the sheet/table name is slightly different, the calculated row number is empty or out of range, or the workbook changes before the Insert Rows activity runs. Try testing once with a fixed row number and re-indicate the sheet/range to confirm the issue.
Check the sheet name and range, then test hardcoded values.