I am using the code below to extract my report, it works fine in Excel 2007 , But for Excel 20033, the toolbar is missing, I can also save, what is the matter? This does not require the problem of your code. Try resetting Toolbar, But I doubt this is a coincidence. strFileName = Server.MapPath (EIMSCore.SysConfigEngine.SysConfig.fncGetExportFolderPath ()) & amp; "Report" & amp; StrifeId Newguide () Toasting () & amp; ".xls" crDiskFileDesOpts.DiskFileName = strFileName crExportOpts.ExportFormatType = ExportFormatType.Excel CRMainReport.Export () 'Mercedend EIMScore EIMS Sambalan. Common Re-feedback with report object (Criman Report). Clear Content () ClearHyders () .contentType = "app / vnd .ms-excel". Wreatitefile (crDiskFileDesOpts.DiskFileName) .Flush () Close this with the code
\ HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ & lt; Version & gt; \ Common \ Toolbars \ Settings and delete the Microsoft Excel entry (after making the course) then run your code again and see whether the toolbar is disappearing again or not.
No comments:
Post a Comment