DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: export data report to excel

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    export data report to excel

    [Originally posted by lingyi]

    hi there,
    i wish like to know how I can export my data report to excel worksheet? thanks!

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:export data report to excel

    [Originally posted by Greg DeBacker]

    One way would be to write the data to a CSV file. You could then load that file into Excel and the data would look relatively the same. In case you are wondering CSV is a Comma Separated Value file. It is a plain text file with data that is separated by commas and it has a .csv file extension.

    data1, data2, data3
    data4, data5, data6

    All of the items above would end up in their own cells in a spreadsheet. A problem could crop up if there are commas in the data itself.

    Greg

  3. #3
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:export data report to excel

    [Originally posted by lingyi]

    Do u hv a sample code on how i going to add all my data as a .csv file?

  4. #4
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Re:export data report to excel

    [Originally posted by Ed Ardzinski]

    I'm not sure how you are generating your report in the first place...I have always had to dump data to either a separate db table, or (lately) to text files...and then run my data report. So that's one aspect of the issue I'm a little unclear on.

    Anyway, try to experiment with the export feature that comes with the Data Report container. You might be able to get a decent enough text file that you could open up with Excel...

    In fact, after you export, and close the DR, you could have a command button to open Excel with the Shell command. I've never done it with Excel, but I'm nearly certain that if you use the file name as an argument int he Shell command Excel will automatically open that file. You could declare a public variable, and capture the name of the export file...lot's of ways for this one.

  5. #5
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Re:Re:export data report to excel

    [Originally posted by lingyi]

    Thanks for u friendly help, I got ur idea already ..i will try on it...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center