The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
33 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
20 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
38 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
17 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 ...
0
votes
1answer
23 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
12 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
94 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
39 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
69 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
20 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
369 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
71 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
297 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
5k 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
1k 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
99 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
303 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
75 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
294 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
372 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
959 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
83 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 ...
5
votes
2answers
6k 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
128 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
259 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
558 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
146 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
712 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
734 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
300 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
227 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
758 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
327 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. ...
4
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 ...