471,357 Members | 1,094 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,357 software developers and data experts.

"Problems during load"

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.
Jul 21 '05 #1
2 4886
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.

Jul 21 '05 #2
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 ***
Oct 27 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by .Net Sports | last post: by
2 posts views Thread by Vincent | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.