Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Incorrect values during import of data copied from other excel

SA-81809

Summary



An Import data option is used to load the Variants information and the user has uploaded an Excel template. On downloading the template, the cells are in the Text mode. 
Additionally, on copying data from the SourceData Excel file to the ApplnTemplate Excel file, incorrect values are imported to the grid.



Error Messages



Not Applicable


Steps to Reproduce

  1. Copy values from the Notepad to the Excel file.
  2. Upload the Excel file.
  3. Download the file.


Root Cause



An issue in the custom application code or rules.


Resolution



Perform the following local-change:

Format the cells in the Excel file before copying the data.
  1. In the Excel sheet, select the column for which the format must changed.


     
  2. Navigate to the Data tab.


     
  3. Click the 'Text to columns' option in the Data tab:


     
  4. Skip the first  two steps and provide the column format as Text in the final step.


     
  5. Click Finish.
  6. Save the Excel file.
Suggest Edit

Published March 18, 2020 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us