Active Member
March 11, 2024
Hello All,
I have developed a VB.Net app that adds some information to the Excel sheet and inserts existing images into Excel cell.
Everything works fine on my development PC.
But on the Client's PC, the data is added to the Excel file. However, images are not getting inserted.
What could be the possible reason? How can I resolve this problem?
Please let me if you need more info.
I am using Sheet.Shapes.AddPicture method to insert the .jpeg images.
Thanks for any help.
Trusted Members
Moderators
November 1, 2018
Trusted Members
Moderators
November 1, 2018
April 25, 2020
If the images are stored in a folder on the PC on which the code works, then, sure the code can find and insert the images.
If, however, another PC does not have access to the image folder then the code will fail on that PC.
You need to either send the image folder to all PCs on which you want to run the code, or, better method, would be to have the image folder on a shared drive such as OneDrive or SharePoint.
Active Member
March 11, 2024
1. As I have explained, on the client PC images are not getting inserted into the sheet cells. I have also mentioned the method I am using.
2. The Folder is created by the program in the same location that data file is and images are created and stored in that folder by the program. So, there no sharing needed.
3. I have been investigating about permissions and similar issues. But this does not seem to be the issue.
Perhaps I am very close to locating the problem.
Once confirmed I will post the problem and soln. here.
Trusted Members
October 17, 2018
If you have actually read what others have answered then you will hopefully undestand why the images are not loaded on the different systems.
It has nothing to do with permissions or whatever, it has all to do with the simple fact that the folder with the images is not there for the the other people.
October 5, 2010
Hi Nirantar,
How is your code accessing the folder where the images are stored?
Are you using environment variables from the PC? Is the path hardcoded?
What debugging have you done?
Is your code generating an error when it tries to locate/load an image? Or is it failing silently?
Is the folder with the images actually created on the target PC when your app is installed?
You should have some error handling in the code to communicate why an image can't be located.
I can't think of much more to say. I would have thought that debugging this would be fairly straightforward if you consider the things I've just listed.
Regards
Phil
1 Guest(s)