vlookups dont work in excel created using DocumentFormat.opnxml dll RRS feed

  • Question

  • Hi

    I am using DocumentFormat.Openxml dll to create an excel file. The web services layer (wcf) create the excel and places it in a templocation ,from this temp location the web app streams it back to the browser.I am streaming the excel as a .xls file

    Everything works fine except the customers say they are not able to perform any vLookups on the streamed excel.

    I am using workbook option when creating the excel.
    var workbook = SpreadsheetDocument.Create(destination, DocumentFormat.OpenXml.SpreadsheetDocumentType.Workbook)

    I am looping through datatable and adding data to cells , cell datatype is also set as string.

    let me know if ...
    there is a different way of formatting the excel during creation or
    should i be using different cell datattype  or
    if i should try and create the excel in a completely different way


    Thursday, September 19, 2013 7:58 AM