Using Excel data

[Former Member]

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_member260594 · Accepted solution]

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.

[Former Member]

Crystal reads the column from Excel as the field and as far as I know you can not get an individual cell as a field.