I have created a Spreadsheet object that I need to stream directly to a file through the browser. I can not save this file, that I would then stream, to the web server, even though this would save me a lot of aggravation.
Since Microsoft seems to see no value in providing any documentation for their OWC 11 components, I am just one of many developers groping around trying to find how to use this.
We are trying to download a table from a Web site (ASP) to Excel. One of the fields contains phone numbers with ziro ("0") as the first character. While downloading the table to Excel, the program disregard the ziro, and format the number as "Number" without the first ziro. We tryed to use:
spredsheet.Cells(iRow,iColumn).NumberFormat="@"
like in VBA, but it didn't work. How to define this column as text?
<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=hardware.xls" %>
I'm using the above lines to generate a spreadsheet from a recordset. One of the recordset fields has HTML data.
Whenever the spreadsheet is generated,it will place some of the HTML data into new rows. Same appropriate column,but different rows. Is there a way around this?Is there an easy to create a DBF or CSV file that would work?
i am having a problemn thinking on a solution to make a web application.
This is the scenario: I have to make an application that should catch some
user data on the screen and pass it to a database. Here is the problemn: the
data that the user will pass is huge. I am talking about some columns and 27
rows.
3 rows as caption rows and the other 24 to get the data. How can i do
that? I thought about making columns with textboxes (with ids like R1C1,
R2C2, R1C4...) in a dynamic table inside a form and submit it.
But the boss
wants an excel spreadsheet look into it. I am relutant about using OWC
because first, i don't know if the users will have the office installed and
secondly because if they do have office installed, how can i know what
version of office is everybody using? Code:
Is anyone know the streaming (playing while downloading) in asp. Actually right now it's downloading all the song before it plays.
View Replies View RelatedI would like to ask something regarding my project. i've been planning to develop a website using asp code for streaming multimedia features.
unfortunatly i have zero knowledge bout all this things that needed. can someone give me a rough guideline abt what should i do step-by-step. such as what database should i use. how can i store or create a database that can hold my multimedia files?
I have created an asp page that resemebles that of a spreadsheet. It contains mostly javascript functions. The page functions ok except when there are a significant amount of row entered. Then there is a delay tabbing from cell to cell -- but only cells that have function(s) associated with it. Is there something that I can do to speed this up?
View Replies View RelatedI'm creating a spreadsheet online via ASP. I have the following at the page
top...
<% Response.contenttype = "application/vnd.ms-excel" %>
<% Response.AddHeader "Content-Disposition", "filename=FullList.xls" %>
It works fine for some 60+ manufacturer listings. However, it balks on one
single manufacturer. By chance, this manuf has 18,000+ records. The others,
less than 10,000. Is there a limit to the number of records I can convert to
XLS...?
I have my excel spreadsheet generating just fine. What I'm trying to do is format each cell to something other than "general" I've figure out how to format to currency:
<td>$<%=variable%></td>
I really need to format to "text" though. Anyone have a good link to a chart that explains how to format to all of the different possibilites, or just how to format to text?
I'm successfully using Response.ContentType = "application/vnd.ms-excel" to generate an Excel spreadsheet from an asp page and a SQL Server database.One of the columns contains data that is a long number (13 characters eg. 1122334444566).The spreadsheet does not display the number correctly because the column is formatted as 'General' so it displays 1.12233E+12.To correct this in Excel I simply change the column type to number. How do I get around this in asp.
I know I could use fso to create the spreadsheet on the server using a template, but I prefer to do it on the client side so that I don't accumulate a whole lot of xls files on the server.
I didnt build the worksheet yet because I was stuck at the line Set oSS = CreateObject("OWC10.Spreadsheet")
I get this error
Error Type:
(0x8002801D)
Library not registered.
/gcrm/DailyRCReport/genExcelOWC10.asp, line 18 .
I am writing an ASP page that uses the Spreadsheet Office 200o Web Component. I need a cell to open up a popup window when clicked. I can only get a new page to display using hyperlink. I want this to be a popup page like the one you can create using window.open().
Can this be done? Can I do this using some window/Spreadsheet events, can a SpreadSheet cell contain a call to a javascript method? I would like one of the columns to contain not only a hyperlink but also be displayed as an image of type *.gif. Is this doable?
Here is a written descripton of my webpage.
One frame split down the middle. The left side is the menu and the right
displays what is selected from the menu.
the user selects from the menu and on the right, clicks on "download image"
link. the user is presented with a download dialog box. The user saves the
image and when it is completed goes and selects another item from the menu.
But this time nothing happens.
It is like i have to refresh the page before anything works again. It is
like it is stuck on the ASP binary stream file that forced the download.
on my link i have
<a href="donwload.asp" target="right">download image</a>
How can i fix this?
I have a page which allows the user to open one of several spreadsheets by
streaming the XLS to the client.
On my development site, everything appears to work fine. On the live site,
it works fine for the vast majority of users, but not for my colleague & I.
When this page is called with the correct inputs, the standard
Open/Save/Cancel/More Info dialog should appear. In the dialog, it gives the
following details:
Filename: Gothenburg Sweden.xls
File type: Microsoft Excel Spreadsheet
From: Servername
Clicking on open, means that the file will be opened in the local copy of
Excel; this works for most people, except one colleague and myself. In our
case, after clicking on Open, we get the following error msg:
"Internet Explorer cannot open travel.asp?journey=1 from <servername>
Internet Explorer was not able to open this internet site. The requested
site is either unavailable or cannot be found. Please try again later."
Anybody got any ideas about this? Code:
I have the following code which works fine downloading smaller files, the
trouble is most of the files to be downloaded are large. With large files it
just returns a HTTP 500 error. Code:
i used active x plugin (quicktime), in source file of the plugin i placed the code "Myservermyvideovideo.mov" but when i browse the page, it cant view the view, i used iis6.0. ider an addtiional code on this when retrieving the source from a network?
View Replies View RelatedA Client With a Web Cam Want go to www.domain.com choose stream details and start.streaming his video and other people can go to
www.domain.com/ClientName
The Client Webcam Stream Should Go Trough a Linux / Windows Server And The Server Show it on web page that every one can see
I am trying to set up audio streaming on my website. I would like to know if there are any good articles out there that can at least get me started.
View Replies View RelatedI have a page which allows the user to open one of several spreadsheets by streaming the XLS to the client.
View Replies View RelatedI've got a particular project to do and because of my very basic understanding I'd appreciate being pointed towards a relevant example. Basically I want to have my client side stream the contents of an XML using SOAP to a webserver.
I don't want to attach an XML file, rather just stream the contents. I have to write both parts. There must be good tutorial around somewhere.
does anyone have a good way of streaming video on my site? I guess it doesn't matte what format they are in, is there something which kicks off media player?
View Replies View Relatedneeeded some advice and code snippets on trying to stream a video file in ASP. I know i can run that video file in flash file and then run it in asp but i dont intend to do that. I need to use only ASP.
View Replies View RelatedWhat is the syntax to connect to an excel spreadsheet as well displaying contents of a column.
View Replies View RelatedI have a report that the user can view either on a page with HTML or they can open it in Excel.
I am attempting to change the content type with this statement:
response.contentType = "application/vnd.ms-excel"
But it appears that when I do this I lose all my request variables and my recordset is null.
I am creating a website in which users will be able to query an sql database by several different criteria (i.e.- name, department,supplier, part#, date). What will return to the user will be a webpage with the column headings that they selected in their search criteria (i.e.- name, supplier, part#) and below those column headings, a list of the results.
I want the user to be able to print this report or export it to an excel file, this is the part that is tripping me up.Any ideas about this? Am I going about it all wrong?
How to using asp script update data in Excel Spreadsheet with style (ie, Bold, Font Size ..) ? Is it possible to do that ?
View Replies View RelatedI'm using the Excel application object to create a
spreadsheet from a recordset. Everything seems to work
fine except any date fields are not displaying properly.
For example 4/18/2004 is displaying as 38095 in the
spreadsheet.
I loop through the recordset to display each row. The
line that actually writes out the field is:
objSpreadsheet.Cells(iRow, iCol).Value = objField.Value
Any suggestions?
I am just wondering if this is possible to do?
View Replies View RelatedI am trying to import an excel spread sheet, my first step is to be able to see the spreadsheet on the webpage, Code:
View Replies View RelatedI am semi-new to ASP. I'm in the process of making several reports and I wanted to condense one of our reports to fit nicely on a web page. This report consists of about 5 different queries.
I want to make a table like the one below in ASP. I thought I would just make a table and go from there but I quickly realized I can't.
What would be involved with having an Excel spreadsheet displayed in an ASP page? The additional problem is that the file name changes on a monthly basis. For example, this month's file name is 'Feb 2005.xls'.
View Replies View RelatedI'm about to venture onto a new project of developing an ASP Page that captures images from a streaming web camera, and displays them (refreshs) the image every 15 seconds.
The question I have, is it possible to capture images (every 15 secs- from the webcam on the intranet) and store that snap shot as say a .jpg file in a folder, and then have the ability to continuously add images to this folder, so at a later date you could develop a system that would display photo after photo simultaneously, fast motion of the project in action.
We are using ASP pages and the response object in conjunction with the
binarywrite method and a custom com dll in order to stream files back to
users. All works fine, except mhtml web archives(*.mht or *.mhtml files) .
When we stream an mhtml web archive back to the user we see the actual file
inside the browser window and not the web archive document the way it should
be displayed.
We are setting the content type property to message/rfc822
for mhtml files. We also set the content-disposition header ( like this
content-disposition: filename="mytest.mht" ) This file opens up fine if we
place a direct link to the file, however exposing a directory of files is
not an option available to us.
We have also created a cgi in c that does
the same thing as the ASP however to no avail we still get the actual
contents of the file and not the mhtml document. This happens on both IIS 5
and 6. Any suggestions???