You need to sign in to do that
Don't have an account?
rajesh k 10
Urgent:How to import multiple sheets(means multiple objects with single excel with different sheets)?
Hi,
I have single Excel sheet but this single excel sheet having multiple sheets(means multiple objects each sheet).How to import multiple sheets(means multiple objects with single excel with different sheets).
Using below code i was done import for single excel sheet for single object with but how to do import multiple objects(means i have one excel but this excel having multiple sheets(means multiple objects))
thanks
I have single Excel sheet but this single excel sheet having multiple sheets(means multiple objects each sheet).How to import multiple sheets(means multiple objects with single excel with different sheets).
Using below code i was done import for single excel sheet for single object with but how to do import multiple objects(means i have one excel but this excel having multiple sheets(means multiple objects))
<apex:page controller="importDataFromCSVController"> <apex:form > <apex:pagemessages /> <apex:pageBlock > <apex:pageBlockSection columns="4"> <apex:inputFile value="{!csvFileBody}" filename="{!csvAsString}"/> <apex:commandButton value="Import Account" action="{!importCSVFile}"/> </apex:pageBlockSection> </apex:pageBlock> <apex:pageBlock > <apex:pageblocktable value="{!accList}" var="acc"> <apex:column value="{!acc.name}" /> <apex:column value="{!acc.AccountNumber}" /> <apex:column value="{!acc.Type}" /> <apex:column value="{!acc.Accountsource}" /> <apex:column value="{!acc.Industry }" /> </apex:pageblocktable> </apex:pageBlock> </apex:form> </apex:page>
public class importDataFromCSVController { public Blob csvFileBody{get;set;} public string csvAsString{get;set;} public String[] csvFileLines{get;set;} public List<account> acclist{get;set;} public importDataFromCSVController(){ csvFileLines = new String[]{}; acclist = New List<Account>(); } public void importCSVFile(){ try{ csvAsString = csvFileBody.toString(); csvFileLines = csvAsString.split('\n'); for(Integer i=1;i<csvFileLines.size();i++){ Account accObj = new Account() ; string[] csvRecordData = csvFileLines[i].split(','); accObj.name = csvRecordData[0] ; accObj.accountnumber = csvRecordData[1]; accObj.Type = csvRecordData[2]; accObj.AccountSource = csvRecordData[3]; accObj.Industry = csvRecordData[4]; acclist.add(accObj); } //insert acclist; } catch (Exception e) { ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR,'An error has occured while importin data Please make sure input csv file is correct'); ApexPages.addMessage(errorMessage); } } }
thanks
But i have One excel with different objects in different sheets.How to import all objects records with one browse into salesforce org.Do you have examples could you please send me.Here i have seen Export all but how to do import all objects?
http://www.sfdcpoint.com/salesforce/export-excel-multiple-worksheets-visualforce/#comment-155
Thanks
https://developer.salesforce.com/forums/?id=906F0000000951VIAQ