dotnet distributed apps: Hi,

I have set up a web page which allows users to query a
database, and if they wish to keep/manipulate the results
in Excel, I have included a button which fires off the
same page in Excel. This works just fine, but I find that
there seems to be a size limitation on the grid which can
be shown in Excel (maximum number of rows seems to be
about 50). I'd like to know if this limitation has been
seen by anyone else, as well as to find out if there is a
way around it. The Excel sheet produced is just an aspx
page with a DataGrid, with a Response.ContentType
= "application/vnd.ms-excel" statement at the top. I never
had this size limitation with my asp classic
implementation of the same thing, where instead of a
datagrid it was just a Response.write produced table.

Thanks for any insight anyone has,

Hi Paul,

I haven't found the limitation yet. Before you send the string to Response,
I suggest you can save the whole content to a XML file and check if there
is any incorrect setting in it. For example, I use following content and it
worked:

<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">

<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>9225</WindowHeight>
<WindowWidth>14940</WindowWidth>
<WindowTopX>240</WindowTopX>
<WindowTopY>90</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Center"/>
<Borders/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
</Styles>
<Worksheet ss:Name="Sheet1">
<Table ss:ExpandedColumnCount="1"
ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">
<Row>
<Cell><Data ss:Type="Number">1</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">2</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">3</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">4</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">5</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">6</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">7</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">8</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">9</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">10</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">11</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">12</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">13</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">14</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">15</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">16</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">17</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">18</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">19</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">20</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">21</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">22</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">23</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">24</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">25</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">26</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">27</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">28</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">29</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">30</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">31</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">32</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">33</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">34</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">35</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">36</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">37</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">38</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">39</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">40</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">41</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">42</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">43</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">44</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">45</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">46</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">47</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">48</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">49</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">50</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">51</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">52</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">53</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">54</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">55</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">56</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>9</ActiveRow>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>

</Workbook>