Curt and McKirahan have been very helpful the past week as I have been
introduced to something new to me: generating a spreadsheet from ASP.
Now that I have the spreadsheet, I am in need of knowledge about how to
control the properties. By properties, I mean font, hyperlink, and color
information. I'd like the spreadsheet to have the same data as the HTML page
it's getting the data from, but in a different format. I have been searching
in
several places, including the Excel Help files, but cannot find any info on
how to do this.
I'm not asking anyone to tell me how to do this; just looking for where to
find out how to do this.
Anyone here have any idea where I can look? 13 1811
Now I dont know this for sure, but since the HTML code for generating an XLS
is really just an html table/cell thing you should be able to use these same
tags to set some attributes. Beyond that you may have to go to using a
component for your doc. There are limited capabilities in
HTML/ASP/VbScript/etc....
--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"middletree " <mi********@hto mail.com> wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l... Curt and McKirahan have been very helpful the past week as I have been introduced to something new to me: generating a spreadsheet from ASP.
Now that I have the spreadsheet, I am in need of knowledge about how to control the properties. By properties, I mean font, hyperlink, and color information. I'd like the spreadsheet to have the same data as the HTML page it's getting the data from, but in a different format. I have been searching in several places, including the Excel Help files, but cannot find any info on how to do this.
I'm not asking anyone to tell me how to do this; just looking for where to find out how to do this.
Anyone here have any idea where I can look?
"middletree " <mi********@hto mail.com> wrote in message
news:#x******** ******@TK2MSFTN GP09.phx.gbl... Curt and McKirahan have been very helpful the past week as I have been introduced to something new to me: generating a spreadsheet from ASP.
Now that I have the spreadsheet, I am in need of knowledge about how to control the properties. By properties, I mean font, hyperlink, and color information. I'd like the spreadsheet to have the same data as the HTML
page it's getting the data from, but in a different format. I have been
searching in several places, including the Excel Help files, but cannot find any info
on how to do this.
I'm not asking anyone to tell me how to do this; just looking for where to find out how to do this.
Anyone here have any idea where I can look?
In addition to what Curt said, try creating the spreadsheet first in Excel
and then save it as HTML. Look at the resulting code so you can "reverse
engineer" the proper output format you need.
--
Tom Kaminski IIS MVP http://www.microsoft.com/windowsserv...y/centers/iis/ http://mvp.support.microsoft.com/ http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
> > Anyone here have any idea where I can look?
In addition to what Curt said, try creating the spreadsheet first in
Excel and then save it as HTML. Look at the resulting code so you can
"reverse engineer" the proper output format you need.
No need to reverse engineering most of it since MS puts out
documentation on how to use this: http://msdn.microsoft.com/library/de...ml/ofxml2k.asp
We use Excel basically for our print engine in ASP reports. I have a
default style sheet that sets up page margins, "fit to" properties, and
"repeat at top" setting which I pass in via a session variable to
repeat a certain # of rows at each page. Works great. There's just a
couple of annoyances in Excel, such as when you put a formula in a
cell, it doesn't automatically change the width of the cell to fit the
RESULT of the formula, so you have to specifically set the width in
pixels.
"Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. .. Now I dont know this for sure, but since the HTML code for generating an
XLS is really just an html table/cell thing you should be able to use these
same tags to set some attributes. Beyond that you may have to go to using a component for your doc. There are limited capabilities in HTML/ASP/VbScript/etc....
Well, the problem is, there are things in the presentation on the HTML page
(from which the spreadsheet is launched) that I don't want in the
spreadsheet, such as hyperlinks, the gridlines not showing, etc, as well as
some things to be changed, such as background colors, fonts, etc.
So I'm assuming there is some sort of a DOM for this, but I can't find any
doc on it.
"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:uB******** ******@TK2MSFTN GP09.phx.gbl... In addition to what Curt said, try creating the spreadsheet first in Excel and then save it as HTML. Look at the resulting code so you can "reverse engineer" the proper output format you need.
I don't think I'm doing a good job of explaining myself. I have a web page,
and is displays data. I want to export that data into a spreadsheet, with
the click of a button. I have this working successfully. However, the
resulting spreadsheet carries the properties that the HTML version has,
properties that I don't want it to carry over. The gridlines don't show, the
rows are alternating colors, I'd like to change the fonts, and I'd like to
remove the hyperlinks.
I figure this thing must have a DOM or some way to specify properties as it
generates the spreadsheet, but I am looking for instructions on how to do
this.
Hmmm, if I write up a style sheet, separate for the ASP page which produces
the spreadsheet, I wonder if that might work.
middletree wrote: "Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message news:uB******** ******@TK2MSFTN GP09.phx.gbl... In addition to what Curt said, try creating the spreadsheet first
in Excel and then save it as HTML. Look at the resulting code so you can
"reverse engineer" the proper output format you need.
I don't think I'm doing a good job of explaining myself. I have a web
page, and is displays data. I want to export that data into a spreadsheet,
with the click of a button. I have this working successfully. However, the resulting spreadsheet carries the properties that the HTML version
has, properties that I don't want it to carry over. The gridlines don't
show, the rows are alternating colors, I'd like to change the fonts, and I'd
like to remove the hyperlinks.
I figure this thing must have a DOM or some way to specify properties
as it generates the spreadsheet, but I am looking for instructions on how
to do this.
Have two style sheets, one where it's an HTML view, the other for
Excel.
Ahh... that's different.
Use something like this to build a different versions for display/use http://www.darkfalz.com/1066
--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"middletree " <mi********@hto mail.com> wrote in message
news:Oh******** *****@TK2MSFTNG P10.phx.gbl... "Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message news:uB******** ******@TK2MSFTN GP09.phx.gbl... In addition to what Curt said, try creating the spreadsheet first in Excel and then save it as HTML. Look at the resulting code so you can "reverse engineer" the proper output format you need.
I don't think I'm doing a good job of explaining myself. I have a web page, and is displays data. I want to export that data into a spreadsheet, with the click of a button. I have this working successfully. However, the resulting spreadsheet carries the properties that the HTML version has, properties that I don't want it to carry over. The gridlines don't show, the rows are alternating colors, I'd like to change the fonts, and I'd like to remove the hyperlinks.
I figure this thing must have a DOM or some way to specify properties as it generates the spreadsheet, but I am looking for instructions on how to do this.
I've used this method to change the appearance of a web page when printing
before, and in fact, use it on this same Intranet app. I didn't know you
could specify it for Excel files that you build through ASP. In your
example, does it use the media=screeen, or media=print to apply to the
spreadsheet? Remember, I'm trying to affect the way the spreadsheet looks on
the screen. It may or may not get printed.
"Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
news:ek******** *****@TK2MSFTNG P15.phx.gbl... Ahh... that's different. Use something like this to build a different versions for display/use http://www.darkfalz.com/1066
-- Curt Christianson Site & Scripts: http://www.Darkfalz.com Blog: http://blog.Darkfalz.com
"middletree " <mi********@hto mail.com> wrote in message news:Oh******** *****@TK2MSFTNG P10.phx.gbl... "Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message news:uB******** ******@TK2MSFTN GP09.phx.gbl... In addition to what Curt said, try creating the spreadsheet first in Excel and then save it as HTML. Look at the resulting code so you can
"reverse engineer" the proper output format you need.
I don't think I'm doing a good job of explaining myself. I have a web page, and is displays data. I want to export that data into a spreadsheet,
with the click of a button. I have this working successfully. However, the resulting spreadsheet carries the properties that the HTML version has, properties that I don't want it to carry over. The gridlines don't show, the rows are alternating colors, I'd like to change the fonts, and I'd like
to remove the hyperlinks.
I figure this thing must have a DOM or some way to specify properties as it generates the spreadsheet, but I am looking for instructions on how to
do this.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Paul |
last post by:
Hi all
Arggghhh...........
The problem.....I want the user to be able to create an excel document and
name particular cells in the document where they want the data to be placed
and then save this out of an XML file or Excel Template file.
Next I need to convert a dataset to xml and try and transform this data into
the users xml file..........i've seen a few things on this but havent had
much success...
|
by: ImraneA |
last post by:
Hi there
Many thanks to those people who contributed to this group, helped me
greatly.
Enclose, my code, hope it helps others :-
Public Function Export_Excel_9(tbx1 As Variant, tbx2 As Variant, tbx3
As Variant, tbx4 As Variant, tbx5 As Variant, tbx6 As Variant, tbx7 As
|
by: acharyaks |
last post by:
Hi life saver,
I am using excel component for the development.
The purpose is to connect to excel through the odbc
connection string. Then through the connection extract
data into a dataset and then save the data into a client
machine (Intranet) as excel page using the excel
component (using Excel = Microsoft.Office.Interop.Excel;)
in the code.
Please help me. I have wasted so many days on this.
|
by: aacool |
last post by:
Hi,
I've been trying to open an Excel connection through OLEDB with the code
below:
string ConnectString =@"Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=" + fileName.Text + ";ExtendedProperties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = ConnectString;
conn.Open();
|
by: Matthew Wieder |
last post by:
I have the following requirements:
Build a stand-alone C# application that asks the user to click in a cell
in an Excel spreadsheet, and then displays the address of that cell in
the C# application. It seems simple enough, but the problem I'm
encountering is as follows:
In order for the user to select the cell from Excel, they must first
click once on the Excel window to give it focus and then their second
click is what changes the cell...
| |
by: Mansi |
last post by:
I need to do some research on how to use excel automation from c#. Does
anyone know of any good books related to this subject?
Thanks.
Mansi
|
by: Randall Arnold |
last post by:
I'm converting a vbscript program to vb.net. Witht he exception of .net
idiosyncrasies, most of it is working well with the same code. My only
problem is that some properties and methods are missing from the Chart
object. For instance, the following line worked fine in vbscript
(csPowerSpeed is the chart):
objXL.csPowerSpeed.seriescollection.newseries()
However, in VS.Net, newseries is no longer avaialable as a method for series...
|
by: Alan Roberts |
last post by:
Can someone please explain the following for me...
I am trying to link to a .NET DLL from Excel. Excel needs to pass a
reference to itself to the DLL and then the DLL needs to perform some work
on the running instance of Excel via that reference. As an example, a VB
DLL to return the path to the current active workbook contains the following
(in addition to the COM GUIDS automatically added to a new COMClass)...
Public Class Class1...
|
by: magix |
last post by:
Hi,
If I have following code to read the excel file, how do I validate the
worksheets name ? In code below, if the filename doesn't contains "SomeName"
worksheet, I will need to prompt error.
set oConn = server.createobject("adodb.connection")
oConn.Provider = "Microsoft.Jet.OLEDB.4.0"
|
by: TG |
last post by:
hi!
I am trying to create a sql server table from an excel sheet.
Here is the code I have:
'This procedure the xlsx file and dumps it to a table in SQL Server
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |