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 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.
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.
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: 3355
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
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: 3355
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
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
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!
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: 3355
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
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!
Previous Topic: Outlook automation with MAPIEx
Next Topic: LEMON - a Library for Efficient Modeling and Optimization in Networks
Goto Forum:
  


Current Time: Thu Mar 28 22:20:12 CET 2024

Total time taken to generate the page: 0.01567 seconds