The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
2answers
18 views

Ability to pull Excel into Salesforce [on hold]

Is it possible to display reports which is in excel same ways in salesforce. I know that there are some apps available on appexchange but can you guide me some of them which would fit my requirement. ...
0
votes
1answer
25 views

want to upload multiple parent and corresponding multiple child from csv using apex

VisualForce Page: <apex:page controller="Data_Upload"> <apex:form> <apex:pageBlock> <center> <apex:inputFile value="{!contentFile}" ...
1
vote
0answers
33 views

image is not visible in Created Multi-Sheet Excel Workbook from Apex

I want to add an image in Multi-Sheet Excel Workbook.I have successfully created a excel file with data but image is still not visible in excel. I have attache my code snippet here.Please help me ...
0
votes
1answer
340 views

Warning propmt on downloaded Excel: File format and extension do not match. The file could be corrupted or unsafe [duplicate]

I want to develop MS Excel download feature for some of my data, thus I created a VF page with following attributes on the apex:page tag. contentType="application/vnd.ms-excel#somefile.xls" cache="...
0
votes
0answers
34 views

Generating an Excel Workbook containing Images

I have to generate an Excel workbook containing images. At the moment, I'm using a Visualforce page with a text/xml contentType and the required mso headers. However, since the SpreadsheetML ...
1
vote
1answer
95 views

Formating of Excel generated by VF page

I am generating an excel file from VF page. I would need some help in formating the excel sheet. Can the width of the cells in the top row be different from the cells of the tables in the bottom. ...
1
vote
1answer
99 views

Image not getting displayed in exported excel from VF page

I am exporting a VF page as Excel document. But i cant seem to get the logo put to display in the exported excel sheet. All i get for the image is red X I did see some post to upload the image as ...
2
votes
1answer
148 views

Export Visualforce page to Excel with rich text

I have gone through this page: https://help.salesforce.com/apex/HTViewSolution?id=000003176 and successfully exported my data into excel sheet with .xls format. However, I kind of want to achieve a ...
-1
votes
1answer
61 views

How to create a simple inline calculator page? [closed]

Is it possible to have an on-the-fly calculation on a Visual Force page? An APP? I need to give our sales team an option, where they can do some simple/complicated calculations. An example would be ...
0
votes
0answers
139 views

excel not downloading in safari browser and IE

I am downloading data from a visualforce page excel ,it's working in chrome and firefox and not working in safari and IE Any suggestions would be helpfull code snipett <apex:page controller="...
1
vote
1answer
147 views

html tables to worksheets excel (keep html format )

My excel files have images so when i export to xml type, these images are losed. I have 2 visualforce pages need export excel file which contains 2 page into 2 sheets. ( I tried use excel program ...
0
votes
1answer
21 views

Public Images to public sites

I create a page export my data to excel file, user download excel file. In this file has some images, when i download file then open it. when excel is opened, it will get images from my site. Excel ...
0
votes
0answers
28 views

Salesforce Newbie - Simplified document/template modification for mass email

I am pretty new to Salesforce and its apps, as well as Apex, but bare with me.. I recently started a new role and they use salesforce for monthly/weekly performance distributions to a number of ...
1
vote
1answer
303 views

Export Visualforce Page in Excel as .xlsx and not as a Web Page.

I'm writing a Visualforce page which downloads an Excel file onto the user's computer. I have done this by adding the following to the <apex:page> tag: contentType="application/vnd.ms-excel#My ...
1
vote
0answers
61 views

Salesforce Excel Connector - Windows 8, Office 2013

Can't seem to get the Salesforce Excel Connector to work. Trying to access my Sandbox environment. Windows 8, Office 2013. Each time I get the following: "Error Generated by request::An internal ...
0
votes
1answer
233 views

Export available page layout fields

I have around 110 profiles in my org and at least 8 page layouts assigned to different profiles containing over 300+ fields each. This development has been old now and many fields are inactive which ...
1
vote
1answer
119 views

Exporting Visualforce to Excel including RichText fields

Another VF excel issue. I'm outputting RichText fields in my VisualForce export like this: <apex:column> <apex:facet name="header">Transaction Facts</...
1
vote
3answers
129 views

Visualforce export to Excel on mac

I believe I am following the correct pattern for exporting Visualforce to Excel on Mac <apex:page controller="AccountReportConfiguratorController" contentType="application/vnd.ms-excel#...
0
votes
0answers
112 views

is it possible to copy/paste data from excel to vf grid?

In the excel sheet I have created 3 columns as account name, account site, account phone for account objects. I want to copy the data from excel sheet and paste into a visual force page which is ...
2
votes
3answers
98 views

render as excel on browser it self without downloading

I have checked in with many sources but it was clear there is no provision to render excel in browser from VF page , we can just download it. But i was checking is there any out of the box solution ...
0
votes
2answers
307 views

how to generate an excel sheet using apex code such that the excel sheet has proper table and data in order

How will I be able to generate a proper excel sheet with a proper table with data pulled from salesforce and applied in the excel sheet in a proper table with proper columns and rows. And also would ...
1
vote
1answer
115 views

Visual Force as Excel: Multiple CSS classes not supported?

I'm trying to rendering a VF page as an excel file and css classes are not being applied when you have something referencing multiple css classes. Example: <apex:page showHeader="false" ...
1
vote
0answers
99 views

Export Data to Excel File - Dump Data

I am using a VF Page that allows me to export some Record data with Related Records into Excel File Using : contentType="application/vnd.ms-excel#ExportFile-{!TODAY()}.xls" cache="true" Everything ...
0
votes
0answers
120 views

How to make AutoFitHeight work?

Rendering my visualforce page as an Excel file. I have tried using tag <Row ss:AutoFitHeight="1">. It works if I do not merge the cells, but it does not work during merge. How do I resolve this?...
-1
votes
1answer
53 views

Reformatting Reports in Excel & setting Proper case [closed]

When I export a report from Salesforce into Excel, I am unable to make any field proper...it will just display =proper(A1) It won't actually change A1 from lake tahoe to Lake Tahoe. Please help!! ...
0
votes
1answer
207 views

Converting excel spreadsheet data into Salesforce Objects

Say that I am currently storing data in an excel sheet. Along the y-axis, I am storing the names of doctors. Along the x-axis, I have months. So then each individual cell represents how many patients ...
0
votes
0answers
225 views

Export Parsed Data To CSV Format From Visualforce?

I re-titled this so as to make it simplaer in concept - JSON is not directly the issue, it's the ability to export data that appears in a VF page. We have a situation where, when Leads (or Accounts) ...
3
votes
0answers
44 views

SOQL working in Excel but not Access

In Excel, I'm able to execute my query perfectly, with the help of Simba. The query is: SELECT Contact.Account.Name, Contact.LastName, Contact.FirstName, Contact.Email, Contact.Title, Contact....
1
vote
1answer
120 views

Need to export data in excel and the after computing the data again need to store in salesforce

I have an excel file which contains several formulas. I need to take out some data from Salesforce into that excel file and after computing that data need to store the results back to Salesforce. Any ...
2
votes
3answers
56 views

Help with multi-picklist query error

I'm trying to build a query to import data into Excel, and am getting thrown errors everytime I try to limit the query based on a multi picklist. The field in question is "Summit_History__c". I can ...
1
vote
1answer
90 views

How to I identify the id's of opportunity fields other than the default ones so that I may fill these using a macro from Excel?

So the nature of my work means that I need to keep a record of our opportunities on an excel spreadsheet, and then these are then to be transferred to Salesforce so that management have a clear ...
0
votes
0answers
405 views

XML Multiple Excel WorkSheets Enhanced Functionality

The code below has been modified from this solution: How to generate excel files with the multiple sheets in VisualForce which does work but I was looking to add extra functionality such as freezing ...
0
votes
0answers
159 views

Limits on Salesforce Excel connector data

I have configured sforce_connect.xla add-in in excel to fetch data from salesforce to excel sheet. Now for query results I am getting maximum 790 records where it should be 1000 or more as I can ...
1
vote
1answer
277 views

Error in Connect Salesforce using Excel Connector

I have a requirement to connect to salesforce from excel by Salesforce connector add-ins. After installing and configuring the whole as mentioned here https://code.google.com/p/excel-connector/wiki/...
0
votes
0answers
34 views

Writing in data from excel workbook

Is it possible to upload an excel workbook into an Opportunity (via Chatter or Notes&Attachments) and write code to read certain cells from that workbook and insert it into an Opportunity record? ...
0
votes
1answer
618 views

Send email with excel attachment - Blob variable doesnot exist error

I have a Map. that I built in apex class. I want to put that map output into an excel and send it as attachment. Here's the code that Im using. I get Blob variable doesn't exist error ( in the ...
0
votes
2answers
303 views

Salesforce Excel Connector

I need to know about following conditions. 1) I need to run a query on excel connector with where clause and IN operator. Example - select id from pricebookentry where id IN (set of ids) 2) I ...
0
votes
2answers
785 views

Visualforce page to Excel doc with images from attachments

I have an issue with rendering VF page as xls file. I have an apex page with a table, wich consists of some visit data and it's attachments. Attachments has an image content type, so it looks like ...
3
votes
1answer
625 views

Export to excel file problem with displaying information

Following is my page <apex:page controller="contactquery" contentType="application/vnd.ms-excel#SalesForceExport.xls" cache="true"> <apex:pageBlock title="Export Results" > <apex:...
3
votes
2answers
12k views

How to use TableTools plug-in for DataTables in Visualforce page?

i am trying to use TableTools plugin for the datatable to export the data that is being displayed in the table as CSV, Excel, etc. Though i included the plugin inside of my code it still did not ...
6
votes
3answers
3k views

How to generate excel files with the multiple sheets in VisualForce

Is anyone aware of generating excel from Visual force with multiple sheets in a workbook?
1
vote
1answer
298 views

How to ensure that all of the cell content shows in an Excel contenttype page

I am exporting a page as Excel page as described here (using contenttype). I am unsure how to ensure that the contents of the cells are showing. After opening the file, I could change it manually, by ...
0
votes
1answer
464 views

Excel Connector, “An internal server error has occurred while processing your request”, and ID column

I consider myself an expert with Excel Connector. Therefore, I'm perplexed why I cannot figure this out. I think it's a known issue that I'm just not finding posted anywhere. I literally have over ...
1
vote
0answers
199 views

How do I insert a customer purchase history when uploading data?

We are a small ecommerce business that works in the B2C model. I am in charge of setting up Salesforce for us and I need to upload all of our customers names, addresses, other information and most ...
2
votes
2answers
424 views

How to import an SFDC Report CSV export file in Numbers on Apple's iCloud?

Using Numbers on a Mac for editing my spreadsheets, but unable to find a way of downloading a report (export) from Salesforce and doing the following with Numbers: open, edit, and save. How to open ...
2
votes
1answer
676 views

Excel Connector seems to connect to a sandbox database

I'm trying to use Excel Connector to import data into Salesforce. A colleague of successfully used it before and now I want to finish the job. Our Salesforce database already contains all our clients. ...
3
votes
2answers
4k views

Excel Connector missing from Excel 2013 Add-in ribbon. How do I fix it?

I downloaded the toolkit 4.0 and excel connector 1603, followed the instructions to add this in Options/Add-Ins. It's shown as an active application Add-ins, but it doesn't show up on the Add-ins ...
2
votes
3answers
100 views

Question about generated Excel Reports

"Copyright (c) 2000-2014 salesforce,com, inc, All rights reserved" This is what shows up when I export my report to an Excel file. Is it possible to change this? If it is (through a salesforce ...
7
votes
2answers
12k views

call apex method from visual force page (not in constructor)

I want to call public apex method on load of visual force page, for purpose of Excel exporting. But I don't want to put that method in Constructor of apex class, because of some limitation (example:I ...
3
votes
1answer
206 views

Challenge: How do I get variables from Salesforce to a workbook and back with results

First off, I don't even like the direction my question is taking, but this is what is requested. We are trying to create a form in SF for sales reps to use to input numbers, hit a button and receive ...