Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [excel]

The tag has no usage guidance.

0
votes
1answer
21 views

Catch and change locale Excel date format when importing to ISO8601

I am implemeting an excel import where besides others, a date field is imported to salesforce and inserted as a record. Now I have e.g. an excel sheet where I have a date Format like 01.02.2020 or 02/...
0
votes
1answer
17 views

Excel download characters got corrupted in lightning component?

Using lightning component i want to download the excel file with some contacts. I am able to get the contacts. But file downloading if my contact name is in other language like Chinese/Japanese, the ...
0
votes
0answers
43 views

How to remove double quotes from CSV

A .csv file I have imported via FTP (too large to manually upload) is wrapping several of the contained columns values in double quotes. When I review the file in Excel the quotes don't exist and the ...
0
votes
0answers
29 views

How to download the excel from visual force page?

I have uploaded CSV file in visualforce page,When i click on the Download button then download the excel file,this is actual scenario,But here button also downloading along with excel file,How to ...
0
votes
2answers
53 views

How to calculate present value (PV) in formula

I have a formula (see below) which works in Excel and uses the -PV function (in bold). The PV function calculates the present value of a loan based on certain criteria. However, Salesforce doesn't ...
0
votes
1answer
16 views

Importin Excel files in xls format

Does anybody know if it's possible to import .xls files into SFMC ?
0
votes
1answer
74 views

Is it possible to convert numbers from Base 10 to Base Alphabet and back again using formula fields?

For shits and giggles, I am working to create a spreadsheet application (comparable to Excel, inspired by The SCells Spreadsheet) on Salesforce.com Each spreadsheet cell will correspond to one ...
0
votes
2answers
140 views

Junk Characters in excel

I exported my client's data as .csv file but when i open it in excel then it will show junk characters for Blank spaces after any character like below but in csv file blank spaces treat same as blank ...
1
vote
1answer
58 views

Salesforce version of vlookup - returning counties based on zip code

What I want to do seems fairly programatically easy. I could do it in Excel with a vlookup in less time than it would take me to complete this post. I want users to be able to enter the zip code in ...
0
votes
1answer
45 views

Visualforce Excel Export Issue

I'm trying to export a Visualforce page as an Excel document. I've looked at similar questions and the exported file is saved as a webpage embedded in excel which is prompted as unsupported/corrupt ...
2
votes
3answers
545 views

Is there a way to dynamically fill excel sheets from apex?

Currently in my sandbox I have been working on a component that, upon a button press, updates a record and sends an email with an excel sheet attachment to a given user. The excel sheet needs to have ...
0
votes
0answers
25 views

Power Query and Staging

I have installed Power Query and can access my production environment. I cannot log into our staging environment. The PW is the same in both environments. I'm wondering if the token the same in ...
0
votes
1answer
181 views

Excel Power Query and SF Connection [closed]

I have Microsoft Excel 2016 installed. It has a version of Power Query provided but it doesn't have the 'From Salesforce Objects' option from Data > Get Data > From Other Sources drop down. When I ...
1
vote
1answer
25 views

Call Excel VF Page from a static method in controller

I have a MS Excel VF Page that perfectly downloads data. Now in main VF Page I am having a remote action static method called using vf remoting from button on main page. From that method I need to ...
1
vote
1answer
248 views

How can we use VF page to download excel inside Lightning component without redirecting?

I have been using a lightning component, on clicking download button. New tab is opened which hit to the vf page url which downloads an excel. Can we use some other steps of redirection so that the UI ...
1
vote
1answer
190 views

export profiles with all field level security to an xls

need an overview from all profiles and their fls and want to export this to xls? I tried to do this with a similiar question Export available page layout fields I don't know what to do after the last ...
0
votes
0answers
28 views

Display multiple tables side by side in excel generated from VF page

I am creating multiple tables in vf page and downloading it in excel but and tables are getting created in multiple rows instead of side by side.I am using style="float:left" I am getting the tables ...
2
votes
3answers
40 views

Visualforce generated excel file stripping leading 0s

I have a visualforce page that generates an excel file with the table contained in the page, but when i open the file it is stripping the 0 on the number fields. These fields are actually text so i ...
0
votes
1answer
55 views

Export a related list of size > 100 to Excel

I am trying to create a custom link that will export a related list directly to Excel. Right now I can't get it to export more than 100 names regardless of the size of the list. Is there a way I can ...
0
votes
0answers
30 views

How to convert vf page into Excel with Special characters also?

I have the following VF page and I'm converting into excel, Everything is fine except the special characters. VF Page: <apex:page standardController="Account" contentType="application/...
0
votes
1answer
56 views

Excel VF Page change custom field labels

I have below VF Page that downloads the excel as I need. But I have further requirement to show A,B,C etc as header values in excel instead of the generic labels of the custom fields shown in excel. ...
0
votes
1answer
443 views

Can an Apex Email Handler parse an attached Excel file?

I would like to set up an email handler class to receive emails from a supplier with attached files in Excel format. We already have similar functionality that handles CSV attachments from another ...
1
vote
1answer
330 views

How to generate multiple excel files on click of a button in Vf page

I have a Vf page which displays list of Accounts and Contacts and a button called "Export All Accounts and Contacts". On click of button, an excel file gets generated with two worksheets(or tabs in ...
0
votes
1answer
157 views

Render page as excel, default output is without gridlines

It seems that every page that I rendered as excel the downloaded file is by default without gridlines. I can go to the excel properties and check the option 'Gridlines', the I'm able to see the ...
1
vote
0answers
280 views

Excel power query not loading Salesforce report

I am having issues loading a Salesforce report into Excel through Power Query. I currently have several reports all successfully loading, however with this specific report Excel is not loading ...
1
vote
0answers
193 views

Generate Excel in Salesforce Visualforce/ Apex

Has anyone done Excel file generation in Salesforce with bit complex formatting? If so appreciate any guidance or reference. I already tried formatting with CSS and having the contentType="...
0
votes
0answers
29 views

Excel Power Query - Salesforce Opportunity Object missing Territory2ID

I need to pull Salesforce data into Excel via the Object, rather than a Report, using a power query. I was planning to include the Territory assigned to the Opportunity but the Territory2ID field does ...
0
votes
1answer
145 views

Conga Composer 8 Repeat plain data

I need to repeat labels for rows while merging repeating data into excel. For example, I have the following template: After merging I need it to look like: Using the template above it looks like: ...
0
votes
0answers
39 views

Import from Excel

I have a requirement to import data from excel sheet which has data similar to the below one, As you see, I need to map two (or more) Contacts to the same account in a row. For Eg, 2nd row has 2 ...
0
votes
1answer
364 views

Export a DataTable generated by a function (HTML tables) to Excel

Based on the requirements, i have to generate 3 dataTable using a JQuery function like below and i need to implenet a button to export the result into an excel file. I'm currently using contentType="{!...
0
votes
0answers
379 views

Export from Intellij/Illuminated Cloud all of the object's XML into one file

My requirement is to get all Object's description. After some investigation we found that this isn't possible unless you get it from the XML. I created a new Intellij project of just the objects. I ...
0
votes
1answer
495 views

Warning when opening Apex generated Excel .xls?

I am trying to send an E-Mail with an Excel Attachment. Everything works, except I am getting a warning when I am trying to open the send attachment: The file format and extension of 'ExcelfileSC....
0
votes
0answers
163 views

facing Issue exporting image to excel from visualforce page , image is not visible

I am facing one issue exporting image into excel generated by Visualforce page. Below is my snippet. <apex:page id="pg" standardStylesheets="false" controller="SPController" contenttype="...
0
votes
0answers
58 views

How to merge xml in an existing excel as sheet2 using Apex

I have an excel which is unzipped and stored in Salesforce using the method described in blog (https://andyinthecloud.com/2012/12/09/handling-office-files-and-zip-files-in-apex-part-2/) I have some ...
1
vote
0answers
52 views

I want to be able to generate an excel with multiple sheets dynamically in visual force [closed]

I want to be able to generate an excel with multiple sheets dynamically in visual force. The worksheets should generate dynamically through a list of data
0
votes
0answers
45 views

Number format not getting applied in Excel

I am generating Excel from Visualforce by xml format. When I add number type Instead of String It doesnt allow me to open excel. Any reason why? Whats alternate solution for this? <Data ss:Type="...
2
votes
1answer
688 views

Export to Excel with Command Button

how do I export searched data to excel? or even not yet search? <apex:page standardController="Account" Extensions="GoodStandingController" contentType="application/vnd.ms-excel#SalesForceExport....
1
vote
0answers
534 views

How to use XML to Export data to Excel?

Can someone give me an example of using XML to export data out to Excel. I have been following the tutorial at: http://www.pexlify.com/salesforce-exporting-data-into-formatted-excel-part-2/ But for ...
2
votes
0answers
126 views

Salesforce connector Excel Add in - auto refresh doesn't trigger a data connection download

I have an excel file which uses Salesforce connections (Salesforce Connector) to download the report file in csv format and updates the excel sheet with new data. When i use the option Refresh All ...
2
votes
0answers
350 views

Go back to the previous Salesforce Page?

I have two pages, each with their own controller. One page has a commandButton that when clicked returns a PageReference to the second page. The second page simply has data table- this page is ...
0
votes
1answer
500 views

Salesforce Integration with C# with SSO

I have a requirement to enable SSO for a excel add-in application to salesforce. Currently we are using sfdc user name and password while connecting to salesforce from excel add-in. Now the ...
0
votes
1answer
916 views

is there any way to insert an image in excel using xml spreadsheet in salesforce?

I want to insert an image in excel sheet. In below code, i don't know what should be the type(ss:type) and what should be included in data tag to export image in excel sheet. <row> <Cell ...
0
votes
1answer
24 views

Excel date data prepare

I have a date field value in an excel column as 9/2/2016. I need to use text formula to put the value like this 09-02-2016. I know if I manually enter such a value it will automatically take it as 9/...
3
votes
2answers
398 views

partial formatting in excel cell using xml spreadsheet in salesforce

I want to bold particular word of a particular cell. I have successfully exported the the excel sheet from VF page and applied styles on individual cells. Now I want to bold a specific word from ...
0
votes
1answer
47 views

Handling Empty Rows of Excel in Apex

I have a excel file in which 10 rows of data is written manually and later deleted 9 rows of data by selecting and pressing 'Delete(Keyboard button)'. While i read the file in apex its showing 10 rows ...
2
votes
0answers
1k views

Reading the data from .xls file and insertion

I have a requirement whereby customers will enter their organization contact information in .xls(excel) file which I should read and insert in to organization. Is there a way to to do that (through ...
0
votes
1answer
142 views

Display on Excel conga merge

is there way to display on conga excel merge only sub total of items, then the grand total? i.e. Gross Revenue 370 1200 total 1570 the use does not need to see the 370 and the 1200. the use only ...
0
votes
1answer
108 views

Using custom contentType to display Visualforce page data in an Excel spreadsheet

According to the Visualforce Developer Guide, you can specify a different format for a Visualforce page by using the ContentType attribute on the tag. Specifically you can display Visualforce page ...
0
votes
2answers
87 views

Move existing picklist values to two different picklists

I have one multi-select picklist field with below values ONE TWO THREE FOUR Now I want to move the first value to new single picklist field and rest of the values in other multiselect picklist. ...
1
vote
1answer
120 views

Visualforce page rendered as xls no longer working [duplicate]

I am having trouble with a visualforce page rendered as xls. It was working fine for a year and now it stopped. The .xls file is generated and downloaded but shows up as a blank grey background with ...