Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    Would anyone know in which formats charts copy-pasted from Excel are stored in in office?

    I'm considering storing chunks of text in an Oracle database as various text elements. But from Word documents, powerpoint slides and infopath templates also comes charts originated in Excel and pasted into the other apps.

    - is it possible to store the charts in databases as well?
    - if so in which format(s)? (and has this changed from the O2003 file formats to the O2007 file formats?)

    All ideas and suggestions are very welcome.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't know whether the following is representative, but for what it's worth:
    If I save a Word 2003 document with a chart copied/pasted from Excel as an HTML file, the chart is saved as a .GIF file.
    If I save it from Word 2003 as a Word 2007 document (.docx), and use WinZip to look at it, the chart is stored as an .EMF file.

    Most databases have a field type that can be used to store arbitrary data, usually called a [acronym="Binary Large OBject"]BLOB[/acronym] field. You can store images, Word documents, Excel workbooks etc. in such a field.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans,

    I'll be back on this topic in 1 weeks time / ;o)
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='782742' date='02-Jul-2009 14:15']I don't know whether the following is representative, but for what it's worth:
    If I save a Word 2003 document with a chart copied/pasted from Excel as an HTML file, the chart is saved as a .GIF file.
    If I save it from Word 2003 as a Word 2007 document (.docx), and use WinZip to look at it, the chart is stored as an .EMF file.

    Most databases have a field type that can be used to store arbitrary data, usually called a [acronym="Binary Large OBject"]BLOB[/acronym] field. You can store images, Word documents, Excel workbooks etc. in such a field.[/quote]


    Hi Hans,

    Actually my question has two sides.

    We are considering using InfoPath as a supplement to Word and I'm investigating various potential problems that I see.

    1. If an Excel chart is pasted on a form how is it then stored in the database?
    (given that it is not the entire workbook or document we want to store but only the chart/graphic in question)

    2. From what I can find - and what I've been able to test so far - InfoPath only works with connections to either Access or MS SQL server - is this correct?? (We are running on an Oracle 10 db...)


    Any advice or insights are highly appreciated.


    TIA,
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'm sorry, I can't help you with these questions.

  6. #6
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,594
    Thanks
    5
    Thanked 1,059 Times in 928 Posts
    [quote name='Henrik Ryberg' post='784508' date='14-Jul-2009 09:14']Hi Hans,

    Actually my question has two sides.

    We are considering using InfoPath as a supplement to Word and I'm investigating various potential problems that I see.

    1. If an Excel chart is pasted on a form how is it then stored in the database?
    (given that it is not the entire workbook or document we want to store but only the chart/graphic in question)

    2. From what I can find - and what I've been able to test so far - InfoPath only works with connections to either Access or MS SQL server - is this correct?? (We are running on an Oracle 10 db...)[/quote]

    1.) I'm not positive but I'm fairly sure that it is only the "picture" that is stoed in the form data.
    2.) You can send data to a web service. So, if the Oracle db can be accessed that way you could do it. You could experiment with defining different types of data connections.

    Joe
    Joe

  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='joeperez' post='784523' date='14-Jul-2009 17:18']1.) I'm not positive but I'm fairly sure that it is only the "picture" that is stoed in the form data.
    2.) You can send data to a web service. So, if the Oracle db can be accessed that way you could do it. You could experiment with defining different types of data connections.

    Joe[/quote]

    Hi Joe,

    Read about the Web services after I'd done my last reply and understood from that, that any third party DB's must be connected through web services and that MS only supports DB's in the shape of Access or MS SQL (bit odd decision). I appreciate your confirmation of that observation


    As goes for the pictures - as everything in the forms are stored in XML, I suppose the picture will be in the SVG format?
    - but as far as I know Excel charts are not vector graphics?

    So my concern here, is how to get the chart submitted to the database and subsequently extracted - maybe into Word, maybe into a Website and maybe into another media - without distortions.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  8. #8
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,594
    Thanks
    5
    Thanked 1,059 Times in 928 Posts
    [quote name='Henrik Ryberg' post='784653' date='15-Jul-2009 01:53']As goes for the pictures - as everything in the forms are stored in XML, I suppose the picture will be in the SVG format?
    - but as far as I know Excel charts are not vector graphics?

    So my concern here, is how to get the chart submitted to the database and subsequently extracted - maybe into Word, maybe into a Website and maybe into another media - without distortions.[/quote]

    If you were using SharePoint you could connect to almost any database fairly easily. If you can do the same with the individual Office products Microsoft have done a good job of hiding it.

    Best I can say is try it.

    Joe
    Joe

Posting Permissions

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