Codejock Developer Community : Exporting Report to XLS,XLST http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 18:58:58 +0000 Thu, 09 Sep 2010 09:41:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=17218 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Exporting Report to XLS,XLST : Hi;take a look at XLSGEN: http://xlsgen.arstdesign.com/ ...]]> http://forum.codejock.com/forum_posts.asp?TID=17218&PID=60110&title=exporting-report-to-xlsxlst#60110 Author: mgampi
Subject: 17218
Posted: 09 September 2010 at 9:41am

Hi;

take a look at XLSGEN: http://xlsgen.arstdesign.com/
]]> Thu, 09 Sep 2010 09:41:30 +0000 http://forum.codejock.com/forum_posts.asp?TID=17218&PID=60110&title=exporting-report-to-xlsxlst#60110 <![CDATA[Exporting Report to XLS,XLST : Hi Shan Thank you for the code...]]> http://forum.codejock.com/forum_posts.asp?TID=17218&PID=60107&title=exporting-report-to-xlsxlst#60107 Author: checksandy
Subject: 17218
Posted: 09 September 2010 at 4:51am

Hi Shan
Thank you for the code snippet. But this code will only work in PCs which have Excel already installed. I was looking for some internal function which can directly write a XLS/XLST file or for that matter a PDF file, Basically an export feature.
Sandy
]]> Thu, 09 Sep 2010 04:51:33 +0000 http://forum.codejock.com/forum_posts.asp?TID=17218&PID=60107&title=exporting-report-to-xlsxlst#60107 <![CDATA[Exporting Report to XLS,XLST : Hi Sandy, You can Export Report...]]> http://forum.codejock.com/forum_posts.asp?TID=17218&PID=60098&title=exporting-report-to-xlsxlst#60098 Author: SHAN
Subject: 17218
Posted: 08 September 2010 at 11:04pm

Hi Sandy,

   You can Export Report Control Data to Excel Using this Code...!
 
 
  
Public Sub ReportControlToExcel(Rptcontrol As ReportControl)
      Dim xlObject    As Excel.Application
 
      Dim xlWB        As Excel.Workbook
            
          Set xlObject = New Excel.Application
 
      
          'This Adds a new woorkbook, you could open the workbook from file also
 
          Set xlWB = xlObject.Workbooks.Add
                  
          Clipboard.Clear 'Clear the Clipboard
          'Add Column Headers
             For i = 1 To Rptcontrol.Columns.count
                   xlObject.ActiveSheet.Cells(1, i).Value = _
                        "" & Rptcontrol.Columns.Column(i - 1).Caption
              Next
             
           'Select All Records
                        For i = 0 To Rptcontrol.Rows.count - 1
                         Rptcontrol.Rows(i).Selected = True
                        Next
             'Copy Records to ClipBoard
                      Rptcontrol.Copy
              With xlObject.ActiveWorkbook.ActiveSheet
 
              .Range("A2").Select 'Select Cell A2 (will paste from here, to different cells)
              .Paste              'Paste clipboard contents
              End With
              'Clear Selected Records from Selection
              Rptcontrol.SelectedRows.DeleteAll
           Clipboard.Clear
                      'Format excel Columns
             For i = 1 To Rptcontrol.Columns.count
            xlObject.ActiveSheet.Columns(i).AutoFit
            xlObject.ActiveSheet.Columns(i).HorizontalAlignment = xlCenter
              Next
              'Format Excel Rows
             xlObject.ActiveSheet.Rows(1).Font.Bold = True
          xlObject.ActiveSheet.Rows(1).Interior.Color = &HFFC0C0
         xlObject.ActiveSheet.Rows(2).Select
         'Freeze the First Row
         xlObject.ActiveWindow.FreezePanes = True
        
          ' This makes Excel visible
          xlObject.Visible = True

End Sub
 
 
-----------------------------------------------------------------------------------
'To call the Method Use
 
call ReportControlToExcel(Reportcontrol1)
   
]]> Wed, 08 Sep 2010 23:04:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=17218&PID=60098&title=exporting-report-to-xlsxlst#60098 <![CDATA[Exporting Report to XLS,XLST : Hi Everybody, In my application,...]]> http://forum.codejock.com/forum_posts.asp?TID=17218&PID=60092&title=exporting-report-to-xlsxlst#60092 Author: checksandy
Subject: 17218
Posted: 08 September 2010 at 8:30am

Hi Everybody,

In my application, I am using report control to display textual data in various columns.
Is there a way by which ReportControls Records can be directly saved to Excel format (XLS,XLST) or other ASCII formats (CSV)
 
Thanks
Sandy
]]> Wed, 08 Sep 2010 08:30:06 +0000 http://forum.codejock.com/forum_posts.asp?TID=17218&PID=60092&title=exporting-report-to-xlsxlst#60092