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
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());
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.
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());
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.
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.
#1
André Arnaud de Cal...
293,202
Super User 2025 Season 1
#2
Martin Dráb
231,923
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
