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 » Ole Automation [FEATURE REQUEST?]
Re: Ole Automation [FEATURE REQUEST?] [message #21173 is a reply to message #21169] Wed, 06 May 2009 14:27 Go to previous messageGo to previous message
koldo is currently offline  koldo
Messages: 3358
Registered: August 2008
Senior Veteran
tojocky wrote on Wed, 06 May 2009 12:25

Hello Koldo!
No problems! I created this temporarily, because I needed this today. You can change as you want, no problems, I only went to suggest this realization!

Will be great set cell/range format:

in MSExcel can be:

Cells(row, col).NumberFormat = "@"


The problems is when i try to write a number as text!



Hello tojocky

Now there is not included a way to set the format, but when you write text, number or dates they has to appear right.

In the demo you see:
	sheet.SetValue(2, 2, "=A7*B5");
	sheet.SetValue(3, 21, "Hello");
	sheet.SetValue("BD25", 23242.343);
	sheet.SetValue("B26", GetSysTime());


The output of this should be as expected.

Could you explain me what you need with more detail?.

Best regards
Koldo


Best regards
IƱaki
 
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
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
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
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
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
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: MAPIEx works with MinGW
Next Topic: [Controls4U] IE shows script errors
Goto Forum:
  


Current Time: Tue Apr 30 01:39:52 CEST 2024

Total time taken to generate the page: 0.06130 seconds