You need to sign in to do that
Don't have an account?
S Sai
how to create Import and Export csv file using visualforce
HI all,
My requirment is Import and Export same file in in viusualforce page. Here i am importing csv data in same data i want to export csv for example
<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);
}
}
}
here i want to export same data in csv..
Thanks
SS
My requirment is Import and Export same file in in viusualforce page. Here i am importing csv data in same data i want to export csv for example
<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);
}
}
}
here i want to export same data in csv..
Thanks
SS
We are now ready to add the “Export to Excel” button to the AccountData.page as follows:
Thanks
Rupal Kumar
http://Mirketa.com
Thanks for your reply. Could you plz Explain i am confused..
Thanks
SS
Hi,
No need to create another page in the same page and same controller we need to export the data in csv only using apex and visualfroce
Thanks
SS
you need to create 2 vf page with same controller .On first you create Account data table with expot button like this-
1.AccountDataTable page- 2.Excel file page- Controller-
Thanks
Rupal Kumar
http://mirketa.com
My Reqirment is when i am import the usernames in csv like
and when i am clicking the upload button then download the user id's like
when i am importing the username and click the command button then i want to download the based on usernames id's in excel file using apex visualforce
Thanks
SS