You need to sign in to do that
Don't have an account?
Akash Garg 2
export to excel button download to ftp/network path directly
Hi
I have created a custom button on opportunity page to export data to excel of Opportunity Header and its Related List.
It download to local system when i click button.
How can I download it on a network path directly or FTP path??
VF Page:-
Please advice next
I have created a custom button on opportunity page to export data to excel of Opportunity Header and its Related List.
It download to local system when i click button.
How can I download it on a network path directly or FTP path??
VF Page:-
<apex:page Standardcontroller="Opportunity" extensions="Controller_QuotePage" contenttype="application/vnd.ms-excel#test.xls"> <apex:pageBlock > <apex:pageBlockTable value="{!qt}" var="cs"> <apex:column value="{!cs.ID}" /> <apex:column value="{!cs.Name}" /> </apex:pageBlockTable> <apex:pageBlockTable value="{!LineItems}" var="cs1"> <apex:column value="{!cs1.ID}" /> <apex:column value="{!cs1.Name}" /> </apex:pageBlockTable> </apex:pageBlock> </apex:page>Apex controller: -
public with sharing class Controller_QuotePage { public Opportunity qt {get; set;} public List<Opportunity_Product__c> theLineItems {get; set;} public Controller_QuotePage(ApexPages.StandardController controller) { Id quoteID = ((Opportunity) controller.getRecord()).Id; loadQuote(quoteId); loadQuoteLineItems(quoteId); } public List<Opportunity_Product__c> getLineItems(){ return theLineItems; } private void loadQuote(String quoteId) { this.qt = [Select Id, Name FROM Opportunity where Id=:quoteId]; } private void loadQuoteLineItems(String quoteId) { this.theLineItems = [SELECT Id, Name FROM Opportunity_Product__c WHERE Opportunity__c =: quoteId]; } }
Please advice next