|
|
Home » Developing U++ » UppHub » OfficeAutomation: how to get Excel Range
OfficeAutomation: how to get Excel Range [message #46785] |
Thu, 04 August 2016 17:16  |
iST1
Messages: 107 Registered: August 2013
|
Experienced Member |
|
|
Is there a fundamental opportunity to add method for getting Excel Range instead of access to cells in a cycle GetValue(i, j)? Now access by GetValue when cells in the table ~100x100 very slow in the case when GetNumTabs ~ 1000
[Updated on: Thu, 04 August 2016 17:17] Report message to a moderator
|
|
|
|
|
Re: OfficeAutomation: how to get Excel Range [message #46792 is a reply to message #46791] |
Mon, 08 August 2016 17:36   |
iST1
Messages: 107 Registered: August 2013
|
Experienced Member |
|
|
In TheIDE v9251 i found a group of methods Matrix***, but still can not get the value
For example, i'm trying to get left 2x2 matrix:
sheet.OpenSheet("C:/1.xls", true);
sheet.Select(1, 1, 2, 2);
Vector<Vector<::Value> > data;
data.SetCount(2);
data[0].SetCount(2);
data[1].SetCount(2);
sheet.MatrixAllocate(2, 2);
sheet.MatrixFill(2, 2, data);
::Value &val = data[1][1];
int d = val;
sheet.MatrixFillSelection();
d = val;
sheet.MatrixFill(2, 2, data);
d = val;
sheet.Quit();
You can make a small example? (Matrix** is unused in Bazaar/OfficeAutomation_demo_console)
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Tue Feb 18 22:55:26 CET 2025
Total time taken to generate the page: 0.02559 seconds
|
|
|