Questions tagged [excel]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
30 views

Sending a .xlsx file in a rest api using post method [closed]

I have a requirement to create a Batch Apex class and retrieve all the data from an Object, add that data to an excel file and send it in base64 format using Rest api post method. Is it possible to ...
0
votes
0answers
21 views

Export to excel multiple sheet/tab in salesforce apex [duplicate]

I want to Implement export to excel functionality in salesforce apex with Visual force page. I want to export to excel with multiple sheet/tabs. Sheet/tab would be dynamic. There are multiple ...
0
votes
1answer
15 views

How can I stop using Data Loader to assign owners to Campaign Members?

Salesforce Enterprise Classic I have an outbound team of 10 individuals. We are calling contacts and leads for various reasons. Our Marketing Automation Platform populates Salesforce Campaigns with ...
0
votes
1answer
25 views

Entire Excel Comma Separated Data in a Single Column

I've Implemented the Functionality for Downloading the Excel of the records. I have two columns in Data that need to be displayed in a separate cell in Excel but in the downloaded excel, the data is ...
2
votes
1answer
120 views

Rebuild Excel Formula “Rate” in Apex

I am trying to rebuild the Excel formula "Rate" in APEX. This is a formula for calculating the interest percentage of a loan, based on the number of periods, payment amount and total amount. It's ...
0
votes
1answer
25 views

Dataloader Across Org's = How to match Contacts to their Accounts?

If I move an Account from Production to Sandbox, then when it's time to move the Contacts from Production to Sandbox, then in Excel, in the Contact CSV, I just update the AccountID Cell with the new ...
0
votes
1answer
53 views

Dataloader = CSV = Numbers = Scientific Notation

Dataloader requires CSV Files. When I convert my files to CSV it changes the numbers to "Scientific Notions": Before: After: Then they show up in Salesforce as Scientific Notions "4.90001E+11". ...
1
vote
0answers
280 views

How to download an xlsx file when using the Reports REST API

I'm looking for ways that I can download the results of reports in Apex and save them as Salesforce Files in either CSV or Excel format. I came across this page from the Salesforce Reports REST API, ...
0
votes
1answer
580 views

Download data as Excel File in Aura Component

I have a Lightning Component that renders data in a table. I currently have the logic that downloads as a CSV file. For some users,Excel is not auto formatting the file to display as Columns. So they ...
1
vote
1answer
46 views

Update one field of a custom metadata from excel sheet

I have a custom metadata called Animal__mdt with one field called Color (Among other fields). I have the new values of Color in an excel sheet. There is a 1:1 relationship between the Name field of ...
0
votes
0answers
45 views

How to Export Visualforce page as a .XLSX file? [duplicate]

I have developed a visualforce page which is exported as a .xls file and works well. But need to upgrade it to the .xlsx file when downloaded. Below mentioned is the snippet of the Page attribute ...
1
vote
0answers
48 views

Report Rest API (asynchronous run and excel export)

I'm trying to use Report Rest API to filter and export some of my reports. My first approach with synchronous report runs works pretty well, but I bumped into 500 batches' run per hour limitation. I ...
0
votes
1answer
36 views

Is there a third-party or native methodology for pushing/pulling data to/from Excel to specific Salesforce Objects?

Our desired workflow is as follows: 1. Creation of quote data for a specific project within Excel using a template containing a myriad of formulas necessary to accommodate technical selling. 2. ...
1
vote
1answer
298 views

Excel download from API

I'm trying to create a Lightning component that uses a button to make an API call. The response is in Content Disposition form that returns an Excel file. I'd like to be able to have the Excel file ...
1
vote
1answer
31 views

Can't Convert to String some special Chars

I have a file to insert Accounts ,but some fields like account name have values with special characters like 'ñ' ,and Im having this error "BLOB is not a valid UTF-8 string" when I execute this query: ...
0
votes
0answers
13 views

Data Extension Import Error From Excel for Mac

I'm uploading a .csv to a data extension and have pared it down to "FirstName", "LastName", and "Email" to root out the error. It's a .csv download from Webex that I'm formatting on my Mac running ...
0
votes
1answer
63 views

Open Excel in browser instead of Download

I have requirement where I want to display Excel in viewer instead of downloading it in Salesforce. I am using /sfc/servlet.shepherd/document/download/+ ID to download Excel. Is there any way to open ...
0
votes
1answer
66 views

CSS for Excel Accounting Format?

I am working with a data table in Visualforce, and I am trying to get the columns with currency values to format similarly to how the account format looks in Excel, where it will align the dollar ...
0
votes
0answers
411 views

Create Excel XLS from batch apex via Visualforce page

I have a scheduled batch apex that currently creates a .CSV document and attaches it to an email, but I have to change it, so instead of a .CSV file, I get a formatted XLS Excel document. Now, after ...
1
vote
2answers
187 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
205 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
404 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
2answers
260 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
26 views

Importin Excel files in xls format

Does anybody know if it's possible to import .xls files into SFMC ?
0
votes
1answer
95 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
863 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 ...
2
votes
1answer
305 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 ...
1
vote
1answer
210 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
2k 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 ...
1
vote
0answers
34 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 ...
1
vote
1answer
1k 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
88 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
1k 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
848 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 ...
2
votes
3answers
97 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
148 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
1answer
129 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
1k 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
727 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
398 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
423 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
343 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
1answer
332 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
1answer
488 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
635 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
1k 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....
1
vote
0answers
54 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
52 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
1k 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
935 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 ...