function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

excel connector export

is there a way to export data from sfdc to xls connector.
how obtain product ID from sfdc?
Ron HessRon Hess
Yes, normaly you can construct a report in the reports tab of salesforce and hit "export to excel"

both formats work, CVS and XLS, then when you are in excel, insert a new row above the data, add the table name, now the data area is formated as the connector expects.

to get the ID, add the ID to the report, by tradition it's done in the first column

To avoid warning messages, construct your report with only fields found in a single table, not a multi-table report
How do you create a new file in excel and then export it to