Advertisement
Guest User

Untitled

a guest
Dec 12th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. auto excel = new QAxObject("Excel.Application");
  2. auto workbooks = excel->querySubObject("Workbooks");
  3. auto workbook = workbooks->querySubObject("Open(const QString&)","c:\\temp\\test.xlsx");
  4. auto sheets = workbook->querySubObject("Worksheets");
  5. auto sheet = sheets->querySubObject("Item(int)", 1);
  6.  
  7. // read the first cells in row 1..5
  8. for (int r = 1; (r <= 5); ++r)
  9. {
  10. auto cCell = sheet->querySubObject("Cells(int,int)",r,1);
  11. qDebug() << cCell->dynamicCall("Value()").toInt();
  12. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement