Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query Formatting rows - columns.
I'm having a problem where I have a web query looking at an XML file.
When it spits it into the spreadsheet, its formatted in rows. The problem is, it doesn't have enough space to spit out the whole feed. I need it to be formatted into columns. It needs to do this autonomously while its getting the data for the web query... Any advice? Thanks, Jon Schwartz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query Formatting rows - columns.
Jon,
Not sure I understand; if there are more than 65K rows, it will not fit in 256 columns (assuming not XL2007. At a guess, look at AutoFit and/or TextToColumns. Otherwise, explain what you mean by "it doesn't have enough space to spit out the whole feed". NickHK wrote in message oups.com... I'm having a problem where I have a web query looking at an XML file. When it spits it into the spreadsheet, its formatted in rows. The problem is, it doesn't have enough space to spit out the whole feed. I need it to be formatted into columns. It needs to do this autonomously while its getting the data for the web query... Any advice? Thanks, Jon Schwartz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for formatting rows and columns minimizing the outcome. | Excel Discussion (Misc queries) | |||
Query to delete rows or columns | Excel Discussion (Misc queries) | |||
Table rows & columns query | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Conditional Formatting to Hide Rows or Columns? | Excel Discussion (Misc queries) |