int t = model->rowCount();
int b = -1;
int l = model->columnCount();
int r = -1;
QList<QModelIndex> indexes = view->selectionModel()->selection().indexes();
foreach(QModelIndex index, indexes) {
t = qMin(t, index.row());
b = qMax(b, index.row());
l = qMin(l, index.column());
r = qMax(r, index.column());
}
if ( r <0 ) return;
if ( b <0 ) return;
QString data = "<!--StartFragment-->\n";
data += "<table>";
for (int row=t;row<=b;row++) {
data += "<tr>\n";
for (int col=l;col<=r;col++) {
QVariant v = model->data( model->index(row,col) );
if ( v.canConvert(QVariant::Double) ) data += " <td x:num>";
else data += " <td>";
data += v.toString();
data += "</td>\n";
}
data += "</tr>\n";
}
data += "</table>";
data += "<!--EndFragment-->\n";
QMimeData * mimeData = new QMimeData;
mimeData->setHtml( data );
QApplication::clipboard()->setMimeData(mimeData);
class CopySelectedCellsAction(QtGui.QAction):
def __init__(self, table_widget):
if not isinstance(table_widget, QtGui.QTableWidget):
raise ValueError(str('CopySelectedCellsAction must be initialised with a QTableWidget. A %s was given.' % type(table_widget)))
super(CopySelectedCellsAction, self).__init__("Copy", table_widget)
self.setShortcut('Ctrl+C')
self.triggered.connect(self.copy_cells_to_clipboard)
self.table_widget = table_widget
def copy_cells_to_clipboard(self):
if len(self.table_widget.selectionModel().selectedIndexes()) > 0:
# sort select indexes into rows and columns
previous = self.table_widget.selectionModel().selectedIndexes()[0]
columns = []
rows = []
for index in self.table_widget.selectionModel().selectedIndexes():
if previous.column() != index.column():
columns.append(rows)
rows = []
rows.append(index.data())
previous = index
columns.append(rows)
print columns
# add rows and columns to clipboard
clipboard = ""
nrows = len(columns[0])
ncols = len(columns)
for r in xrange(nrows):
for c in xrange(ncols):
clipboard += columns[c][r]
if c != (ncols-1):
clipboard += '\t'
clipboard += '\n'
# copy to the system clipboard
sys_clip = QtGui.QApplication.clipboard()
sys_clip.setText(clipboard)
可以执行类似于Excel的复制粘贴格式,通过剪贴板传递表数据: copy()的实现大约是:
对于paste(),您只需要实现这种html表的简单解析。 然后,您也可以复制粘贴到/从Excel或其他类似于表的应用程序。
另一种标准方法(Excel和其他处理表的应用程序也支持这种方法)是为单元格分隔符分隔的纯文本QClipboard data tab。用于形成制表符分隔文本的代码非常相似,但对paste()的解析更加简单。
这是我创建的一个QAction,用于将选定单元格复制到剪贴板。 基本上,当初始化QAction时,您会向它传递一个绑定到的表小部件。触发操作时,将获取选定的单元格,将其排序为行和列,并将文本复制到剪贴板。
相关问题 更多 >
编程相关推荐