Without correct dependencies and the source library the forum cannot test your Main.xaml
We cant confirm what excel workbook/sheet should both these workflow use. A your library nuget and a sample excel workbook could help resolve this issue faster.
As per the error : “ReadConfig: Column ‘L_Name’ does not belong to table DataTable.”
Your library / ReadConfig.xaml and Main.xaml are hardcoded to look for F_Name and L_Name columns in input excel workbook/sheet? Remember if those excel sheets you are using as inputs have header with spaces F_Name OR L_Name you can also get this error.
I tested with your package and the ReadConfig.xaml. I think the error resides in the C# code.
As you noted, both read range does the job as expected. I think you have to confirm within C# if the code read the contents of the whole Sheet1 or not. C# activity has read F_Name as a column.
As this activity is not sensitive information, you could also share the C# code of your activity.cs.
Also attached the file where I am executing the same standalone program and it is giving result whereas when I am calling it using library, it is not able to find the column. ReadConfigTest.xaml (9.4 KB)
When I said activity.cs I meant the name of the activity you developed in C# not exactly activity.cs.
The custom library was developed in C# right? From your custom library package i see your activity in C# is named as ReadConfig.cs.
In ReadConfig.cs you have to find where the input excel file path is being read and if it is read in the correct manner.
Your ReadConfig.cs activity takes 2 inputs ConfigFileName as string and ConfigSheetName as string. Without looking at the source code, I dont think anyone else can help you fix the issue. As I said before, the error source is in the custom library (the TestPackage.1.0.9.nupkg)
Can you try to set “” or “A1” at Range property of Read Range Activity in ReadConfig,xaml?
For some reason, it seems blank doesn’t work in library properly. (It might be a bug…)