Qt设置Excel列类型的问题

Areslp 2012-06-22 09:07:29

我有一组电话号码需要写入Excel，采用QAxObject的方法，但是不知道为什么设置NumberFormatLocal为文本格式不成功。代码片段如下：

			QAxObject * range = worksheet->querySubObject("Cells(int,int)", i+1, 1);  //得到单元格

			if (!range)

			{

				qDebug()<<"range does not exist";

			}

			QVariant tel=QString("%1").arg(record["tel"].toString()); //02883120983，0开头的电话号码

			//qDebug()<<tel;

			range->setProperty("Value", tel.toString());

			range->dynamicCall("SetNumberFormatLocal(const QVariant&)", QVariant("@"));

			//qDebug()<<"NumberFormatLocal:"<<range->property("NumberFormatLocal").toString(); //输出"@"

			//qDebug()<<"NumberFormat:"<<range->property("NumberFormat").toString();//输出"@"

			range->clear();

			range = worksheet->querySubObject("Cells(int,int)", i+1, 2); //另外一个cell

			//range->dynamicCall("SetValue(const QVariant&)", record["location"]);

			range->setProperty("Value", record["location"]);

			range->clear();