Good afternoon, I have a web query in Excel 2002 going against a web page that returns a date column. The dates are returned as DD/MM/YYYY, as I would like to show them in my spreadsheet. My machine running Excel has its regional settings set to en-GB, and the only language set under Internet Options is UK English. Nevertheless, the ...
I have a simple Excel IQY file in which the contents look like this: WEB 1 http://somesite.html Selection=EntirePage Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False DisableDateRecognition=False DisableRedirections=False This is simple, no problems. What I need to do is add o...
I'm trying to implement a page that allows Excel users to use the data it provides via the Web Query feature provided by Excel. It's all working out pretty nicely, as long as I use HTTP (even BASIC user authentication works). As soon as I switch that over to HTTPS Excel won't download the data anymore (it's even a fully official SSL ce...
I need to pull data from a table on a website. I can easily do this in VBA using the Web Query, but I need to do this in C#. I'm just having some trouble figuring out how to properly convert the code. I got something close, but it's returning HTML with the data. I just want the data. Any help would be great. The block of code givin...