| 
 | 
 | 
 
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 Nov 04 05:22:32 CET 2025 
 Total time taken to generate the page: 0.06342 seconds 
 |   
 |  
  |