creating word/excel document

Ask a Question related to ASP, Design and Development.

  1. #1

    Default creating word/excel document

    We have an application where the user fills out many screens and when
    they are done, we are supposed to display the text they entered in a
    word or excel format. That is fairly easily accomplished by changing
    the content type in the response object.
    On one of the screens where they enter data, they also have the
    ability to upload a word document containing additional information.
    This is also not a problem, and is working fine.

    Now they have decided that when we create the document with all of the
    text fields in it, they want to embed the word document that they
    uploaded. Is this possible? I have been trying to find a way to do
    this and so far haven't come up with anything.
    Kerri McDonald Guest

  2. Similar Questions and Discussions

    1. Creating PDF from Word document with section breaks
      Hello, I am using Word 2004 and have a document that contains several section breaks. When I try to print the document to PDF, a separate PDF file...
    2. Anyone creating and reading Excel or Word docs using XML& CFMX?
      Hi Just wondering if anyone on the list is using CF and XML to create and / or read Excel or Word docs. We have apps using Excel and Word...
    3. Creating Word Document Issue
      Hi all, trying to create word document using following syntax in c# private Word.ApplicationClass oWordApp = new Word.ApplicationClass(); ...
    4. Black Page when creating a pdf from an Excel Document
      I am new to acrobat, so I apologize if this has been discussed before. I did a search and couldn't find anything, so I thought I would try a new...
    5. Creating Links to Word or Excel documents
      I would like to insert links to external Word or Excel documents in my FileMaker "Project Management" data base. For example, FileMaker would...
  3. #2

    Default Re: creating word/excel document

    "Kerri McDonald" <kmcdonald@cds.com> wrote in message
    news:f87f867c.0310220405.1f0c465@posting.google.co m...
    > We have an application where the user fills out many screens and when
    > they are done, we are supposed to display the text they entered in a
    > word or excel format. That is fairly easily accomplished by changing
    > the content type in the response object.
    > On one of the screens where they enter data, they also have the
    > ability to upload a word document containing additional information.
    > This is also not a problem, and is working fine.
    >
    > Now they have decided that when we create the document with all of the
    > text fields in it, they want to embed the word document that they
    > uploaded. Is this possible? I have been trying to find a way to do
    > this and so far haven't come up with anything.
    Off the top of my head (I don't know if this will work, but it's worth a
    shot) ...

    Create a Word doc with an embedded doc to simulate the end result you want
    to have. Save this file as an RTF and then open it in notepad so you can
    see the RTF code that was generated - this will allow you to "reverse
    engineer" the RTF so you'll know what you need to do on the server side to
    embed your uploaded file. In other words, instead of just changing the
    content type in the response object, create an RTF file and try to embed
    your uploaded Word doc in that.

    Here's an example of creating an RTF through ASP:
    [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;270906[/url]

    --
    Tom Kaminski IIS MVP
    [url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
    [url]http://mvp.support.microsoft.com/[/url]
    [url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]



    Tom Kaminski [MVP] Guest

  4. #3

    Default Re: creating word/excel document

    I tried that. Looks like when I get to the part in the rtf where I
    want to embed the document, it's all ones and zeroes. I tried opening
    the doc I want to embed and reading the binary and writing it to the
    rtf file. Gives me errors when I try that. Although the rtf was
    pretty ugly and I may have missed something it needed. At that point,
    I thought maybe when it embedded the document it puts other special
    characters there that are maybe not necessarily part of the document,
    or maybe it changes it somehow. I don't know. I couldn't get it to
    work.

    After talking with the project manager, it may be acceptable for us to
    just put a link to the document rather than embedding it.

    "Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message news:<bn5tad$2e69@kcweb01.netnews.att.com>...
    > "Kerri McDonald" <kmcdonald@cds.com> wrote in message
    > news:f87f867c.0310220405.1f0c465@posting.google.co m...
    > > We have an application where the user fills out many screens and when
    > > they are done, we are supposed to display the text they entered in a
    > > word or excel format. That is fairly easily accomplished by changing
    > > the content type in the response object.
    > > On one of the screens where they enter data, they also have the
    > > ability to upload a word document containing additional information.
    > > This is also not a problem, and is working fine.
    > >
    > > Now they have decided that when we create the document with all of the
    > > text fields in it, they want to embed the word document that they
    > > uploaded. Is this possible? I have been trying to find a way to do
    > > this and so far haven't come up with anything.
    >
    > Off the top of my head (I don't know if this will work, but it's worth a
    > shot) ...
    >
    > Create a Word doc with an embedded doc to simulate the end result you want
    > to have. Save this file as an RTF and then open it in notepad so you can
    > see the RTF code that was generated - this will allow you to "reverse
    > engineer" the RTF so you'll know what you need to do on the server side to
    > embed your uploaded file. In other words, instead of just changing the
    > content type in the response object, create an RTF file and try to embed
    > your uploaded Word doc in that.
    >
    > Here's an example of creating an RTF through ASP:
    > [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;270906[/url]
    Kerri McDonald Guest

  5. #4

    Default Re: creating word/excel document

    Kerri
    I have done this a couple of times and some very complex ones 200-300
    sections like this,
    I have a sample if you like as sample rtf is 200k.

    Only trouble an RTF file is not compressed and can get rather big if its
    complicated.

    Create a rich text file with place markers you can find ie. for an invoice
    number i use ##INVOICENUMBER## in the document
    Open up rtf file and hit enter so place marker starts on a new line, other
    wise I had trouble finding them.

    Then pad replacing variable to length of marker and replace it.

    I sent you a sample by email as its 60k

    Regards
    Don




    "Kerri McDonald" <kmcdonald@cds.com> wrote in message
    news:f87f867c.0310220405.1f0c465@posting.google.co m...
    > We have an application where the user fills out many screens and when
    > they are done, we are supposed to display the text they entered in a
    > word or excel format. That is fairly easily accomplished by changing
    > the content type in the response object.
    > On one of the screens where they enter data, they also have the
    > ability to upload a word document containing additional information.
    > This is also not a problem, and is working fine.
    >
    > Now they have decided that when we create the document with all of the
    > text fields in it, they want to embed the word document that they
    > uploaded. Is this possible? I have been trying to find a way to do
    > this and so far haven't come up with anything.

    Don Grover Guest

  6. #5

    Default Re: creating word/excel document

    On Thu, 23 Oct 2003 09:09:00 +1000, "Don Grover"
    <spamfree@assoft.com.au> wrote:
    >Kerri
    >I have done this a couple of times and some very complex ones 200-300
    >sections like this,
    >I have a sample if you like as sample rtf is 200k.
    >
    >Only trouble an RTF file is not compressed and can get rather big if its
    >complicated.
    >
    >Create a rich text file with place markers you can find ie. for an invoice
    >number i use ##INVOICENUMBER## in the document
    >Open up rtf file and hit enter so place marker starts on a new line, other
    >wise I had trouble finding them.
    >
    >Then pad replacing variable to length of marker and replace it.
    >
    >I sent you a sample by email as its 60k
    Any chance you could send that sample to me as well? I've been
    playing with a similar app and that solution sounds like it would
    help.

    Thanks in advance,

    Jeff
    jcochran at naplesgov dot com

    >"Kerri McDonald" <kmcdonald@cds.com> wrote in message
    >news:f87f867c.0310220405.1f0c465@posting.google.c om...
    >> We have an application where the user fills out many screens and when
    >> they are done, we are supposed to display the text they entered in a
    >> word or excel format. That is fairly easily accomplished by changing
    >> the content type in the response object.
    >> On one of the screens where they enter data, they also have the
    >> ability to upload a word document containing additional information.
    >> This is also not a problem, and is working fine.
    >>
    >> Now they have decided that when we create the document with all of the
    >> text fields in it, they want to embed the word document that they
    >> uploaded. Is this possible? I have been trying to find a way to do
    >> this and so far haven't come up with anything.
    >
    Jeff Cochran Guest

  7. #6

    Default Re: creating word/excel document

    > Now they have decided that when we create the document with all of the
    > text fields in it, they want to embed the word document that they
    > uploaded. Is this possible? I have been trying to find a way to do
    > this and so far haven't come up with anything.
    Kerry

    You should have a look to myLittleWriter, a script component (which
    means you can use it even if you cannot use regsvr on the web server)
    that generates RTF files on-the-fly.
    I think it's worth a look : it can save several hours of hard
    programming...

    myLittleWriter : [url]http://www.myLittleTools.net/mlw[/url]

    Best regards
    el.c.

    --
    // myLittleTools.net : web-based applications for ASP developers
    // Download myLittleAdmin free lite version !
    // [url]http://www.mylittletools.net[/url]
    // [email]webmaster@mylittletools.net[/email]


    el.c. - myLittleTools.net Guest

  8. #7

    Default Re: creating word/excel document

    Thanks, but it looks like this doesn't do what I really need, which is
    to embed a word document within the rtf file.

    "el.c. - myLittleTools.net" <NOwebmasterSPAM@mylittletools.net> wrote in message news:<#NOf#2fmDHA.2080@TK2MSFTNGP10.phx.gbl>...
    > > Now they have decided that when we create the document with all of the
    > > text fields in it, they want to embed the word document that they
    > > uploaded. Is this possible? I have been trying to find a way to do
    > > this and so far haven't come up with anything.
    >
    > Kerry
    >
    > You should have a look to myLittleWriter, a script component (which
    > means you can use it even if you cannot use regsvr on the web server)
    > that generates RTF files on-the-fly.
    > I think it's worth a look : it can save several hours of hard
    > programming...
    >
    > myLittleWriter : [url]http://www.myLittleTools.net/mlw[/url]
    >
    > Best regards
    > el.c.
    Kerri McDonald 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