Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
420
Excel export encoding problem
posted
I am exporting excel from web grid by button click. But it is opening in following format. How can I Correct this problem. �� ࡱ �> �� ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������� !"#$%&'()*+,-./0123456789:;?@ABCDEFGHIJKLMNOPQRSTUV������������������������������������������������������������������������������������������������������������������������������������������������������������������������Root Entry �������� Q�Z�E� Q�Z�E� ����Workbook ������������Q�Z�E� �{b�E� �������������������������� � � B � a = � = � � �: '8 X @ � " � � 1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 � � Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 �� Arial1 � � Verdana1 � � Arial "$"#,##0_);\("$"#,##0\) ! "$"#,##0_);[Red]\("$"#,##0\) " "$"#,##0.00_);\("$"#,##0.00\) ' ""$"#,##0.00_);[Red]\("$"#,##0.00\) 7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_) .))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_) ?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_) 6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) � M/d/yyyy� �� � �� � � �� � � �� � � �� � � �� � � �� � � �� � � �� � � �� � � �� � � �� � � �� � � �� � � �� � � � +�� � � )�� � � ,�� � � *�� � � �� � � "8 � "x � #8 � "x � � "Capex should also be graphical in cockpit: UI apperance Design Change 'Performer' to 'Owner' Completed"Create Product Backlog of Features5Daily un-captured hours: Analysis revision correction;Daily un-captured hours: Automatic code review & correction&Daily un-captured hours: Design review2Daily un-captured hours: Design review corrections1Daily un-captured hours: Integration and check-in+Daily un-captured hours: Manual code review6Daily un-captured hours: Manual code review correction+Daily un-captured hours: Modification in BL-Daily un-captured hours: Requirement analysis.Daily un-captured hours: Screen implementation+Daily un-captured hours: Technical analysis;Daily un-captured hours: Testing (White box and functional)-Daily un-captured hours: UI Appearance designInline Data Entry: Integration and Check-in for Usecase screen%Inline Data Entry: Manual code review0Inline Data Entry: Manual code review correctionDInline Data Entry: White box and functional testing for Admin ScreenGInline Data Entry: White box and functional testing for Project FeatureEInline Data Entry: White box and functional testing for Task PlanningFInline Data Entry: White box and functional testing for Usecase screen Integration and Check-in Knowledge Transfer Login Authorization1Login Authorization: Analysis revision correction7Login Authorization: Automatic code review & correction2Login Authorization: Database related modification-Login Authorization: Integration and Check-in+Login Authorization: LoginPage Modification'Login Authorization: Manual code review2Login Authorization: Manual code review correction>Login Authorization: Modification in DAL, BAL, and MVP classes)Login Authorization: Requirement Analysis'Login Authorization: Technical Analysis.Login Authorization: Unit Test case correction0Login Authorization: Unit Test cases preparation&Login Authorization: White box testing Making Extention of BAL and DAL Manojkumar.SINGH2Migrate Capex Screen to Chart: POC in Infragistics Not StartedOnly descriptive fields should be adjustable in Usecase screen Owner* Plan. C. Date* POC to make inline data entryNPOC: In line Data Entry Suggestions and designer's look n feel Implementations-Product Backlog: Analysis revision correction3Product Backlog: Automatic code review & correction.Product Backlog: Database related modification1Product Backlog: Feature screen Code modification)Product Backlog: Integration and Check-in#Product Backlog: Manual code review.Product Backlog: Manual code review correction%Product Backlog: Requirement Analysis#Product Backlog: Technical Analysis"Product Backlog: White box testing;Progress bar should be displayed: Integration and Check-in>Progress bar should be displayed: Analysis revision correctionHProgress bar should be displayed: Automatic Code Revision and Correction3Progress bar should be displayed: Design Correction4Progress bar should be displayed: Manual Code Review?Progress bar should be displayed: Manual Code Review CorrectioniProgress bar should be displayed: Progress bar should come while saving and page loading for Admin ScreenpProgress bar should be displayed: Progress bar should come while saving and page loading for Define default taskmProgress bar should be displayed: Progress bar should come while saving and page loading for Project Feature jProgress bar should be displayed: Progress bar should come while saving and page loading for Task PlanningkProgress bar should be displayed: Progress bar should come while saving and page loading for Usecase screen6Progress bar should be displayed: Requirement Analysis4Progress bar should be displayed: Technical Analysis2Progress bar should be displayed: Technical Design7Progress bar should be displayed: UI apperance analysis5Progress bar should be displayed: UI apperance DesignCProgress bar should be displayed: Whitebox testing for Admin ScreenJProgress bar should be displayed: Whitebox testing for Define default taskFProgress bar should be displayed: Whitebox testing for Project FeatureDProgress bar should be displayed: Whitebox testing for Task PlanningEProgress bar should be displayed: Whitebox testing for Usecase screen$Project Dropdown can be a menu item. Rem. Eff. REQ&Rich Client - Support and enhancements(Right align number: Check in and Merging-Right align number: Implement in Admin Screen4Right align number: Implement in Define default task0Right align Web: Project Cockpit DotNet charting migration to Infragistics Web: Project dropdown in menu�z 00��� � � � � � � � � � � � U U & & d d = = � � � � w w - - E E � � $! �"� �#� �#� N$. �$~ �$� >% �%n �%� .& ~&^ �&� '� n'N �'� (� ^(> �(� �(� N). �)~ �)� \+
Parents
  • 420
    posted
    I have resolved problem by exporting by following code. /// /// Exports the Excel /// public void btnExport1() { if (Page.Request.Params.Get("__EVENTTARGET") == "Button1") { Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.Charset = ""; this.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); grdTaskPlanning.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } }
Reply Children
No Data