Ask a Question related to Macromedia ColdFusion, Design and Development.

  1. #1

    Default Export Excel

    Hello,

    I have to change the code done by an another programmer. In fact, the code do
    an export to Excel with CFCONTENT. That's work but there is some blank line
    between each lines. Do you have an idea where the problem come from ? Do you
    have a piece of code to do an export to Excel.

    Thanks,

    Oufti Guest

  2. Similar Questions and Discussions

    1. Export to excel
      Hi, I have an aspx page with an export to excel functionality....it opens a dialog box asking the client to save/open the xls file.However this...
    2. how can i export data to excel?
      1,how can i export data to excel? is there direct or indirect ways ? i just assume that i convert the data to a xml string then copy to the...
    3. How to Export to Excel?
      How can I export to a excel a datagrid? -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 2. MIEMBRO ACTIVO DE ALIANZADEV
    4. Export to Excel C#
      Hi, I am having a problem exporting a Datagrid to excel in asp.net. For some reason I am getting a blank excel page. I set up in IIS the Mime for...
    5. Export to Excel sheet
      You may refer to this KB article: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q288130 Luke (This posting is provided "AS IS",...
  3. #2

    Default Re: Export Excel

    > Hello,
    >
    > I have to change the code done by an another programmer. In fact, the
    code do
    > an export to Excel with CFCONTENT. That's work but there is some blank
    line
    > between each lines. Do you have an idea where the problem come from ? Do
    you
    > have a piece of code to do an export to Excel.
    If the coding is exporting into CSV format then check for extra line-breaks,
    if it's exporting in HTML format then check for extra table rows.

    --
    <mack />


    Neculai Macarie Guest

  4. #3

    Default Re: Export Excel

    Originally posted by: Newsgroup User
    If the coding is exporting into CSV format then check for extra line-breaks,
    if it's exporting in HTML format then check for extra table rows.


    Hello,

    I used this code (HTML) found here :
    [url]http://forums.devarticles.com/t8941/s.html[/url] work fine.
    I'd like for each cell or for a specific column have "WRAP TEXT" unchecked
    You can find this property here : in cell Format => Cell => Alignement =>
    Unceck "WRAP TEXT"http://forums.devarticles.com/t8941/s.html

    Thanks for your help,

    C.

    Oufti Guest

  5. #4

    Default Re: Export Excel

    Hi Oufti,

    The attribute you want to set doesn't exist in Excel's interpretation of a
    delimited file. You'll have to roll your own mso: XML or use the Excel object
    to accomplish what you want to do.

    philh Guest

  6. #5

    Default Re: Export Excel

    Originally posted by: philh
    The attribute you want to set doesn't exist in Excel's interpretation of a
    delimited file. You'll have to roll your own mso: XML or use the Excel object
    to accomplish what you want to do.

    You don't this kind of mso:XML file ?

    Thanks,



    Oufti Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139