problem: pasting numeric values in Excel sheet

  • 9 September 2021
  • 7 replies
  • 13 views

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)​ 


7 replies

hi leon

what if you paste in excel as formulas?

Hi Marlon,

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

 

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

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

Hi @leon RomansvanSchaik​ ,

 

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

Hi Danny,

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

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

Hi Leon,

 

Glad that it worked for you!

All the best in your process.

Reply