U++ framework
Do not panic. Ask here before giving up.
Home » Developing U++ » UppHub » OfficeAutomation GetText function for excel
OfficeAutomation GetText function for excel [message #32692] Thu, 02 June 2011 09:47 Go to next message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

Hello Koldo,

First of all I want to thank you for this great library.

I propose to add new method Value GetText(int col, int row) for Excel wrappers (MS and open). This method is same as GetValue but it returns the formated text value.

The modified files are attached.

Report message to a moderator

Re: OfficeAutomation GetText function for excel [message #32693 is a reply to message #32692] Thu, 02 June 2011 09:52 Go to previous messageGo to next message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

If somebody wants to generate word documents in base of excel data file and a Word layout template I attached the source code of this solution.

It can be uploaded in bazaar as demo of office automation.

Report message to a moderator

Re: OfficeAutomation GetText function for excel [message #32705 is a reply to message #32692] Thu, 02 June 2011 16:38 Go to previous messageGo to next message
koldo is currently offline  koldo
Messages: 3458
Registered: August 2008
Senior Veteran
tojocky wrote on Thu, 02 June 2011 09:47

Hello Koldo,

First of all I want to thank you for this great library.

I propose to add new method Value GetText(int col, int row) for Excel wrappers (MS and open). This method is same as GetValue but it returns the formated text value.

The modified files are attached.

Hello Ion

Do you mean that in case of a formula, GetValue() returns the formula and GetText() returns the result?

Best regards
Iñaki

Report message to a moderator

Re: OfficeAutomation GetText function for excel [message #32706 is a reply to message #32693] Thu, 02 June 2011 16:44 Go to previous messageGo to next message
koldo is currently offline  koldo
Messages: 3458
Registered: August 2008
Senior Veteran
tojocky wrote on Thu, 02 June 2011 09:52

If somebody wants to generate word documents in base of excel data file and a Word layout template I attached the source code of this solution.

It can be uploaded in bazaar as demo of office automation.

Really nice sample Smile.

Best regards
Iñaki

Report message to a moderator

Re: OfficeAutomation GetText function for excel [message #32707 is a reply to message #32705] Thu, 02 June 2011 17:38 Go to previous messageGo to next message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

koldo wrote on Thu, 02 June 2011 17:38


Hello Ion

Do you mean that in case of a formula, GetValue() returns the formula and GetText() returns the result?

Yes

Report message to a moderator

Re: OfficeAutomation GetText function for excel [message #32708 is a reply to message #32706] Thu, 02 June 2011 17:39 Go to previous messageGo to next message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

koldo wrote on Thu, 02 June 2011 17:44

tojocky wrote on Thu, 02 June 2011 09:52

If somebody wants to generate word documents in base of excel data file and a Word layout template I attached the source code of this solution.

It can be uploaded in bazaar as demo of office automation.

Really nice sample Smile.

Thank you!

Report message to a moderator

Re: OfficeAutomation GetText function for excel [message #32711 is a reply to message #32707] Thu, 02 June 2011 22:01 Go to previous messageGo to next message
koldo is currently offline  koldo
Messages: 3458
Registered: August 2008
Senior Veteran
tojocky wrote on Thu, 02 June 2011 17:38

koldo wrote on Thu, 02 June 2011 17:38


Hello Ion

Do you mean that in case of a formula, GetValue() returns the formula and GetText() returns the result?

Yes

Included.

Best regards
Iñaki

Report message to a moderator

Re: OfficeAutomation GetText function for excel [message #32719 is a reply to message #32711] Fri, 03 June 2011 09:08 Go to previous message
tojocky is currently offline  tojocky
Messages: 607
Registered: April 2008
Location: UK
Contributor

koldo wrote on Thu, 02 June 2011 23:01


Included.

Thank you!

Report message to a moderator

Previous Topic: Outlook automation with MAPIEx
Next Topic: LEMON - a Library for Efficient Modeling and Optimization in Networks
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Sat Apr 25 21:51:48 GMT+2 2026

Total time taken to generate the page: 0.00615 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.2.0.
Copyright ©2001-2025 FUDforum Bulletin Board Software