Guest User

Untitled

a guest
Dec 14th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. void ExcelExportHelper::SetCellValue(int lineIndex, int columnIndex, QString value)
  2. {
  3. if(!m_sheet ) {
  4. qDebug() << Q_FUNC_INFO << "!m_sheet";
  5. return;
  6. }
  7. QAxObject *cell = m_sheet->querySubObject("Cells(int,int)", lineIndex, columnIndex);
  8. if(!cell ) {
  9. qDebug() << Q_FUNC_INFO << "!cell";
  10. return;
  11. }
  12. cell->setProperty("Value",value);
  13. }
  14.  
  15. cell->setProperty("Width",300);
  16.  
  17. QAxObject *rangec = m_sheet->querySubObject( "Range(const QVariant&)",QVariant(QString("E1")));
  18. // получаю указатель на строку
  19. QAxObject *razmer = rangec->querySubObject("Columns");
  20. // устанавливаю её размер.
  21. razmer->setProperty("ColumnWidth",80);
Add Comment
Please, Sign In to add comment