在Qt中可以使用MVC结构显示图像处理的结果数据,有时候需要将数据保存为excel文件,便于数据记录和分析。
步骤:
- 获取表格抬头;
- 获取表格数据(注意用,和“\n”隔开);
- 选择保存文件路径和格式;
- 打开文件,写入数据;
- 关闭文件。
.csv格式文件可以使用excel文件打开,以“,”分列,以“\n”分行。
代码:
函数介绍:
static QString getSaveFileName(QWidget *parent = Q_NULLPTR,//父窗口
const QString &caption = QString(),//弹出路径选择框的名
const QString &dir = QString(),//文件保存的路径,使用“/”隔开
const QString &filter = QString(),//文件格式
QString *selectedFilter = Q_NULLPTR,
Options options = Options())
下面代码出自:xujun3614
https://blog.csdn.net/xujun3614/article/details/105011240/
QString Form1::getTableData(QStandardItemModel* table)
{
QString stringData;
int i=0, j=0;
for(int i=0; i<table->columnCount(); i++)
{
stringData+= table->headerData(i, Qt::Horizontal ).toString();
stringData+=",";
}
stringData = stringData+"\n";
for(i=0; i<table->rowCount(); i++)
{
for(j=0; j<table->columnCount(); j++)
{
stringData+=table->data(table->index(i, j)).toString()+",";
}
stringData+="\n";
}
return stringData;
}
//将数据放入到Excel表中
void Form1::inputExcel(QString data, QString saveFileName)
{
QString fileName = QFileDialog::getSaveFileName(this, tr("Save File"), saveFileName, tr("file ( *.csv)"));
if(fileName == "")
{
QMessageBox::critical(this,tr("错误"),tr("没有设置文件名称!!!!"));
return;
}
QTextCodec *code;
code = QTextCodec::codecForName("GB18030");
std::string strCountBuffer = (code->fromUnicode(data)).data();
std::string strbuffer = (code->fromUnicode(fileName)).data();
FILE *fileWrite = fopen( strbuffer.c_str(),"w");
QFile file;
file.open(fileWrite, QIODevice::WriteOnly);
file.write(strCountBuffer.c_str(), qstrlen(strCountBuffer.c_str()));
file.close();
QMessageBox::critical(this,tr("提示"),tr("保存数据成功!!!!"));
}
稍作了一点改变:
头文件:
#include<QFILE>
#include<QMessageBox>
#include<QFileDialog>
#include<QTextCodec>
cpp文件
void camera_thread::getTableData(QStandardItemModel* table)
{
QString stringData;
int i = 0, j = 0;
for (int i = 0; i<table->columnCount(); i++)
{
stringData += table->headerData(i, Qt::Horizontal).toString();
stringData += ",";
}
stringData = stringData + "\n";
for (i = 0; i<table->rowCount(); i++)
{
for (j = 0; j<table->columnCount(); j++)
{
stringData += table->data(table->index(i, j)).toString() + ",";
}
stringData += "\n";
}
inputExcel(stringData);
}
void camera_thread::inputExcel(QString data)
{
QString fileName = QFileDialog::getSaveFileName(NULL, tr("保存文件"), tr("D:/data_test/part"), tr("file ( *.csv)"));
if (fileName == "")
{
QMessageBox::critical(this, tr("错误"), tr("没有设置文件名称!!!!"));
return;
}
QTextCodec *code;
code = QTextCodec::codecForName("GB18030");
std::string strCountBuffer = (code->fromUnicode(data)).data();
std::string strbuffer = (code->fromUnicode(fileName)).data();
FILE *fileWrite = fopen(strbuffer.c_str(), "w");
QFile file;
file.open(fileWrite, QIODevice::WriteOnly);
file.write(strCountBuffer.c_str(), qstrlen(strCountBuffer.c_str()));
file.close();
QMessageBox::critical(this, tr("提示"), tr("保存数据成功!!!!"));
}
结果: