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
miteshsuramiteshsura 

Working with csv / excel files in apex

Hello! All,

 

I come from asp.net background and have worked on many projects that creates/modifies files. 

 

I am looking for something similar in Apex. By now I figured the basic of writing Apex code, now I want to create csv files in apex trigger which automatically gets stored in one of shared folder. 

 

Is that even possible using apex. Thanks for reading. 

Ispita_NavatarIspita_Navatar

Apex is somewhat like a server side language, so using apex you cannot create documents in local systems, what you can do is create documents in Document object.

 

Hope this helps.

 

miteshsuramiteshsura

makes sense .. I am trying to figure how can I read a csv/excell file, process the file data on cloud and again store the output again in a file. 

 

The file that I read will come from different system and file I output will be read by same system. 

 

Can you guide how can I read csv file in SF document folder and later post the file there. I can ask the user to dump the file to that folder and later get it from there as well ..  

 

what other options I have..  webservice maybe??

 

thanks