project.Variables are all string, how to declare it as int?

[bluescharp]

em... I have a variable in project, and I want to change it with some C# code, then use it in project.
but I can't set project.Variables["heartbeat"].Value = -1;
because project.Variables["heartbeat"] is a string. how to declare it as int?

 

[bigcajones]

Convert.ToInt32(project.Variables["heartbeat"].Value);

 

[lokiys]

string cSharpVariable = project.Variables["heartbeat"].Value;
int numeric = Convert.ToInt32(cSharpVariable);
return numeric;

 

[cherubin]

Hi, and could we convert the string to int in "classic zenno" and not for a C# template ? In order to record integer in a table for example

 

[EtaLasquera]

No.

 

[cherubin]

No.

Thanks for the clear as cristal answer. However that's really disappointing.

 

[lokiys]

Hi, and could we convert the string to int in "classic zenno" and not for a C# template ? In order to record integer in a table for example

Numbers are automatically int. In classic way, you do not handle variable types. It's all var
You record number in the table and thats number.
What issues do you have?

 

[cherubin]

I parse a bad formated json file ( i posted here about it https://zennolab.com/discussion/threads/how-to-save-ugly-no-properties-json-to-table.63292/#post-451880 ) However i succeed to deal with but the data parsed are some time like this :

0.50031072108822885E1
0,45786
3.45784

So i replace some text in order to have only one format which is : (int)(comma)(int)(int)(int) like 0,457
Then i record in a table which saves in a xlsx file.

So everything work great, but when i oopenb the xlsx file it's text in cell instead of number/integer.

 

[cherubin]

So no idea @lokiys for my issue ?

 

[lokiys]

So no idea @lokiys for my issue ?

If this option does not help: https://i.imgur.com/M1YZHCl.png
Also, make sure Your excel columns are number style
Then You will have to use some C# libraries for managing excel data formats.

There are article for managing excel files in full https://zennolab.com/discussion/threads/generacija-krasivyx-excel-otchjotov-po-shablonu.33585/

Sorry just Russian

 

[EtaLasquera]

To work with excel an turn it in numbers you must use excel interop with c# code to convert that columns from text to numbers.

 

[cherubin]

Hi,

So how to do that ? I never use C# module/code.
I just need to put the following code :

Convert.ToInt32(project.Variables["{-Var.Name-}"].Value);

in c# and then record in excel ?

 

[EtaLasquera]

int i = int.Parse(project.Variables["vari"].value;
int j = int.Parse(project.Variables["varj"].value;
int k = i * j;
project.Variables["vark"].Value = k.ToString();