Home » Developing U++ » UppHub » OfficeAutomation: how to get Excel Range
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)
|
|
|
|
|
OfficeAutomation: how to get Excel Range
By: iST1 on Thu, 04 August 2016 17:16
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: koldo on Mon, 08 August 2016 10:14
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: koldo on Mon, 08 August 2016 15:52
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: iST1 on Mon, 08 August 2016 17:36
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: koldo on Tue, 09 August 2016 09:35
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: iST1 on Tue, 09 August 2016 18:50
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: koldo on Thu, 11 August 2016 12:05
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: iST1 on Thu, 11 August 2016 19:50
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: koldo on Fri, 12 August 2016 09:34
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: iST1 on Sat, 13 August 2016 19:25
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: iST1 on Mon, 15 August 2016 19:48
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: iST1 on Sat, 20 August 2016 07:26
|
|
|
Re: OfficeAutomation: how to get Excel Range
By: koldo on Sat, 20 August 2016 16:57
|
Goto Forum:
Current Time: Tue May 14 16:41:34 CEST 2024
Total time taken to generate the page: 0.02740 seconds
|