The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
28 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
44 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
41 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 ...
1
vote
1answer
85 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
18 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
21 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
150 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
38 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
134 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
0answers
32 views

Contents of Microsoft Excel Spreadshee “cell” to be exported as HTML in CSV [closed]

So I'm building a content spreadsheet in Excel containing a bunch of news stories that will be automatically inserted into an email. Once I complete the spreadsheet, I export it as a CSV. From there I ...
1
vote
1answer
72 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 ...
1
vote
2answers
78 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" ...
0
votes
0answers
75 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
73 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
170 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
72 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
72 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
71 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 ...
-1
votes
1answer
45 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
109 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
195 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) ...
2
votes
0answers
37 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, ...
1
vote
1answer
118 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
52 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
75 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
351 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
36 views

How to View excel file

I have a link in my Home page which should open a excel file in a new window. When i click that link the file is getting downloaded and not able to view the excel file in the new window. Right now i ...
0
votes
0answers
132 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 ...
0
votes
0answers
35 views

Join Query in Excel from salesforce

I have a requirement to join Account and TSF_vod__c object by excel connector add-ins in salesforce where Account_ID in TSF_vod__c has the reference of Account salesforce ID. While trying that getting ...
1
vote
1answer
176 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 ...
0
votes
0answers
32 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
453 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
247 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
713 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
563 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" > ...
3
votes
2answers
11k 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
2k 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
221 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
421 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
159 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
390 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
598 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
3k 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
98 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 ...
6
votes
2answers
10k 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
190 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 ...
5
votes
1answer
3k views

Reading MS-Excel Files using apex code

I have a requirement where I need to upload the excel file, parse it and store in documents. I know uploading csv and parsing but the requirment is with excel upload. Anybody done this previously? ...
3
votes
2answers
325 views

Text to Columns Function in Salesforce?

Is there a "Text to Columns" function or app (similar to the Text to Columns Data Tool in Excel) in Salesforce? Some of my data sets are too large for Excel to handle prior to uploading into ...
2
votes
1answer
914 views

Batch converting leads from an excel sheet

I am new to Force.com and Salesforce in general and am looking for assistance with a client requirement. On a regular basis, they receive an excel sheet from a partner listing new customers that have ...
1
vote
0answers
200 views

SSO and Excel connector

Is there a way to login from an excel connector using SSO credentials? I did see the post here https://code.google.com/p/excel-connector/issues/detail?id=31 requesting to add SSO for excel connector. ...