News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Reading Excel files wi...

Microsoft Dynamics AX (Archived)

Reading Excel files with different data types in same column

(0) Share

Report

Report

Posted on by In AX2012 in the In...

495

Hi

I have to read excel file,

i can able to read string data with below code

conValue[recCount] += cells.item(row, fields[15]).value().bstr();

& i can able to read int data with below code

conValue[recCount] += cells.item(row, fields[15]).value().double();

if i use

if(cells.item(row, fields[15]).value().double())
{
conValue[recCount] += cells.item(row, fields[15]).value().double();
}
else
{
conValue[recCount] += cells.item(row, fields[15]).value().bstr();
}

then few times sting values are are getting skipped while reading.

In my case i have both int & string values to be read.

please suggest how to read data of any type in excel.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

In AX2012 in the In... 495 on at

Like (0)

Report

RE: Reading Excel files with different data types in same column

Hi Andre

Thanks for the response , below solution worked for me

if(cells.item(row, fields[15]).value().variantType() == COMVariantType::VT_BSTR)

{

conValue[recCount] += cells.item(row, fields[15]).value().bStr();

}

else

{

conValue[recCount] += cells.item(row, fields[15]).value().double();

}
Suggested answer

André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

RE: Reading Excel files with different data types in same column

Hi Raghu,

There are actually more cell types possible for Excel. You have to debug and see which types are used when the values are skipped. Then you know what is missing and you can extend the code for other Excel cell types.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans