I want to either put a numeric value or blank when there is no data when automating Excel sheet. Instead of blank cell for no data, I get '0' instead. I use the following codes:
FillSafeArray_R4(atof(csFData[nColumn]), nRow, &saRet[nColumn]);
void FillSafeArray_R4(float d, int iRow, COleSafeArray* sa)
v.vt = VT_R4;
index = iRow;
index = 0;
The problem is that I cannot get 'd' in the FillSafeArray_R4 to show as NULL, instead of 0.0000. What shoud I do to show blank cells when I have defined the cells as number (float)?