Skip to main content
Nintex Community Menu Bar

problem: pasting numeric values in Excel sheet

  • September 9, 2021
  • 7 replies
  • 14 views
  • Translate

leon_romansvans

Hi All,

I have this problem:

I need to grab some numeric values from a website and add them in an excel.

(1) So I Let Kryon create a default excel sheet;

(2) grab the values form the website by logic expressions add them in a variable, devided by | (column) and ;(Row);

(3) let Kryon extract the numeric values and add them back in the variable with same conditions (to be sure).

(4) past variable in excel and I get this (see screenshot) to correct this I could change the definitions of the column and set them to number (no decimals) manually.

 

If i do this the long way and let Kryon create the sheet and set column to number(no decimals) first (record option) ; after the variable-past there is no difference...

 

as I need the exact number in each field in this column to recognize the number and add info in the same row I create a temporary table, but that is no use because the numbers aren't visible .. Anyone has had the same issue? 

@Darren (Kryon Systems)​ 

@dimagoncharov21@gmail.com (Community Member)​ 

Did this topic help you find an answer to your question?

7 replies

hi leon

what if you paste in excel as formulas?

Translate

leon_romansvans

Hi Marlon,

I've just tried and the result is the same..... 😞

 

Below is the table I want to past in the excel....

Translate

leon_romansvans

I tried to add a + in front of all the numbers to simulate a number definition in the field of excel, didn't work either

Translate

  • 3 replies
  • August 29, 2022

Hi @leon RomansvanSchaik​ ,

 

Add an apostrophe (') in front of all the numbers instead of + and it should work.

Translate

leon_romansvans

Hi Danny,

hope this would work... I'll give it a go and let you know if it works..thxs

Translate

leon_romansvans

Hi @Danny Toh​ ,

used your tip and it worked for me:

I added an apostrophe as delimiter (;')

And in the paste command used the row delimiter as only (;)

And this worked! thxs man

Translate

  • 3 replies
  • August 29, 2022

Hi Leon,

 

Glad that it worked for you!

All the best in your process.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings