Doing excel upload but one integer field is getting always 0.

(0) Share

Report

Posted on by Siddhant Singh

502

Hi All,

duration = cells.item(row, 4).value().int();

variable duration is getting always 0 value instead of the whole number.

Can you please help me in this?

workbook = workbooks.item(1);
    worksheets = workbook.worksheets();
    worksheet = worksheets.itemFromNum(1);
    cells = worksheet.cells();
    do
    {
        row  ;
        id = cells.item(row, 1).value().bStr();
        name = cells.item(row, 2).value().bStr();
        description = cells.item(row, 3).value().bStr();
        duration = cells.item(row, 4).value().float();
        url = cells.item(row, 5).value().bStr();

 

        certification_Name.CertificationId = id;
        certification_Name.Name = name;
        certification_Name.Description = description;
        certification_Name.Duration = duration;
        certification_Name.URL = url;

 


        //if(HcmWorker::findByPersonnelNumber(lECN))
            certification_Name.insert();
        type = cells.item(row 1, 1).value().variantType();
    }

Thanks and regards

Siddhant Singh

All responses (5)

Answers (0)

Martin Dráb 230,433 Most Valuable Professional on at

Like (0)

Report

RE: Doing excel upload but one integer field is getting always 0.

What exactly do you get if you use bStr()?
Siddhant Singh 502 on at

Like (0)

Report

RE: Doing excel upload but one integer field is getting always 0.

Yes , its an integer value. I have checked the format also.
nmaenpaa 101,156 on at

Like (0)

Report

RE: Doing excel upload but one integer field is getting always 0.

Is that field in Excel really an integer?
Siddhant Singh 502 on at

Like (0)

Report

RE: Doing excel upload but one integer field is getting always 0.

Actually I tried using both float() and int() , but didn't work with both.
Martin Dráb 230,433 Most Valuable Professional on at

Like (0)

Report

RE: Doing excel upload but one integer field is getting always 0.

I see you're using float(), not int(), in your actual code. Does it work with float()?