• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

excel csv

Explorer ,
Jul 05, 2006 Jul 05, 2006

Copy link to clipboard

Copied

hello,
i have a html report
i wish to have a option that generates html

how do you do this
tips??


<cfloop query="westcoastCases">
<tr>
<td>#allcaseID#</td>
<td>#dateform(adate_DT,"mm/dd/yyyy")#</td>

</tr>
</cfloop>
TOPICS
Advanced techniques

Views

306

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

LEGEND , Jul 06, 2006 Jul 06, 2006
What do you *actually* want? You ask for three separate things:

1) Excel
2) CSV
3) HTML

If the Excel requirement is just that you want values in cells, simply
create an HTML table, and then return it to the browser as an
application/xls with <cfcontent>. If it's more complex than that, there's
been plenty of other threads on these forums discussing how to do it. Use
"search".

Note that a CSV file has nothing - per-se - to do with Excel, other than
the fact Excel can open them.
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm...

Votes

Translate

Translate
Participant ,
Jul 05, 2006 Jul 05, 2006

Copy link to clipboard

Copied

Please describe in more detail what it is you are wanting to do

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jul 06, 2006 Jul 06, 2006

Copy link to clipboard

Copied

LATEST
What do you *actually* want? You ask for three separate things:

1) Excel
2) CSV
3) HTML

If the Excel requirement is just that you want values in cells, simply
create an HTML table, and then return it to the browser as an
application/xls with <cfcontent>. If it's more complex than that, there's
been plenty of other threads on these forums discussing how to do it. Use
"search".

Note that a CSV file has nothing - per-se - to do with Excel, other than
the fact Excel can open them.
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm

If you want an HTML table, then... your sample code simply needs <table>
tags around it.

I think you're going to have to think through what your actual requirement
is, and express it to us slightly more clearly.

--
Adam

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation