StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>An Excel Web Query (iqy) is just not going to work. Its only purpose is to define a "web query" for Excel to open.</p> <p>First frustration, I am not positive, but digitally signing the workbook may avoid the blocked data connection prompt. Also, if I remember correctly, there is a Global Policy setting for this, so if you are part of a domain, you can have this setting changed when the user logs into the domain.</p> <p>Second frustration. Not much you can do here.</p> <p>Suggestions, all kinds. We would need to understand your requirements and constraints. But, I suggest you dynamically create the workbook using XMLSS. You have full control over formatting, layout, and nearly everything else, without the need to have Excel installed on the server. The served workbook must then be saved locally and cannot be saved back to server.</p> <p>See <em>XML Spreadsheet Reference</em> at <a href="http://msdn.microsoft.com/en-us/library/aa140066(office.10).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa140066(office.10).aspx</a></p> <p>Here is a search for "visual basic asp xml workbooks site:microsoft.com", <a href="http://www.bing.com/search?q=visual+basic+asp+xml+workbooks+site%3Amicrosoft.com" rel="nofollow noreferrer">http://www.bing.com/search?q=visual+basic+asp+xml+workbooks+site%3Amicrosoft.com</a>. Search for ASP generates more results. Note it is easy to translate/migrate to ASP.NET so do not let the ASP throw you.</p> <p>I recommend starting with <em>Using Visual Basic and ASP with XML to Generate Excel 2003 Workbooks</em> at <a href="http://msdn.microsoft.com/en-us/library/aa203722(office.11).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa203722(office.11).aspx</a>, especially near the end of the article because there is an example on creating a workbook and setting the page print orientation. Moreover, there is an example on how to create a template.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload