473,230 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 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 4977
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Prince Kumar | last post by:
When running LOAD with "ALLOW READ ACCESS", I get the following error if select is running againt the table (isolation UR). load.sql --------- db2 load from /u02/data/dly_d040817_test.dat of...
3
by: Arpi Jakab | last post by:
I have a main project that depends on projects A and B. The main project's additional include directories list is: ...\ProjectA\Dist\Include ...\ProjectB\Dist\Include Each of the include...
2
by: thorax | last post by:
I'm having problems running a release build of an application. The application is a native C++ .NET 2003 MFC application which links to a number of other DLLs, one of which is mixed (SLGSE.dll)...
0
by: jhonz | last post by:
I have come across a strange circumstance. I have user controls with dropdownlists that interact fine during times where the web server has minimal load. But once things pick up and postbacks...
0
by: .Net Sports | last post by:
I'm trying to build a datagrid project in vs.net, and getting an error that doesnt make sense: \\\\\\\\\\\\\\ Could not load type 'SportsMProject.btresults2a'. Source Error: Line 1: <%@...
2
by: Vincent | last post by:
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...
28
by: robert | last post by:
In very rare cases a program crashes (hard to reproduce) : * several threads work on an object tree with dict's etc. in it. Items are added, deleted, iteration over .keys() ... ). The threads are...
4
by: scottcly | last post by:
I have a simple editor with a Gridview and a DetailsView. The Gridview handles DELETE and the DetailsView handles UPDATE and ADD. A panel around each one and some minor event handling is used to...
2
by: contractsup | last post by:
Environment: $ uname -a AIX <withheld2 5 000100614C00 $ db2level DB21085I Instance "<withheld>" uses "32" bits and DB2 code release "SQL08024" with level identifier "03050106"....
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.