How to fix corrupted imported online excel in google sheet

Question

I need this online excel: https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx?d=0  in my google sheet but when I use the Importdata formula as below: Importdata("https://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx?d=0")

it turns out to be imported in a corrupted way like this: enter image description here but the original online file is this: enter image description here

How Can I fix it?

Answer 1

Issue and workaround:

In the built-in functions for Google Spreadsheet, it appears that there is currently no way to directly retrieve the data from the XLSX data of the URL. I'd like to suggest using Google Apps Script to accomplish your goal in this response. Your objective can be accomplished when Google Apps Script is deployed.

The flow of the sample script is as follows.

1. Retrieve XLSX data.
2. Convert XLSX data to Google Spreadsheet as the temporal Spreadsheet.
3. Retrieve values from the converted Spreadsheet.
4. Put the values from the converted Spreadsheet to the active sheet.
5. Remove the temporal Spreadsheet.