"Problems during load"

[Vincent]

I am trying to generate Excel worksheets using .Net. The worksheets
are actually HTML pages with Excel specific XML elements. Everything
works fine until I added these following code in the template I'm
generating:

<x:ExcelName>
<x:Name>Print_Titles</x:Name>
<x:SheetIndex>1</x:SheetIndex>
<x:Formula>='Initiative Status Report'!$4:$5</x:Formula>
</x:ExcelName>

If I add these lines to my ASPX page, Excel will give me an error
message with the heading "Problems during load" and the message "Excel
Name". If I click "Ok", the file loads up fine and everything is
display. Can someone please tell me how to fix this problem? Thank
you very much.

[Nick Hodge]

Vincent

Long shot but Page_Titles is a sheet level name not a workbook level name,
so it may need qualifying

Sheet1!Print_Titles

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
ni*******************@zen.co.uk.ANDTHIS
"Vincent" <om*********@gmail.com> wrote in message
news:5c**************************@posting.google.c om...

I am trying to generate Excel worksheets using .Net. The worksheets
are actually HTML pages with Excel specific XML elements. Everything
works fine until I added these following code in the template I'm
generating:

<x:ExcelName>
<x:Name>Print_Titles</x:Name>
<x:SheetIndex>1</x:SheetIndex>
<x:Formula>='Initiative Status Report'!$4:$5</x:Formula>
</x:ExcelName>

If I add these lines to my ASPX page, Excel will give me an error
message with the heading "Problems during load" and the message "Excel
Name". If I click "Ok", the file loads up fine and everything is
display. Can someone please tell me how to fix this problem? Thank
you very much.

[vincent lin]

Sorry for the late reply. Better late than never, right? :)
I found out through experimentation that you can't have more than one
table in the HTML if you try to have title rows.
This means you can't use Datagrid for your excel generating ASPX. I
used Repeater instead. I found that you have much greater control with
Repeater. I can apply all kinds of formating to individual cells,
things I can't do with Datagrids
Hope it helps.

*** Sent via Developersdex http://www.developersdex.com ***