The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 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 ...
-1
votes
0answers
29 views

Create and save excel file for consulting any time

I hope to convey what I need. I created a page of VF in which I call a class to update records in a custom object, it makes perfectly. In addition to updating the records, I need you to generate a ...
2
votes
3answers
21 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
1answer
19 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
21 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
23 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
29 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
27 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
31 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
77 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
31 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
105 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
47 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
42 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
210 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
29 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
82 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
26 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
78 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
23 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
210 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
0answers
54 views

Where can I find v1.9.0.2 of Enabler4Excel?

Where can I find v1.9.0.2 of Enabler4Excel? I have v1.8 but after 1.9.0.2 they changed from free to a paid model. I don't use the tool often but it's handy once in a while.
0
votes
2answers
146 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
0answers
52 views

i need to split a 'export to excel' file in to multiple sheets and need to put style and logo

I am not able to modify it. please help to meet my requirement. Thank you in advance. How to generate excel files with the multiple sheets in VisualForce I saw this code. but unable to modify this ...
0
votes
2answers
533 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 ...
0
votes
0answers
94 views

How to render excel WITH multiple sheets WITH images

Right now, what we have is a fully functional VF page using XMLSS to render multi-worksheet excel files. We have no problems with this. However, we've reached a limitation of XMLSS wherein it can't ...
3
votes
1answer
416 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
7k 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 ...
5
votes
2answers
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
150 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
357 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
108 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
337 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
468 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. ...
2
votes
1answer
2k 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
94 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
8k 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
155 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
2k 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
287 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
679 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
165 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. ...
3
votes
1answer
790 views

Get xls File on Remote Server and Send as Email Attachment APEX

I have an xls file sitting on www.mysite.com/files/myfile.xls. I would like to have SalesForce via APEX grab (Not Read) this file and send it as an attachment to an email. I know how to send emails ...
3
votes
1answer
803 views

Generating excel file with dynamic name

I am trying to generate a excel sheet from a VF page. i am using contenttype="application/x-excel#filename.xls" on the page tag. These work perfectly fine. I just need a way to have the filenames ...
2
votes
2answers
341 views

Create new field based on data from spreadsheet? [closed]

I'd like to create a new field for Account objects in Salesforce which is filled based on if the Account Name matches one of the names on a spreadsheet that I have. So I basically want to have a giant ...
0
votes
1answer
264 views

Inserting Account and custom object record at the same time?

Hi i need to create a record in both Account and custom object"customlead" at the same. I tried this DataLoader but at a time we can select only one object. I need to select both how this could de ...
0
votes
0answers
888 views

XLS Read and Automatic CSV conversion

We have a requirement to read contents (rows) from an XLS file and upload (the file as an attachment) the same once the read and insert into custom Objects are complete. My observation after ...
1
vote
2answers
387 views

Perform Insert/Update/Query/Delete operations on Force.com records via Excel

Scenario: I am looking at a viable approach to insert/update/query/delete records in Force.com right from a predefined Excel Template. These operations will have to be done by the End Users. ...
5
votes
2answers
1k views

Visualforce to Excel: Prevent long number from being displayed in Scientific Notation

I have a Visual page which offers the capability of exporting a data table to Excel. There is a text field called Account number. Some account numbers are more than 12 digits long. When such numbers ...