//数据为三维坐标点
//东坐标 北坐标 优选岩性
//20483407.21 4120174.98 11.1
//20483256.09 4122171.86 9.9
//20483399.95 4124107.27 10.3
//20483380.39 4126072.2 12.7
if( !QFileInfo::exists(file_name) )
{
qDebug() << __FILE__ << __LINE__ << "error: file not exist! \n";
return false;
}
d_excel = new QAxObject("Excel.Application");
d_excel->setProperty("Visible", false);
if( d_excel->isNull() )
{
qDebug() << __FILE__ << __LINE__ << " isNull // ";
d_excel->setControl("ET.Application");
return false;
}
d_work_books = d_excel->querySubObject("WorkBooks");
qDebug() << __FILE__ << __LINE__ << " d_work_books = " << d_work_books;
if( (!d_work_books) || d_work_books->isNull() )
{
return false;
}
d_work_book = d_work_books->querySubObject("Open(QString, QVariant)", file_name);
d_sheet = d_work_book->querySubObject("WorkSheets(int)", 1); // 访问第一个工作表
d_used_range = d_sheet->querySubObject("UsedRange");
if( (!d_used_range) || d_used_range->isNull() )
{
return false;
}
const QVariant& var = d_used_range->dynamicCall("Value");
const QVariantList& row_lists = var.toList();
// 第一行
QVariantList row_list;
double x_axes, y_axes, z_axes;
for(int i = 1; i < row_lists.size(); i++)
{
row_list = row_lists.at(i).toList();
x_axes = row_list.at(0).toDouble();
y_axes = row_list.at(1).toDouble();
z_axes = row_list.at(2).toDouble();
}
读excel
最新推荐文章于 2023-05-10 13:37:23 发布