1

I have an excel file which contains several formulas. I need to take out some data from Salesforce into that excel file and after computing that data need to store the results back to Salesforce. Any idea on how to proceed for this?

5
  • 2
    Why don't you just use Data Loader for this? May 25, 2015 at 18:58
  • @RobinDeBondt I need to export the results into some preexisting excel file. And dataloader i think creates a new file.
    – Pankaj
    May 26, 2015 at 4:55
  • You will probably have to do some copy-paste work anyway. You could just export it using Data Loader and exporting the columns in the order you have them in your file to save some work. May 26, 2015 at 7:09
  • @RobinDeBondt Need automatic process.
    – Pankaj
    May 26, 2015 at 7:10
  • You'll want to look into some ETL tools (Extract-Transform-Load) which can handle this request (the transformations will have to be configured in the tool itself rather than in a pre-existing excel file). May 26, 2015 at 8:50

1 Answer 1

-1

You'd probably want to check out CalcFusion on the AppExchange.

Disclaimer: I work at CalcFusion. If you find this answer helps at all, I'd be glad to assist you.

To give you an idea of what CalcFusion does, it transforms Excel into an API that can be plugged into Salesforce. You will have to upload your Excel into CalcFusion, and setup web services to send the variables from Salesforce to CalcFusion. Then, CalcFusion will execute the calculations using the formulas defined in your Excel, and then return the results to Salesforce using web services. You can do as you want with the results returned to Salesforce (display, save, etc.). If you wish, we have a Trial Account available and we would be happy to assist you on your first implementation. This is the first version of CalcFusion, we'd be happy to get your feedback on it.

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .