When I am using an Excel connector to replace records in a lookup table I am able to access the data but when I am deploying the code and the users run the same application they are getting error because the file is not present at their machine in that particular location. However I am able to deploy the file in deployment folder of user's machine also but before the file gets copied to required location it is giving error as "Error Initializing Design Component".
Is there any way to use excel file in user's machine also so that they can access it from a particular location?
@AdityaT3054 If you want to include the file as part of the deployment package, then you can add it to your project like any other item via the "Add Existing item" option.
Here is a sample solution where it opens a file included with the deployment package. I am using a text file since Notepad is faster than Excel, but you could swap the file for an Excel file and the StartNotepad automation for the Excel Connector. I used the static method GetProjectPath to get me the location of the project DLL. I then used a FileUtils component and its GetDirectoryName method to get the path to this folder (versus the actual DLL). I then used the FileUtils' CombinePaths method to create a full path to the file I am interested in. Finally, I pass this to whatever needs that path.
If this isn't what you are looking for, then perhaps you can provide a little more detail. I don't really understand what you mean by deploy to a users folder and why that would cause any deserialization errors. For that, I would need to see your solution and a RuntimeLog.