Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
intern2424intern2424 

Importing excel file and create an Sobject

Hi, I was wondering if I attach an excel file to an email, could i use an email service to run through the excel file and create the objects. I looked at the excel connector but it does not work with the non profit starter pack.

 

 

Thanks for any help you can give. 

Nick1746323Nick1746323
Probably not, there's no way in Apex to manipulate excel files.
intern2424intern2424
Can you manipulate CSV files with apex?
Message Edited by intern2424 on 11-14-2009 12:44 PM
Cool_DevloperCool_Devloper

Hi,

 

You can parse the excel as an attachment to the email using APEX code by storing the content (body) in a blob.

 

But as there is no read/write functionality available in APEX, your contents cannot exceed 10,000 chars, which is the max size of a blob!! So, this constraint is there in this case.

 

But you can do is, you can create an XML from the excel and attach that and then you can write an XML parser in APEX to create the objects without any limitation.

 

Cool_D