locked
How to export to excel RRS feed

  • Question

  • Hello all,

    I have one requirement which takes an excel file from CRM information as input to a custom application.
    I try to use standar export funtionality but when I save it, it generates another format like code shows. And this "excel" format can not be read using Oledb connection :(:(

    Why crm does not generate a normal excel ... or I am missing any configuration ? 

    <html xmlns:v="urn:schemas-microsoft-com:vml"
    xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns="http://www.w3.org/TR/REC-html40">
    
    <head>
    <meta name="Excel Workbook Frameset">
    <meta http-equiv=Content-Type content="text/html; charset=unicode">
    <meta name=ProgId content=Excel.Sheet>
    <meta name=Generator content="Microsoft Excel 12">
    <link rel=File-List href="Account%20Advanced%20Find%20View2_files/filelist.xml">
    <![if !supportTabStrip]>
    <link id="shLink" href="Account%20Advanced%20Find%20View2_files/sheet001.htm">
    
    <link id="shLink">
    
    <script language="JavaScript">
    <!--
     var c_lTabs=1;
    
     var c_rgszSh=new Array(c_lTabs);
     c_rgszSh[0] = "Account Advanced Find View";
    
    
    
     var c_rgszClr=new Array(8);
     c_rgszClr[0]="window";
     c_rgszClr[1]="buttonface";
     c_rgszClr[2]="windowframe";
     c_rgszClr[3]="windowtext";
     c_rgszClr[4]="threedlightshadow";
     c_rgszClr[5]="threedhighlight";
     c_rgszClr[6]="threeddarkshadow";
     c_rgszClr[7]="threedshadow";
    
     var g_iShCur;
     var g_rglTabX=new Array(c_lTabs);
    
    function fnGetIEVer()
    {
     var ua=window.navigator.userAgent
     var msie=ua.indexOf("MSIE")
     if (msie>0 && window.navigator.platform=="Win32")
      return parseInt(ua.substring(msie+5,ua.indexOf(".", msie)));
     else
      return 0;
    

    Yojan
    Friday, January 15, 2010 11:06 PM

Answers

  • You can certainly open it up in Excel and save it as 'proper Excel'

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet @leontribe
    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Tuesday, January 26, 2010 8:55 PM
    • Marked as answer by Yojan Thursday, January 28, 2010 4:49 AM
    Tuesday, January 26, 2010 8:54 PM

All replies

  • CRM generates openxml format, not 'proper' Excel. I'm not sure which ODBC connector will work for this, maybe the FoxPro one?

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet @leontribe
    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Saturday, January 16, 2010 2:32 AM
    Saturday, January 16, 2010 2:32 AM
  • you can use xml parse the excel file. then load to dataset or griddataview
    Saturday, January 16, 2010 5:20 AM
  • uhmm ..supposly end users are supposed to edit this excel file format .... and after this modification is done it is uploaded to custom application.
    so as I understand, they need to save it in another file name with the correct format ... or am I wrong ?
    Yojan
    Sunday, January 17, 2010 9:45 PM
  • You can certainly open it up in Excel and save it as 'proper Excel'

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet @leontribe
    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Tuesday, January 26, 2010 8:55 PM
    • Marked as answer by Yojan Thursday, January 28, 2010 4:49 AM
    Tuesday, January 26, 2010 8:54 PM