use Google Apps Script to save/export Google Sheet as XLS Excel but preserve images

Solution for use Google Apps Script to save/export Google Sheet as XLS Excel but preserve images
is Given Below:

I’ve got a Google Sheet that has product info, including links to images for each item that’s saved to our Google Drive.

Here’s a sample Sheet.

The images are also shown on the Google Sheet. This allows people to see the items when they’re using the Sheet, and also they can print to PDF or whatever.

If it matters, the way we’re showing the images is by using GS’s “Image” function with a link to the file.

However, some people have use cases where they want to export/save this info to an Excel file, but they still want the images shown.

Is there any way to do this with Google Apps Script or any other method? I’ve already done some research and couldn’t find a lot of info on this.

I understand what is going on now. I tested your file in an online excel viewer. The issue you are having is that your images are not pasted into the Google sheet. They are being fetched from Google Drive using the URL of the image in Drive and the formula:IMAGE(URL). Excel does not have that IMAGE formula. So it gives you #NAME? error,because it can’t understand the formula.

I reccommend you go through this answer for how to replicate the IMAGE() function from Google Sheets in Excel.