All geek questions in one place

Programmatically access excel files located on salesforce

I am new to Salesforce. The im task is working on some excel files on salesforce. I have to write a program to analyze the data in these excel files and generate a report. I have the following questions about this

  • Do I need to programmatically download these excel files locally to my machine? If so, which api should I use for this ?. An example will be really appreciated.

  • Is this something that can be done directly on salesforce?

Thanks.

+4
source share
2 answers

  • You have alternating choices. If you use .NET or Java, you probably want to start with the soap API, you can run a SOQL query to access the Body field of the document object (I Assuming you store them in documents). The examples for the SOAP API have examples. For other languages ​​that you probably want to start with the REST API, you can access the main resource of your document and return the binary stream, again, good examples in the documents .

  • No.

+3
source
  • Although you cannot open an Excel document to check / modify it in Apex (as far as I know), you can create - FYI
+2
source

Source: https://habr.com/ru/post/1379133/

More articles:


All Articles