Home » Developing U++ » UppHub » Ole Automation [FEATURE REQUEST?]
Re: Ole Automation [FEATURE REQUEST?] [message #19776 is a reply to message #17864] |
Sat, 17 January 2009 00:22   |
 |
koldo
Messages: 3443 Registered: August 2008
|
Senior Veteran |
|
|
Hello all
I am very happy to include in Bazaar the Automation library and a console demo.
It handles OpenOffice Calc and Writer and Microsoft Excel and Word.
I have prepared it thinking in simplicity. For example:
OfficeDoc doc;
if (OfficeDoc::IsAvailable("Open"))
doc.Init("Open")
else if (OfficeDoc::IsAvailable("Microsoft"))
doc.Init("Microsoft")
else
return;
doc.SetFont("Arial", 14);
doc.SetBold(true);
doc.WriteText("Hello all!");
doc.SetFont("Arial", 12);
doc.SetBold(false);
doc.SetItalic(true);
doc.WriteText("\n\nNon me latet [To replace] nonnullos vestrum");
doc.Select();
doc.Replace("[To replace]", "replaced text");
doc.Print();
doc.SaveAs("FileDemo", "doc");
doc.Quit();
So with the same set of functions it manages OpenOffice and Microsoft Office transparently fo the programmer.
The main classes declaration is like this:
class OfficeSheet
{
public:
OfficeSheet();
~OfficeSheet();
static bool IsAvailable(String type);
bool Init(char *type);
bool AddSheet(bool visible);
bool OpenSheet(String fileName, bool visible);
bool SetValue(int col, int row, Value value);
bool SetValue(String cell, Value value);
Value GetValue(int col, int row);
Value GetValue(String cell);
bool Replace(Value search, Value replace);
bool SetBold(int col, int row, bool bold);
bool SetBold(String cell, bool bold);
bool SetBold(bool bold);
bool SetFont(int col, int row, String name, int size);
bool SetFont(String cell, String name, int size);
bool SetFont(String name, int size);
bool Select(String range);
bool Select(int fromX, int fromY, int toX, int toY);
bool Select();
bool Print();
bool SaveAs(String fileName, String type = "xls");
bool Quit();
};
class OfficeDoc
{
public:
OfficeDoc();
~OfficeDoc();
static bool IsAvailable(char *program);
bool Init(char *type);
bool AddDoc(bool visible);
bool OpenDoc(String fileName, bool visible);
bool SetFont(String font, int size);
bool SetBold(bool bold);
bool SetItalic(bool italic);
bool WriteText(String value);
bool Select();
bool Replace(String search, String replace);
bool Print();
bool SetSaved(bool);
bool SaveAs(String fileName, String type = "doc");
bool Quit();
};
Unfortunately it only works in Windows (MinGW and MSC) using Ole Automation. As I have explained before the OpenOffice official interface called UNO has been too much for me until now.
Best regards
Koldo
Best regards
IƱaki
|
|
|
 |
|
Ole Automation [FEATURE REQUEST?]
By: koldo on Sun, 31 August 2008 21:20
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Sat, 18 October 2008 21:02
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: mirek on Sat, 08 November 2008 14:38
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Sun, 09 November 2008 17:11
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: mirek on Sun, 16 November 2008 18:50
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Wed, 19 November 2008 08:00
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Thu, 04 December 2008 12:09
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Tue, 30 December 2008 10:49
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Sat, 17 January 2009 00:22
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Tue, 05 May 2009 13:06
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Tue, 05 May 2009 15:03
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Tue, 05 May 2009 15:52
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Tue, 05 May 2009 16:53
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Tue, 05 May 2009 21:33
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Wed, 06 May 2009 00:02
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Wed, 06 May 2009 06:05
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Wed, 06 May 2009 08:34
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Wed, 06 May 2009 09:52
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Wed, 06 May 2009 11:52
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Wed, 06 May 2009 12:25
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Wed, 06 May 2009 14:27
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Wed, 06 May 2009 15:58
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Thu, 07 May 2009 00:24
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Thu, 07 May 2009 09:18
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Tue, 05 May 2009 13:57
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Thu, 07 May 2009 22:55
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Fri, 08 May 2009 08:16
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Tue, 12 May 2009 23:12
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Wed, 13 May 2009 14:09
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Wed, 13 May 2009 14:59
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Wed, 13 May 2009 23:09
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: mr_ped on Thu, 14 May 2009 08:14
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: mr_ped on Fri, 15 May 2009 14:26
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Fri, 15 May 2009 16:18
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: mr_ped on Mon, 18 May 2009 08:29
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Mon, 18 May 2009 10:23
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: tojocky on Tue, 09 June 2009 11:17
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Tue, 09 June 2009 16:11
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Thu, 19 September 2013 16:18
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Fri, 20 September 2013 10:07
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Fri, 20 September 2013 10:13
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: Klugier on Fri, 20 September 2013 16:41
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Sat, 21 September 2013 10:16
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Mon, 23 September 2013 06:49
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Mon, 23 September 2013 10:04
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Mon, 23 September 2013 10:21
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Mon, 23 September 2013 13:17
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Mon, 23 September 2013 15:29
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Mon, 23 September 2013 16:07
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Mon, 23 September 2013 16:31
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Tue, 24 September 2013 18:47
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Thu, 26 September 2013 05:53
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Thu, 26 September 2013 16:05
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Thu, 26 September 2013 17:47
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Fri, 27 September 2013 11:12
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Fri, 27 September 2013 11:32
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Mon, 30 September 2013 08:24
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Mon, 30 September 2013 08:57
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Mon, 30 September 2013 10:39
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Mon, 30 September 2013 10:55
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Tue, 01 October 2013 08:31
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: iST1 on Tue, 01 October 2013 10:52
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Mon, 30 September 2013 08:17
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: koldo on Sun, 24 May 2009 18:36
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
|
 |
|
Re: Ole Automation [FEATURE REQUEST?]
By: keltor on Wed, 30 October 2013 08:52
|
Goto Forum:
Current Time: Sun Aug 24 04:51:50 CEST 2025
Total time taken to generate the page: 0.00671 seconds
|