Stack Overflow
Stack Overflow

Questions tagged [excel-web-query]

Excel Web Query, Internet Inquiry (IQY) - A Web query is a feature in Excel that allows you to retrieve data stored on an intranet, the Internet, or the World Wide Web.

A Web query is a feature in Excel that allows you to retrieve data stored on an intranet, the Internet, or the World Wide Web. A Web query can use static parameters, dynamic parameters, or a combination of both. Queries with static parameters send a query without any input by the user; queries with dynamic parameters prompt you for input. Regardless of the type of parameters in the query, the requested information is pulled from an Internet or intranet site, and the results are placed in a worksheet.

113 questions
1
vote
1 answer

VBA If comparison TR\TD Elements

I have a web query to a table that gives me a table like this : [C] [D] [E] [A] Events | IP source | IP destination | [B] MyEvent (1.10) | 192.168.0.1 | 192.168.0.3 | the Html Code that gives me…
PythonNewbie
  • 228
  • 1
  • 4
  • 12
1
vote
1 answer

Excel IQY file - Usage Option question

I have a simple Excel IQY file in which the contents look like…
sugarcrum
  • 1,001
  • 4
  • 13
  • 19
1
vote
0 answers

Excel Web Query references break when saving worksheet

When I modify an existing Excel workbook containing web queries, any new web queries I add will work fine until I save and reopen the document. When I reopen, suddenly all tables return the same data because (somehow) the query parameter for the new…
jonaz
  • 2,096
  • 1
  • 17
  • 30
0
votes
1 answer

How to find RowCount of a table which pasted from web to excel

im recieving a table from web in excel with the code below With ActiveSheet.QueryTables.Add(Connection:= _ "URL;some url") .WebSelectionType = "xlSpecifiedTables" .WebTables = "10" .BackgroundQuery = True .TablesOnlyFromHTML =…
Berker Yüceer
  • 7,026
  • 18
  • 68
  • 102
0
votes
0 answers

VBA code to update connections (query) and pivot tables in excel in order and not simultaneously

is there a way to execute code in VBA line by line and not simultaneously? I'm very new to VBA, I'm a very basic user but I need it to automate some task at work. Basically, I need to write a code that: update web queries (I have sheets containing…
nardoman
  • 1
  • 1
0
votes
1 answer

Web Query missing css elements in the table

I using a web query on the NCSL Excuse Absentee Voting Table (https://www.ncsl.org/elections-and-campaigns/table-2-excuses-to-vote-absentee). The table uses this element to mark cells that I would like to show as true:
    …
VivM
  • 1
0
votes
1 answer

Detect Cell Modified or Update in Web Browser Excel

I have an Excel located in SharePoint Online Library. I tried using Intersect to detect any change or update in Column A, Column B will be updated to the month value of the change or update made in respective Column A. It works well in Microsoft…
James
  • 33
  • 6
0
votes
0 answers

How to ask for credentials when user tries to refresh a web query in C#

I am currently using DocumentFormat.OpenXml.Spreadsheet to generate an excel file. I also added a web query to it. I now want to authenticate the user. So on click of refresh in excel, I want to request for username and password and then…
Deepti
  • 1
0
votes
0 answers

iqy file - selection section

I have the following iqy file: https://foo.bar.com?sid=["sid"] Selection=1 Formatting=None when I try to import it it asks for the sid parameter which is stored in another sheet. so far so good. But I don't understand which parameter I have to…
laloune
  • 548
  • 1
  • 9
  • 26
0
votes
0 answers

Correct data not getting imported in Excel by using Webquery

I am trying to pull a table(financial data) from the following website into Excel using the following link: https://www.moneycontrol.com/financials/relianceindustries/profit-lossVI/RI The link can be accessed directly In this webpage there is an…
Debashish Datta
  • 1
  • 1
0
votes
1 answer

Excel power query gives DataSource.Error web.content failed to get content from api url (404):Not Found

My excel uses data from an api url, I run the query every 10 mins, but if the api has a lot of traffic and returns a 404 error, I get a pop up error "DataSource.Error web.content failed to get content from api url (404);Not Found" and the whole…
Searthy
  • 1
  • 2
0
votes
1 answer

Excel VBA: Looped Web Queries

I have a list of 100,000 URLs that I need to parse via an API call. I've sorted them into a list of 600+ concatenated strings, each containing 200 URLs - ready to be parsed. I've written the code below to loop the process, places the returned…
Kurt
  • 221
  • 2
  • 7
  • 19
0
votes
2 answers

Excel on Mac. Cannot open IQY file in Data/Get External Data/Run Web Query

I am running Excel version 16.45 on Mac. I have created a .iqy and saved it in the Queries directory alongside certain templates which were already there. I go to Data/Get External Data/Run Web Queries. While the templates are accessible, my file is…
Diego Parascandolo
  • 1
  • 3
0
votes
1 answer

Excel Web Query

I use the web query tool to import a table in the spreadsheet. Given I wanted to query the site several time, I recorded a macro to get the web query into VBA format and then use it in a loop to download the table I need. By doing so I noticed that…
Marco_sbt
  • 309
  • 1
  • 12
0
votes
2 answers

Last Zeros Truncated When Getting External Data

While importing data from the web in Excel 2019 choosing Data>Get Data>From Other Sources>From Web, the last (trailing) zeros of numbers are being truncated resulting in the following 'Import' column: EU Import | Desired 968,8 | 968800 891,01 | …
VBasic2008
  • 44,888
  • 5
  • 17
  • 28
1 2 3
4
5 6 7 8