Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using Excel data

I want to be able to use individual excel cells (ex. A1, D6, B3) as individual fields in Crystal Reports. I want to be able to place each cell / field anywhere on the report just like I can with database fields, not displaying them in a column format. Can you please tell me how I can bring in / import the excel data into Crystal Reports in that way?

Any help on this topic would be appreciated.

Thanks!

Former Member
replied

Stew,

You could enter the Excel worksheet as multiple Linked OLE Objects in CR. When the data in the cells (worksheets) changes and the report is opened it will update the OLE object from the changed xls file.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question