Qt 解析EXcel文件
【摘要】
写代码需要将excel中的文件导入到数据库中
网上找到以为大神写的，但是当初没有保存，也没有找到
我几乎是原分不动拔下来的，希望大神莫怪
void AddDialog::readExcel(QString url){ QAxObj...
写代码需要将excel中的文件导入到数据库中
网上找到以为大神写的，但是当初没有保存，也没有找到
我几乎是原分不动拔下来的，希望大神莫怪
-
void AddDialog::readExcel(QString url)
-
{
-
QAxObject excel("Excel.Application");
-
excel.setProperty("Visible",true);
-
QAxObject *work_books = excel.querySubObject("WorkBooks");
-
work_books->dynamicCall("Open (const QString&)",QString(url));
-
QVariant title_value = excel.property("Caption"); //获取标题信息
-
// qDebug()<<"读取Excel标题为："<<title_value;
-
QAxObject *work_book = excel.querySubObject("ActiveWorkBook");
-
QAxObject *work_sheets = work_book->querySubObject("Sheets"); //Sheets也可以换用WorkSheets
-
int sheet_count = work_sheets->property("Count").toInt(); //获取工作表数目
-
// qDebug()<<"当前工作表数目为："<<sheet_count;
-
exceltip = new Excel(this);
-
for(int k=1;k<=sheet_count;k++)
-
{
-
QAxObject *work_sheet = work_book->querySubObject("Sheets(int)",k); //Sheets(int)也可以用Worksheets(int)
-
QString work_sheet_name = work_sheet->property("Name").toString(); //获取工作表名称
-
QString message = QString("Sheet")+QString::number(k,10)+QString("name");
-
// qDebug()<<message<<work_sheet_name;
-
if(sheet_count>0)
-
{
-
QAxObject *work_sheet = work_book->querySubObject("Sheets(int)",k);
-
QAxObject *used_range = work_sheet->querySubObject("UsedRange");
-
QAxObject *rows = used_range->querySubObject("Rows");
-
// QAxObject *columns = used_range->querySubObject("Columns");
-
int row_start = used_range->property("Row").toInt(); //获取起始行
-
int columns_start = used_range->property("Column").toInt(); //获取起始列
-
int row_count = rows->property("Count").toInt(); //获取行数
-
// int column_count = columns->property("Count").toInt(); //获取列数
-
exceltip->show();
-
ui->pushButton_Cancle->setEnabled(false);
-
ui->pushButton_close->setEnabled(false);
-
ui->pushButton_save->setEnabled(false);
-
ui->pushButton_Excel->setEnabled(false);
-
ui->pushButton_update->setEnabled(false);
-
exceltip->setcount(row_count-1,work_sheet_name);
-
for(int i=row_start+1;i<=row_count;i++)
-
{
-
/***********************************
-
* 数据解析函数函数
-
* 将Excel中的数据分条取出
-
* 的别值得注意的是
-
* 由于数据主码是一当前时间为主码
-
* 所以要调用延时函数延时1秒
-
* 防止数据主码相同为数据加载失败
-
****************************************************************************************************************/
-
QAxObject *cell[13];
-
QVariant cell_value[13];
-
-
-
cell[0] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+0);
-
cell_value[0] = cell[0]->property("Value"); //获取单元格内容
-
-
-
cell[1] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+1);
-
cell_value[1] = cell[1]->property("Value");
-
-
-
cell[2] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+2);
-
cell_value[2] = cell[2]->property("Value");
-
-
-
cell[3] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+3);
-
cell_value[3] = cell[3]->property("Value");
-
-
-
cell[4] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+4);
-
cell_value[4] = cell[4]->property("Value");
-
-
-
cell[5] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+5);
-
cell_value[5] = cell[5]->property("Value");
-
-
-
cell[6] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+6);
-
cell_value[6] = cell[6]->property("Value");
-
-
-
cell[7] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+7);
-
cell_value[7] = cell[7]->property("Value");
-
-
-
cell[8] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+8);
-
cell_value[8] = cell[8]->property("Value");
-
-
-
cell[9] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+9);
-
cell_value[9] = cell[9]->property("Value");
-
-
-
cell[10] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+10);
-
cell_value[10] = cell[10]->property("Value");
-
-
-
cell[11] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+11);
-
cell_value[11] = cell[11]->property("Value");
-
-
-
cell[12] = work_sheet->querySubObject("Cells(int,int)",i,columns_start+12);
-
cell_value[12] = cell[12]->property("Value");
-
-
-
datasave->CRETM = gettimetss();
-
datasave->pro_name = cell_value[0].toString();
-
datasave->PSTM = cell_value[1].toString();
-
datasave->PETM = cell_value[2].toString();
-
datasave->Par_name = cell_value[3].toString();
-
datasave->PARSTM = cell_value[4].toString();
-
datasave->PARETM = cell_value[5].toString();
-
datasave->Sta_name = cell_value[6].toString();
-
datasave->STASTM = cell_value[7].toString();
-
datasave->STAETM = cell_value[8].toString();
-
datasave->INFOR = cell_value[9].toString();
-
datasave->DELTM = cell_value[10].toString();
-
datasave->REASION = cell_value[11].toString();
-
datasave->FINTM = cell_value[12].toString();
-
QString sql_insert = "insert into project values('";
-
sql_insert +=datasave->pro_name;
-
sql_insert +="','";
-
sql_insert +=datasave->PSTM;
-
sql_insert +="','";
-
sql_insert +=datasave->PETM;
-
sql_insert +="','";
-
sql_insert +=datasave->Par_name;
-
sql_insert +="','";
-
sql_insert +=datasave->PARSTM;
-
sql_insert +="','";
-
sql_insert +=datasave->PARETM;
-
sql_insert +="','";
-
sql_insert +=datasave->Sta_name;
-
sql_insert +="','";
-
sql_insert +=datasave->STASTM;
-
sql_insert +="','";
-
sql_insert +=datasave->STAETM;
-
sql_insert +="','";
-
sql_insert +=datasave->INFOR;
-
sql_insert +="','";
-
sql_insert +=datasave->FINTM;
-
sql_insert +="','";
-
sql_insert +=datasave->DELTM;
-
sql_insert +="','";
-
sql_insert +=datasave->REASION;
-
sql_insert +="','";
-
sql_insert +=datasave->CRETM;
-
sql_insert +="')";
-
QSqlQuery insert_data(*projectdb);
-
insert_data.exec(sql_insert);
-
// qDebug()<<sql_insert;
-
emit sys_data();
-
exceltip->setnumber(i);
-
delaymsec(10);
-
/****************************************************************************************************************/
-
}
-
}
-
}
-
exceltip->setfinish(true);
-
if(exceltip->exec() == QDialog::Accepted)
-
{
-
ui->pushButton_Cancle->setEnabled(true);
-
ui->pushButton_close->setEnabled(true);
-
ui->pushButton_save->setEnabled(true);
-
ui->pushButton_Excel->setEnabled(true);
-
ui->pushButton_update->setEnabled(true);
-
getname();
-
}
-
}
-
-
-
/*******************************************************************************/
-
-
-
void AddDialog::on_pushButton_Excel_clicked() //打开一个Excel文件，完了要调用Excel解析函数
-
{
-
QString filename = QFileDialog::getOpenFileName(this);
-
if(!filename.isEmpty())
-
{
-
readExcel(filename);
-
}
-
}
-
//自定义延时函数 //无阻塞延时函数
-
void AddDialog::delaymsec(int msec)
-
{
-
QTime dieTime = QTime::currentTime().addMSecs(msec);
-
while (QTime::currentTime()<dieTime)
-
{
-
QCoreApplication::processEvents(QEventLoop::AllEvents,100);
-
}
-
}
文章来源: dreamlife.blog.csdn.net，作者：DreamLife.，版权归原作者所有，如需转载，请联系作者。
原文链接：dreamlife.blog.csdn.net/article/details/47339341
【版权声明】本文为华为云社区用户转载文章，如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）