Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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 Go to previous messageGo to previous message
iST1 is currently offline  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)
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: bazaar/FormExample compilation error
Next Topic: Functions4U: Added LocalProcess2 and RealTimeStop
Goto Forum:
  


Current Time: Tue May 14 16:41:34 CEST 2024

Total time taken to generate the page: 0.02740 seconds