Page 1 of 1
Exporting To Excel
Posted: Mon Jul 16, 2001 11:23 am
by 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!____
=> RE: Exporting To Excel
Posted: Mon Jul 16, 2001 1:49 pm
by 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
=> RE: Exporting To Excel
Posted: Tue Jul 17, 2001 4:01 pm
by 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__
==> RE: Exporting To Excel
Posted: Tue Jul 17, 2001 6:10 pm
by kfleming
Excellent suggestion!____Thanks for the idea.____Kathleen__R&R Support
==> RE: Exporting To Excel
Posted: Wed Jul 18, 2001 10:08 am
by marcel
Thank you very much michael, I will have to try this!____Marcel