Kindly answer the following : I am trying to pull a table(financial data) from the following website into Googlesheets: https://www.moneycontrol.com/financials/relianceindustries/balance-sheetVI/RI#RI . Website is given for illustration
In the above webpage, we can select various options of financial data (Balance Sheet, Profit Loss Statement etc.). On choosing an option (say Profit loss statement) and pressing the Go button for “Print/Copy to Excel” the following webpage displays : https://www.moneycontrol.com/stocks/company_info/print_main.php The second website has remark that “The data can be copied and pasted into an MS-Excel sheet”. But I am not able to pull the data from the .php webpage directly into Google Sheets I am using the IMPORTHTML but I am getting error using =IMPORTHTML(“https://www.moneycontrol.com/stocks/company_info/print_main.php”,”table”,2).
Also, the the financial data (say Profit loss statement) in the webpage: moneycontrol.com/stocks/company_info/print_main.php which has a remark that “The data can be copied and pasted into an MS-Excel sheet” . While the data in a table format can be directly copied and pasted into an MS-Excel sheet, it is not showing up as a table while I am trying to import the data from the web directly into MS-Excel using Power Query. Please solve this issue and also provide a code how import the data from .php webpage directly into Google Sheets