Excel range will crash once i get the values

**ZHawk** · 16th December 2010, 10:10

hi,
reading single cells from excel is fine but reading a range causes problems.
this code is fine:

Qt Code:

Switch view

QAxObject *range = sheet->querySubObject("Range(QString)", "A4:A5");

QAxObject *range = sheet->querySubObject("Range(QString)", "A4:A5");

To copy to clipboard, switch view to plain text mode

but calling this afterwards:

Qt Code:

Switch view

QVariant v = range->dynamicCall("Value()");

QVariant v = range->dynamicCall("Value()");

To copy to clipboard, switch view to plain text mode

will give me a heap corruption

this will fix it but will result in memory leaks:

Qt Code:

Switch view

QVariant *v2 = new QVariant(v);

QVariant *v2 = new QVariant(v);

To copy to clipboard, switch view to plain text mode

deleting v2 will again result in heap corruption

anyone knows why ?
BTW: cell values: A4 = 0 and A5 = 1

**ZHawk** · 3rd January 2011, 08:13

i finally found out myself
i am using Visual Studio 2010 Express
changing the "platform toolsets" from "v100" to "v90" has fixed my heap corruptions

**timohare** · 12th July 2011, 06:22

Thread: Excel range will crash once i get the values