|
Hi, my name is Silvia Terzi. I want create an Excel file with n sheets.
I try to use this function:
Sub CreateExcel
Dim FileName As String
FileName = "test.xsl"
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition", "inline; ")
FileName = " & FileName "
Response.Write("<Worksheet ss:Name=""Sheet1"">")
Response.Write("<table>")
Response.Write("<tr>")
For i = 1 To 15 Step 3
Response.Write("<td>")
Response.Write(i * i)
Response.Write("</td>")
Next
Response.Write("<td width=40><b>=somma(A1:D1)</b></td>")
Response.Write("</tr>")
Response.Write("</table>")
Response.Write("</Worksheet>")
Response.Write("<Worksheet ss:Name=""Sheet2"">")
Response.Write("<table>")
Response.Write("<tr>")
For i = 1 To 15 Step 3
Response.Write("<td>")
Response.Write(i * i)
Response.Write("</td>")
Next
Response.Write("<td width=40><b>=somma(A1:D1)</b></td>")
Response.Write("</tr>")
Response.Write("</table>")
Response.Write("</Worksheet>")
Response.Flush()
Response.End()
End Sub
But it doesn't work.
It makes a file xls with only one sheet called like the file.
What I mistake?
Thanks,
Silvia
|
|
|
|
|
|
Why open excel without sheet????, makes no sense to me, even if i open excel directly he always shows a new sheet.
That's not possible and have no sense.
|
|
|
|
|
Not without, with N! With a lot of sheets!
|
|
|
|
|
Dear All,
I have performance issue in javascript
Html with about 30-50 form controls ,textbox ,radios...
I done javascript function to parse forms control ,get name and get the value and
added these values to xmlDocument
xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.async=true;
and append the the nodes
every thing works fine
i saved xmlDocument in xml file almost size 12-15 kb
I want to speed up the process using threads to add nodes in xmlDocument
I done search i want perfect library to use in my project??
Also
its work fast im my pc,
But I put page in windows server 2003 and access it from my pc
its tooooooooook allllott of time to done parsing html control,Imessure speed but alert before paring and alert after paring
Regards
Yes. CreatiVity withOuT limiTs
|
|
|
|
|
|
Hi,
Wanna learn ASP.NET and JavaScript?
Check out these links:
http://www.javascriptworkshop.com/category/online-classes/
|
|
|
|
|
HI,
i am using CR XI with VS 2008, from the crystal report web viewer the landscape report not print, however report options set to page = A4 and orientation = Landscape. when send this report from crystal report web viewer it always pint as Portrait and page size = Letter.
Is there any solution for that , i could print my report as landscape,
Regards
JUNAID.
|
|
|
|
|
Hi every one,
I have a problem with my content page i create a css file in my root directory. i give link to that css file in master page with the help of link tag.there is no link tag support in content page so how to set the style of the asp control's and html control's of the content page
please help me thanks in advance
|
|
|
|
|
|
Hi Folks:
I've done Google searches, looked for books on Amazon, looked up this topic here at this website and have more questions than answers.
Quite simply, I will have a webcam (Logitech 9000) installed on my Windows 2003 business server platform.
All I want to do is to be able to "receive" the live video stream from my camnera from a client browser over the net. I think I need some client HTML as well as some server code to do this?
Any help appreciated.
Steve
|
|
|
|
|
Do you want to stream video, or stills ? Video would come from a windows media player control, I am not sure how to set that up on a server, but I doubt it's hard. Stills is easy, a paget that auto updates and shows an image, and a server that overwrites the image with a new one every 5 seconds or something.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
Hi Christian,
I want to stream "real" time, live video. I plan to set up a webcam in front of an animatronic character. I will be able to control it's movements thru a browser over the net. I need to see "real" time my animatronic character as I press buttons on my webpage to make it move it's arm, open it's eyes, etc .....
Any idea's?
Steve
|
|
|
|
|
I'm sorry, no idea beyond what I said. If you google for windows media player, then read up on how to embedd one in a page ( easy ) and how to connect it to a stream it may lead you to info on how to create the stream. Getting a .NET app or C++ app to get your video stream is trivial, feeding it over the web is the bit I am unsure about ( that is, I've never done it )
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
Flash should be able to do the stuff you need - especially flash media server (but its expensive). Or, You can use flash for the video and the language of your choice for th interaction.
http://www.newgrounds.com/portal/view/326194
|
|
|
|
|
1AVStreamer streams audio and video from your webcam embedded in a page inside your own website. It is all automatic and very easy to setup. The PC Desktop, TV tuners and DV cameras are also supported. The program also broadcasts audio alone. if you dont want the audio you can stream your webcam via FTP. 1AVStreamer also does that.
I don't know about the coding but this ready-to-use software is cheap and will get you what you want.
You can find 1AVStreamer here:
http://www.pcwinsoft.com/1avstreamer/
Best,
Alex
|
|
|
|
|
Hi,
I want to develop one static website. Tell me the steps how to host a website.
I mean whom i need to contact.
Thanks and Regards
Dayakar
|
|
|
|
|
Get a service provider like manashosting.com. Register your domain and buy some space.
Place your files and get your website published.
Further Google it
You are best person who knows about your problem.
-------------------------------------------------
More pain more gain
|
|
|
|
|
Fulltext Search on localized Website
I need to provide fulltext search on a public website.
The Web is built upon several aspx sites and is localized (German/French)
using the standard MS-way. (local and global Ressource files)
All i can find starts where i have my web content in a database or in plain
text files, but i have no database content and my webpages are built per request
according to the clients ui language.
Is there some nifty little tool to save my entire website to disk,
so i can go further with some other tool or am i overlooking something?
I prefer to use standard MS technologies.
(Web Server is windows server 2003, SQL2005 available, all under my full control)
thanks in advance for any help
|
|
|
|
|
I was trying out the code given below, taken from a book, but it is not able to show contents of data.txt in the <div> specified.
<html>
<head>
<title>Gmail</title>
<script language="javascript">
var XMLHttpRequestObject = false;
if(window.XMLHttpRequest)
{
XMLHttpRequestObject = new XMLHttpRequest();
}
else if(window.ActiveXObject)
{
XMLHttpRequestObject = new ActiveXObject("Microsoft.XMLHTTP");
}
function getData(dataSource, divID)
{
if(XMLHttpRequestObject)
{
var obj = document.getElementById(divID);
XMLHttpRequestObject.open("GET", dataSource);
XMLHttpRequestObject.onreadystatechange = function()
{
if(XMLHttpRequestObject.readyState == 4 && XMLHttpRequestObject.status == 200)
{
obj.innerHTML = XMLHttpRequestObject.responseText;
}
}
XMLHttpRequetObject.send(null);
}
}
</script>
</head>
<body>
<form>
<input type="button" value="Fetch the message" onclick="getData('data.txt', 'targetDiv')">
</form>
<div id="targetDiv">
<p>Fetched message to appear here.</p>
</div>
</body>
</html>
The file, data.txt exists in the same directory as the file containing the code. Someone please tell me what could be wrong with the script.
Thanks
|
|
|
|
|
Is it giving any error?
himanshu
|
|
|
|
|
Uh, yeah...as I said above, the contents of the file data.txt are not displayed in the div with the id targetDiv. If by "giving error", you mean an error message of some sort, then you should probably go through some html docs first.
|
|
|
|
|
when I run this script I got an error like "unknown Object XMLHttpRequetObject" thats because of XMLHttpRequestObject is misspelled to XMLHttpRequetObject.
You are best person who knows about your problem.
-------------------------------------------------
More pain more gain
|
|
|
|
|
Yeah, thanks a lot. I just found out the dumb mistake myself 
|
|
|
|
|
its easy if you debug scripts on IE.
You are best person who knows about your problem.
-------------------------------------------------
More pain more gain
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
