Re: [ACFUG Discuss] Creating excel file using table data in CF.. but excel borders are missing
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
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
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
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
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
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? <>