qt QStandardItemModel数据导入 EXCEL 表中
//得到可以被EXcel认识的字符串
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("保存数据成功!!!!"));
}