Thursday, 15 July 2010

asp.net - my excel2003 toolbar is missing after export -


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? 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

This does not require the problem of your code. Try resetting Toolbar, \ 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.

But I doubt this is a coincidence.

No comments:

Post a Comment