How to fix corrupted imported online excel in google sheet

0 votes

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?

Nov 26, 2022 in Others by Kithuzzz
• 27,360 points
64 views

1 answer to this question.

0 votes

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.
answered Nov 26, 2022 by narikkadan
• 50,440 points

Related Questions In Others

+1 vote
1 answer

How to use VBA in Excel for Google Search?

Try this: Private Const LicenseRegistration As String = ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 50,440 points
312 views
0 votes
1 answer

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 50,440 points
1,113 views
0 votes
0 answers

Data Driven Framework -- how to read and write in excel sheet using Selenium WebDriver with java

I'm using this code to read something, ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 27,360 points
105 views
0 votes
1 answer

How to fix a circular reference error by if condition in excel file?

Circular reference in this context refers to ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 50,440 points
81 views
0 votes
1 answer

Format Data to tabular structure in Excel - Power m Query - Excel

Hi, @Kiranbvsn You can check this out: https://www.howtoexcel.org/ ...READ MORE

answered Oct 27, 2020 in Power BI by Gitika
• 65,910 points
274 views
0 votes
0 answers

How to get AUD price of bitcoin at a particular date

I am trying to find out how ...READ MORE

Mar 1, 2022 in Blockchain by Soham
• 9,700 points
130 views
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 50,440 points
143 views
0 votes
1 answer

How to split text values by a delimiter?

The Split function is what you are looking for: =Split(A1, ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 50,440 points
142 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 50,440 points
220 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP