none
how do i add external binary files to an excel 2007 XLSB RRS feed

  • Question

  • I am creating a addin for excel 2007 that uses Business Objects Enterprise Desktop Intelligence to build queries and insert the returned data into an excel spreadsheet.

     

    Functionality I am looking to implement is:

     

    1. refresh data on demand
    2. store query files withte excel workbook and reopen the queries from teh excel workbook ( to allow item 1 above)
    3. multiple queries per worksheet

    I have worked out how to do items 1 and 3 .. my issue is storing the query binary files with the workbook. I thought this could be done with the XLSB file format for excel 2007.

     

    I was looking for a solution for wrapping the binary files into the XLSB.

     

    If there is a better solution I would love to hear about it.

     

    Jon O Roberts

    jon.roberts@programmervault.com

    http://www.programmervault.com

     

    Thursday, February 14, 2008 3:42 PM