Exporting To Excel

[marcel]

I have a report that is 1 page long but contains 2 different tables.. In R&R 8, only one band line at a time can be exported to EXCEL. I need to see the whole report in a single page.____Does anyone have any input as to how I can do this..?____Thanks!____

[kfleming]

You could export to text and then import the text file into Excel however each line of the report would be a line of text in the first column of the spreadsheet.____It would not place data cell by cell.____Kathleen__R&R Support

[Michael_Hoffmann_(Guest)]

Hi Marcel,____if you want to keep the layout of your report, don^t read any further. ____Otherwise just create one (or more) long string(s) with all data fields you want on one line and separate them with a semikolon like: a + ";" + b + ";" + c. Put these strings where you need them in your layout (one per line). ____Then export to text file as Kathleen suggested and import into Excel as CSV type with ^;^ as a delimeter.____This trick saved me some programming effort more than once.____HTH____Michael__

[kfleming]

Excellent suggestion!____Thanks for the idea.____Kathleen__R&R Support

[marcel]

Thank you very much michael, I will have to try this!____Marcel