Re: [ACFUG Discuss] Creating excel file using table data in CF.. but excel borders are missing

2007-11-01 Thread shawn gorrell
Howard beat me to it.

Doing it with html tables is dead as Disco. First thing to do is create a 
spreadsheet that looks exactly like you want it to look like and put in some 
dummy data. Save it as the XML spreadsheet format then you can use it instead 
of using html and still output it with cfcontent. Looks way better than the old 
school approach. 

- Original Message 
From: Howard Fore <[EMAIL PROTECTED]>
To: discussion@acfug.org
Sent: Thursday, November 1, 2007 5:21:11 PM
Subject: Re: [ACFUG Discuss] Creating excel file using table data in CF.. but 
excel borders are missing


Why don't you use the XML Spreadsheet format instead? Your example would look 
something like this:


http://www.w3.org/TR/REC-html40";>
 
  

   
Month
Quantity

Sales
   
   
January

80
245
   
   

February
100
699

   
   
March
230

2036
   
   
Total

410
2980

   
   

   
   

   
   

 
   
  
 

 

I don't know what some of that stuff is and if you create the document yourself 
in Excel and Save As "XML Spreadsheet" you'll see more than this. I edited the 
file down to the what seemed like the bare minimum.


On 11/1/07, Ajas Mohammed <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I saw an online example of creating excel file using table data. Everything
> is working perfect, but the problem is that the borders which are usually

> shown in excel file is missing. I tried setting  but this
> results in only the result shown in borders in excel file. 
> 
> I need to show the result with excel borders i.e
. borders all the way which
> is norm for any excel file. If you copy the result set shown in excel by
> this code i.e. select all, copy and then paste the contents into a new excel
> file, then it looks more like an excel file and thats the look the client

> needs. Makes sense? Please look at snapshot. 
> 
> Here is the code :
> 
> 
> Code:


Untitled
> Document




 value="inline; filename=acmesalesQ1.xls">
 type="application/vnd.msexcel">


> MonthQuantity$ Sales
> January80$245

> February100$699
> March230$2036
> Total=Sum(B2..B4)=Sum(C2..C4)

>  


> any suggestions how I can get that excel look with cell borders all the way?
>  
> -- 
> 
> 
http://ajashadi.blogspot.com
> No matter what, find a way. Because thats what winners do. 
> You can't improve what you don't measure. 
> Quality is never an accident; it is always the result of high intention,

> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives. 
> "Live as if you were to die tomorrow. Learn as if you were to live forever."

> -
> Annual Sponsor - Figleaf Software 
> 
> To unsubscribe from this list, manage your profile @ 
> 
http://www.acfug.org?fa=login.edituserform 
> 
> For more info, see http://www.acfug.org/mailinglists 
> Archive @
> 
http://www.mail-archive.com/discussion%40acfug.org/ 
> List hosted by FusionLink 
> -
> 


-- 
Howard Fore, 
[EMAIL PROTECTED]
"Whether you believe you can do a thing or not, you are right." -- Henry Ford
 





-

Annual Sponsor - Figleaf Software



To unsubscribe from this list, manage your profile @ 

http://www.acfug.org?fa=login.edituserform



For more info, see http://www.acfug.org/mailinglists

Archive @ http://www.mail-archive.com/discussion%40acfug.org/

List hosted by FusionLink

-







-

Annual Sponsor FigLeaf Software - http://www.figleaf.com



To unsubscribe from this list, manage your profile @ 

http://www.acfug.org?fa=login.edituserform



For more info, see http://www.acfug.org/mailinglists

Archive @ http://www.mail-archive.com/discussion%40acfug.org/

List hosted by http://www.fusionlink.com

-




Re: [ACFUG Discuss] Creating excel file using table data in CF.. but excel borders are missing

2007-11-01 Thread Howard Fore
Why don't you use the XML Spreadsheet format instead? Your example would
look something like this:


http://www.w3.org/TR/REC-html40";>
 
  
   
Month
Quantity
Sales
   
   
January
80
245
   
   
February
100
699
   
   
March
230
2036
   
   
Total
410
2980
   
   

   
   

   
   
 
   
  
 


I don't know what some of that stuff is and if you create the document
yourself in Excel and Save As "XML Spreadsheet" you'll see more than this. I
edited the file down to the what seemed like the bare minimum.

On 11/1/07, Ajas Mohammed <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I saw an online example of creating excel file using table data.
Everything
> is working perfect, but the problem is that the borders which are usually
> shown in excel file is missing. I tried setting  but this
> results in only the result shown in borders in excel file.
>
> I need to show the result with excel borders i.e. borders all the way
which
> is norm for any excel file. If you copy the result set shown in excel by
> this code i.e. select all, copy and then paste the contents into a new
excel
> file, then it looks more like an excel file and thats the look the client
> needs. Makes sense? Please look at snapshot.
>
> Here is the code :
>
>
> Code:

Untitled
> Document




 value="inline; filename=acmesalesQ1.xls">
 type="application/vnd.msexcel">


> MonthQuantity$ Sales
> January80$245
> February100$699
> March230$2036
> Total=Sum(B2..B4)=Sum(C2..C4)
> 


> any suggestions how I can get that excel look with cell borders all the
way?
>
> --
> 
> http://ajashadi.blogspot.com
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it
represents
> the wise choice of many alternatives.
> "Live as if you were to die tomorrow. Learn as if you were to live
forever."
> -
> Annual Sponsor - Figleaf Software
>
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @
> http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink
> -
>


-- 
Howard Fore, [EMAIL PROTECTED]
"Whether you believe you can do a thing or not, you are right." -- Henry
Ford



-
Annual Sponsor FigLeaf Software - http://www.figleaf.com

To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-



RE: [ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL

2007-11-01 Thread Clint . Willard
Nevermind, I got it installed. I'm not very familiar with these Window 
Java JAR installations, so for those Windows users needing help:

Download the .jar install file: squirrel-sql-2.6.1-install.jar to your 
desktop.
Open command window: Start->Run type: cmd then click OK.
Charge directory to where you saved the file: cd /d C:\Documents and 
Settings\...\Desktop
*Use dir to see alist of files if you want to make sure it is there.*
Then type in: java -jar squirrel-sql-2.6.1-install.jar

This will start the installer and will install the application, just 
follow the directions.

I'm trying it out now and will let you know if its what I wanted. Thanks






"Darin Kohles" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
11/01/2007 10:11 AM
Please respond to
discussion@acfug.org


To

cc

Subject
RE: [ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL






This is something I installed months ago but never really checked out too 
thoroughly:
 
SQuirreL SQL Client
 
http://squirrel-sql.sourceforge.net/
 
Darin Kohles, Application Developer
[EMAIL PROTECTED]
Digital Positions, Inc.
2289 Peachtree Road NE
Atlanta, GA 30309

404-351-8878 support phone
404-351-2366 main phone
404-351-4055 fax
http://www.d-p.com/ 
 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]
Sent: Thursday, November 01, 2007 8:55 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL


What would be really useful is a DBMS tool that works with MSSQL and 
MySQL, local and remote connection, with compare and synch etc.. 

Anyone know the existance of any such creature? A one-fits-all DB 
administration application? 





- 
Annual Sponsor - Figleaf Software 

To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform 

For more info, see http://www.acfug.org/mailinglists 
Archive @ http://www.mail-archive.com/discussion%40acfug.org/ 
List hosted by FusionLink 

<>

RE: [ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL

2007-11-01 Thread Clint . Willard
Interesting. I downloaded and unzipped the jar but can't find the file to 
either install it or run it.

Per their instructions: "On Windows, execute the file squirrel-sql.bat to 
run the application."  I can't find any such file.

Did you have any luck? Are you running this on Windows and how?





"Darin Kohles" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
11/01/2007 10:11 AM
Please respond to
discussion@acfug.org


To

cc

Subject
RE: [ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL






This is something I installed months ago but never really checked out too 
thoroughly:
 
SQuirreL SQL Client
 
http://squirrel-sql.sourceforge.net/
 
Darin Kohles, Application Developer
[EMAIL PROTECTED]
Digital Positions, Inc.
2289 Peachtree Road NE
Atlanta, GA 30309

404-351-8878 support phone
404-351-2366 main phone
404-351-4055 fax
http://www.d-p.com/ 
 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
[EMAIL PROTECTED]
Sent: Thursday, November 01, 2007 8:55 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL


What would be really useful is a DBMS tool that works with MSSQL and 
MySQL, local and remote connection, with compare and synch etc.. 

Anyone know the existance of any such creature? A one-fits-all DB 
administration application? 





- 
Annual Sponsor - Figleaf Software 

To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform 

For more info, see http://www.acfug.org/mailinglists 
Archive @ http://www.mail-archive.com/discussion%40acfug.org/ 
List hosted by FusionLink 

<>

RE: [ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL

2007-11-01 Thread Darin Kohles
This is something I installed months ago but never really checked out
too thoroughly:
 
SQuirreL SQL Client
 
http://squirrel-sql.sourceforge.net/
 

Darin Kohles, Application Developer
[EMAIL PROTECTED]
Digital Positions, Inc.
2289 Peachtree Road NE
Atlanta, GA 30309

404-351-8878 support phone
404-351-2366 main phone
404-351-4055 fax
http://www.d-p.com/ 

 



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, November 01, 2007 8:55 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL



What would be really useful is a DBMS tool that works with MSSQL and
MySQL, local and remote connection, with compare and synch etc.. 

Anyone know the existance of any such creature? A one-fits-all DB
administration application? 



 



-

Annual Sponsor FigLeaf Software - http://www.figleaf.com



To unsubscribe from this list, manage your profile @ 

http://www.acfug.org?fa=login.edituserform



For more info, see http://www.acfug.org/mailinglists

Archive @ http://www.mail-archive.com/discussion%40acfug.org/

List hosted by http://www.fusionlink.com

-


<>

[ACFUG Discuss] OT: SQL Tools for MSSQL & MySQL

2007-11-01 Thread Clint . Willard
What would be really useful is a DBMS tool that works with MSSQL and 
MySQL, local and remote connection, with compare and synch etc..

Anyone know the existance of any such creature? A one-fits-all DB 
administration application?



<>