Finance | Project Operations, Human Resources, ...

can't able to read site and warehouse values from excel

(0) Share

Report

Posted on by Ram Kumar

454

Hi,

I need to read the Site and Warehouse values from an excel sheet. But it returns an empty value. For example if my site is "1" it returns empty. Here is the code. Help me on this.

site = cells.item(row, 4).value().bStr();
warehouse = cells.item(row, 5).value().bStr();

Regards,

Ram

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Ram,

Please check if the cells are storing the values as integers instead of string. That might be causing the values to be returned as empty.

Was this reply helpful? Yes No
Ram Kumar 454 on at

Like (0)

Report

Hi Gunjan,

As it is a integer value "1" it cant read ,it only reads a string value. what steps i have to do to read a number value.

Regards,

Ram

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

In AX, site and warehouse ids are strings. Therefore I suggest to handle them as strings in Excel, too. Otherwise you can't use the Excel or your code if your customer has (now or in the future) a site or warehouse where the id has other characters than numbers.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Ram,

You can try one of two options -

1. Change the value in excel cells to be of type string, rather than integer. This is a better option you can set the excel template in the same way.

2. You can try to convert the integer value to string and check if that works-

site = int2Str(cells.item(row, 4).value().int()); warehouse = int2Str(cells.item(row, 5).value().int());

Was this reply helpful? Yes No
Ram Kumar 454 on at

Like (0)

Report

Hi Gunjan,

I have already tried converting integer value to string but this also returns empty value.

Regards,

Ram

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Ram,

It's better you change the format of the cell to Text. If any string values are passed later like "1A", "2B" etc, your code will fail.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report
Hi Ram Kumar,

Check if you see "ComExcelDocument_RU" class in AOT. It has a method "variant2Str" which automatically converts a value from Excel type to string.

site = ComExcelDocument_RU::variant2Str(cells.item(row, 4).value()); warehouse = ComExcelDocument_RU::variant2Str(cells.item(row, 5).value());

Was this reply helpful? Yes No