天天看點

Salesforce CSV檔案輸出

隸セ螳哭istView逧Вutton螻樊?ァ荳コ

VisualForce Page

謖蛾聴謖我ク區慮逧?、?炊

<apex:page controller="AccountCsvController" cache="true"
    contentType="text/csv;charset=Shift-JIS;#test.csv" readOnly="true">
        <apex:repeat value="{!csvList}" var="row">
            <apex:outputText value="{!row}" />
        </apex:repeat>
</apex:page>
           

逶ク蟇ケ蠎皮噪Controller螟?炊

public class AccountCsvController {

    public List<String> csvList {get; set;}
    ApexPages.StandardSetController controller {get; set;}

    public AccountCsvController(ApexPages.StandardSetController controller) {
        this.controller = controller;        
    }

    public PageReference execute(){
        List<Account> AccountIdList = (List<Account>)controller.getSelected();

        csvList = new List<String>();

        for(Account a : [SELECT Name, BillingPostalcode FROM Account Where Id IN : AccountIdList]){
            String line = a.name + ',' + a.BillingPostalcode  + '\n';
            csvList.add(line);
        }

        return Page.AccountCsvButtonPage2;
    }

}``


荳願ソー莉」遐∽クコ諤サ扈薙??